Filtering for first char in LiQL
Hi all, I have a custom component which builds a list of messages with a filter above them. The filter is just a list of alphabetical ordered chars. When the user clicks on a char the list is fil...
Forum Discussion
Hi OlivierS,
thanks for your answer. Could you please tell me what where condition I should use to check if the first char of a message subject is an "A"? I havn't found anything. In SQL I have something like the "Like" syntax but there is nothing like this in LiQL. Am I correct?
Regards,
Michael
Sorry. you're correct. It looks like the WHERE clause doesn't have a 'like' keyword (maybe for performance optimization).
You could use 'IN' or 'MATCHES' keywords, but with only one letter, it might return too much. Although, it won't only return messages starting with 'A' (or the letter you specify) but all messages containing that letter ... So you will have to apply some RegEx once the message is returned ... Try that on stage first to evaluate performance impact.
Or wait for other people to respond as my knowledge on API / LiQL / JS is limited!
