How to create a time SQL table of a part in the process?

Question

question

jessica S2 asked Aug 14, '19 Joseph Gillespie commented Aug 26, '19

How to create a time SQL table of a part in the process?

I need to create a table that tells me what is the life of the piece of the model. I already send it to a list and I know that I must modify the AGE, but from here I don't know how to configure it

Software Version:

FlexSim 19.1.1

sql query

333.fsm (1.2 MiB)

· 2

Joseph Gillespie commented · Aug 15, 2019 at 12:08 AM

@jessica S2

Could you explain what you mean by "what is the life of the piece of the model"? If you are going to use this table to produce a chart, you will probably need to make a statistics collector:

0 ·

capture.png (28.5 KiB)

Joseph Gillespie commented · Aug 20, 2019 at 07:14 PM

@jessica S2

Do you still need help with this?

0 ·

Answer 1 · 2019-08-20T21:22:10Z

Joerg Vogel answered Aug 20, '19

You don’t need a list to get the age of an item. There is a function that returns the time the item had entered the model

getcreationtime( obj item)

The age is the difference of current runtime time() and the creation time.

There might only one problem, if you use recycled items. The statistical attributes don’t seem to be reset when the items are entering the model again. Please test this before, you use recycled items in your model.

question