Fail to get result when specifying expression and advanced expression
I am building an Advanced Expression (aq) when the user provides an expression in the Search box. For example, if the user enters 2233 and clicks on a specific tab (Salesforce app), I will build an advanced query to search an indexed field for that string. Here is the aq: @sfsolutionwbanumberc /= ".2233."
The sfsolutionwbanumberc field is Free Text Searchable.
The REST Query has q=2233 and aq=@sfsolutionwbanumberc /= ".2233." but no results are returned. But if I disable the building of the aq and just enter '@sfsolutionwbanumberc /= ".2233."' in the Search box, I get the expected results. Searching for just '2233' does not return any results since that value is not in the body of the documents that are searched but the text is in the indexed field sfsolutionwbanumberc .
I also tried using a logical operator with q and aq but no luck.
Is there a way to use q and aq in the same REST query ?
And if you enter both search parameter in the search box, do you get any result ?
That is :
directly in the search box