topic How to use Expression in "searchResults" method (App API)? in Integration, Extension & APIs

How to use Expression in "searchResults" method (App API)?

ikomlyakov1929 — Mon, 02 Apr 2018 14:44:57 GMT

Hi,

I'm trying to implement search and filter functionality for my extension. For this purpose I'm using searchResult method.‌

As I understand this method could search by field in the model, but not by expression.

So the question is: How to search by Expression with help of API?

(For example: we have we have following fields in the model: UserName, ChildrenCount.

I want to search by field =if(not IsNull(ChildrenCount) or ChildrenCount = 0, UserName))

Thanks

Re: How to use Expression in "searchResults" method (App API)?

alextimofeyev — Tue, 03 Apr 2018 13:14:17 GMT

Hi Ilya,

we've used selectMatch method to accomplish searching by expression to select values in a field.

Alex

Re: How to use Expression in "searchResults" method (App API)?

ikomlyakov1929 — Tue, 03 Apr 2018 17:30:54 GMT

Hi Alex,

Thank you for answer.

I've tried Field API, but faced the trouble that It does not filter values if the expression is not single field like 'UserName' but the one that I noticed before. Here is my code (I removed class names to make it readable):

var myfield= app.field(fields).getData(); // <-- this works well

myfield.OnData.bind( function() {

myfield.rows.forEach( function(row, i) {

$element.find("ul").append("<li data-index='" + row.qElemNumber + "'>" + row.qText + "</li>");

});

$element.find("li").click( function() {

app.field(fields).select([$(this).data("index")], true, true); // <-- this method does not work for field like "=if(...)"

});

Thanks

Ilya

Re: How to use Expression in "searchResults" method (App API)?

alextimofeyev — Wed, 04 Apr 2018 08:00:57 GMT

In your example, were you trying to limit the values in field UserName to those for which the condition of ChildrenCount = 0 or null is true?

Re: How to use Expression in "searchResults" method (App API)?

ikomlyakov1929 — Wed, 04 Apr 2018 12:35:23 GMT

This is an example of expression that I would like to use for filtering. It could be the different type of "if" like expression.

Actually I found the walk around for this issue. Found how to have an ability to search with search suggestions, how to search and select by expression fields. That is something that i need to avoid using APP API search methods.

Thanks.