Search for a specific word using Liql query
Hi , I need to search whether the subject contains a specific word using Liql query . Eg : I am trying to get the messages using select * from messages . I am getting the response with a list of...
Forum Discussion
See documentation here: https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages#constraints
Ex:
SELECT * FROM messages WHERE subject MATCHES 'wireless'
Thanks for the reply . I have one more query , I am trying to get the list of latest discussions where the subject matches a certain query , but I am getting the replies also in the result .
In the result , the subject shows as "Vs: *********" , where 'Vs' I believe is a reply .
Is it possible to get the result filtering the replies?
auswin- Add depth = 0 to your query. It will filter all the replies and will return only topics.
SELECT * FROM messages WHERE subject MATCHES 'wireless' and depth = 0
Give kudos if you find my posts helpful or mark solution if it answers your query
Tariq
