topic Can I put "ORDER BY ASC" or "ORDER BY DESC" conditional? in FlexSim Forum

Can I put "ORDER BY ASC" or "ORDER BY DESC" conditional?

pinakin_k — Fri, 09 Apr 2021 16:43:04 GMT

[ FlexSim 20.2.3 ]

In my application i want to make the order ascending or descending based on the condition at the pull. is it possible to do than in the Pull From List activity?

Re: Can I put "ORDER BY ASC" or "ORDER BY DESC" conditional?

joerg_vogel_HsH — Fri, 09 Apr 2021 21:49:10 GMT

perhaps you can do it in a previously activity and parse it as $ parameter into a query by a label.

Or you concatenate a string to parse in a query for a custom code.

Re: Can I put "ORDER BY ASC" or "ORDER BY DESC" conditional?

jason_lightfoot_adsk — Fri, 09 Apr 2021 22:34:53 GMT

I've done this using a decide activity sending a token to one of two pulls - one that does ASC, the other DESC - which is simple.

If you want it in a single pull activity you could ORDER BY myexpression ASC and have myexpression as an additional field on the list that is some value multiplied by a pullers label value (eg. ascmultiplier) which changes between 1 and -1 depending on whether you want ASC or DESC.

So the expression could be something like this:

value.sortcriterion*puller.ascmultiplier

Re: Can I put "ORDER BY ASC" or "ORDER BY DESC" conditional?

Ben_WilsonADSK — Thu, 15 Apr 2021 02:03:40 GMT

Hi @Pinakin K, was jason.lightfoot's answer helpful? If so, please click the red "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

Re: Can I put "ORDER BY ASC" or "ORDER BY DESC" conditional?

pinakin_k — Mon, 26 Apr 2021 21:26:38 GMT

@jason.lightfoot

Thanks!

I just returned the Query string in the pull Query as ASC or DSC depending on the condition. It also works.