Function: convertDelimitedListToSQL?

convertDelimitedListToSQL is really just pure UI function, so this is question to UX team, not for Patrick and I.
Description is:

This function gets a SQL compatible list for use in SQL where clauses. Example item one~item two~item three~ -----> ‘item one’,‘item two’,‘item three’ OR 1~2~3~ -----> 1, 2, 3

As for tilda separated list in BAQ this is what I thought about, when I said I saw it here:

So you can use function like [Ice].num_entries(QuoteDtl.ConfigData_c, ‘~’ ) > 0 but be aware that in criteria it will be executed for every line of your table. So if there are many rows, it can be slow. Check the execution plan.
Or there is a KB how to do it in BAQ CTE;

or simplier Jose’s example

4 Likes