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.
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.
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
Thanks!
I just returned the Query string in the pull Query as ASC or DSC depending on the condition. It also works.
15 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.