Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

LIKE Operatore not working for LIQL querry

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 

 

2 Replies 2
Boss

@kautuksahni 

MATCHES only works with Subject and Description. I do not think so it would work with anything else. 

Give kudos if you find my posts helpful or mark solution if it answers your query

@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!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.