Hi,
I have to set the following query in “pull from list” activity according to a label "A" values (3, 4, 5):
A= 4 then A= 3 then A=5.
I can’t use “ORDER BY”, I think there is a way to do it by "WHERE". I set this query:
WHERE A=4, WHERE A=3, WHERE A=5
But this is invalid.
Would you please help me to write the convenient query.
Regards.
That's not what a WHERE statement does. A WHERE statement is basically a yes or no. Can this entry be pulled? Yes or No?
If you want to change the order of things you pull you need to use an ORDER BY statement.
Also you can only use the WHERE keyword once. Your query would need to look like this:
WHERE A = 3 OR A = 4 OR A = 5 ORDER BY something
In fact, "WHERE A = 4 OR A = 3 OR A = 5 " is not working as I expected. Here there is a choice between 4 or 3 or 5. But, what I want is "then" instead of "or". Pick Items of label “A” equal to 4 then Items having label “A” equal to 3 then Items having the label “A” equal to 5.
You can’t do that with just a WHERE statement. You need the ORDER BY part to enforce a certain order
@tanner.p, this isn't a simple ORDER BY, the order is: 4 THEN 5 THEN 3. So, how could I do it using ORDER BY?
ORDER BY labelName = 4 DESC, labelName DESC
The first order by puts all the label values of 4 at the top, then sorts everything else from highest to lowest.
@Regan Blackett, thank you very much for your help. this is working perfectly.
10 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
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.
