AnsweredAssumed Answered

ExecuteSQL() func: Possible to order results from a WHERE..IN search?

Question asked by Devon Braun on Jul 10, 2018
Latest reply on Jul 11, 2018 by beverly

Trying to order search results based on a query making use of WHERE...IN

Is there support for some version of FIND_IN_SET or FIELD clauses?

Here are some of the calcs I've tried, so far with no luck...

 

SELECT Field1 FROM Table

WHERE Field2 in (9,5,3,7,1)

ORDER BY FIND_IN_SET(Field2, '9,5,3,7,1')

 

SELECT Field1 FROM Table

WHERE Field2 in (9,5,3,7,1)

ORDER BY FIELD(Field2, 9,5,3,7,1)

Outcomes