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
... View more