order by the smaller of field1 and field2

Question

question

Shinya O asked Jul 23, '24 Shinya O commented Jul 24, '24

order by the smaller of field1 and field2

Hi,

Is it possible to sort the list in ascending order by the smaller of field 1 and field 2? I tried the following query:

ORDER BY min(field1, field2) ASC

However, the below error was returned to the compiler console and system console.

Too many parameters in function min

time: 0.000000 exception: Exception caught in start() of activity "Pull from List" in process flow "ProcessFlow". Continuing throw...
time: 0.000000 exception: Exception caught in Executive::processeventinlist().

Is it better to prepare the smaller of field1 and field2 as field3?

Thanks in advance.order by the smaller of field1 and field2.fsm

Software Version:

FlexSim 24.0.4

query pull from list order by

order-by-the-smaller-of-field1-and-field2.fsm (29.7 KiB)

Answer 1 · 2024-07-23T09:19:46Z

Felix Möhlmann answered Jul 23, '24 Shinya O commented Jul 24, '24

"min" is also an SQL keyword, so it is interpreted in that way. You can work around this by creating a user command that does the same as min() and use that in the query.

order-by-the-smaller-of-field1-and-field2_1.fsm

As long as the field values are not dynamic I would recommend to indeed prepare a "field3" that already contains the minimum, if only to save a tiny bit of computation time, because the comparison doesn't need to run every time something is pulling from the list.

order-by-the-smaller-of-field1-and-field2-1.fsm (30.1 KiB)

· 1

Shinya O commented · Jul 24 at 02:59 AM

Actually, in my model, the field values are dynamic. Anyway, thanks for the information. I understand what the error means.

0 ·

question