Hi Team,
I am able to do this:
https://experienceleaguecommunities.adobe.com/api/2.0/search?q=SELECT count(*) FROM messages WHERE author.id = '17500690' AND board.id = 'adobe-experience-manager-discussions'
Whereas, I am unable to do this:
https://<>/api/2.0/search?q=SELECT * FROM messages WHERE author.id = '17500690' AND board.id LIKE 'adobe-experience-manager-discussions'
OR
https://<>/api/2.0/search?q=SELECT * FROM messages WHERE author.id = '17500690' AND board.id LIKE '%discussions%'
The error that I am getting is:
{"status":"error","message":"a query has not been included as the value of the q parameter","data":{"type":"error_data","code":601,"developer_message":"","more_info":""},"metadata":{}}
Is there a way to apply the LIKE operator in LIQL? I want to do some searching like "%name%".
Also, as per the documentation, if I do https://<>/api/2.0/search?q=SELECT login FROM users WHERE login LIKE '%jane%'
It should work, but I am getting the error.
The Error I am getting is:
{"status":"error","message":"a query has not been included as the value of the q parameter","data":{"type":"error_data","code":601,"developer_message":"","more_info":""},"metadata":{}}
And, If I do:
https://<>/api/2.0/search?q=SELECT%20*%20FROM%20users%20WHERE%20login%20LIKE%20%27mrudul%27
The Error that I am getting is:
{"status":"error","message":"Invalid query syntax","data":{"type":"error_data","code":604,"developer_message":"","more_info":""},"metadata":{}}
Please help me understand how to use LIKE operator and can we do LIKE type searching with wildcard characters anywhere or just with login?
Is there a way to apply the LIKE/MATCHES/CONTAINS operator in LIQL? I want to do some searching like "%name%". on ID Or href Or view_href?
Even [1] is not working:
[1] https://experienceleaguecommunities.adobe.com/api/2.0/search?q=SELECT count(*) FROM messages WHERE author.id = '17500690' AND board.view_href MATCHES "discussions"
@SudheeshN @SohilM @MohammedSh @SyedSa @Payal @Parshant @MattV @SuzieH @JohnD @AshaC @StanGromer @tyw @elbranscomb
@JasonHill @CarolineS @TeroRe @Claudius @VedanthY @Drew_C
MATCHES only works with Subject and Description. I do not think so it would work with anything else.
@VikasB thank you for looking into this. But if you see 2nd half of my post, there I am trying it on Login as well.
It is not even working for "https://<>/api/2.0/search?q=SELECT%20*%20FROM%20users%20WHERE%20login%20LIKE%20%27mrudul%27"
Here it is login on which I am trying.
Is there a way to apply the LIKE/MATCHES/CONTAINS operator in LIQL? I want to do some searching like "%name%". on ID Or href Or view_href?
Even [1] is not working:
https://experienceleaguecommunities.adobe.com/api/2.0/search?q=SELECT count(*) FROM messages WHERE author.id = '17500690' AND board.view_href MATCHES "discussions"
Welcome to the Technology board!
Curious about our platform? Looking to connect on social technology? You've come to the right place!