question

Stan Davis avatar image
1 Like"
Stan Davis asked anthony.johnson edited

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 flowsqlacquire resource
5 |100000

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

1 Answer

·
anthony.johnson avatar image
1 Like"
anthony.johnson answered anthony.johnson edited

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

5 |100000

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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