Acquire Resource ORDER BY CASE Statement Invalid

Question

question

Stan Davis asked Nov 11, '16 anthony.johnson edited Nov 11, '16

Acquire Resource ORDER BY CASE Statement Invalid

I am assuming an ORDER BY CASE statement is not allowed for an Acquire Resource query. Is that correct? I receive an 'invalid SqlQuery object' error for the following statement example...

ORDER BY CASE WHEN myLabel = 2 THEN 1 ELSE 2 END

Thanks

process flow sql acquire resource

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2016-11-11T21:39:36Z

anthony.johnson answered Nov 11, '16 anthony.johnson edited Nov 11, '16

That's correct, FlexSim's SQL doesn't yet support the ORDER BY CASE clause

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question