Field API SelectValues method check if result exist

[AKN]

I'm using Field API to filter some tables. However if the value I'm filtering doesn't exist it returns all of the results in the table. I want it to show a message like "no results" or whatever it doesn't matter. How can I achieve this?

app1.field("testFilterID").selectValues(["test"], false);

[alex_colombo · Accepted solution]

Hey @AKN , for achieve this you cannot directly use Field API, I've tested and there is no response for values not available. What you can do is to create a listbox using Engine APIs, search your value into the list box data using SearchListObjectFor Engine API method, perform GetLayout method and check if your ListBox has values. This allows you to check if the value exists in all field values.

[AKN]

Thanks! I will look into it.

[AKN]

Okay so I have a data like this:
CustomerID, Quantity
CST1,           35
CST1,           12
CST100,       35
CST30,         20

customerID is mandatory and quantity is optional. I'm filtering like this:

app.field(customerFilterID).selectValues(["CST1"], false);
app.field(quantityID).selectValues(["35"], false);

shows a table that only has CST1 and 35 as Quantity, that's ok.

app.field(customerFilterID).selectValues(["CST1"], false);
app.field(quantityID).selectValues(["20"], false);

shows a table that has CST30 which I didn't select, and 20 as Quantity, that's not ok.

Toggling from false to true also didn't work.

[AKN]

This is kind of important so any help is appreciated.