topic Re: Field API SelectValues method check if result exist in Integration, Extension & APIs

Field API SelectValues method check if result exist

AKN — Wed, 11 Sep 2024 09:59:02 GMT

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);

Re: Field API SelectValues method check if result exist

alex_colombo — Fri, 13 Sep 2024 13:25:01 GMT

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.

Re: Field API SelectValues method check if result exist

AKN — Fri, 13 Sep 2024 14:15:17 GMT

Thanks! I will look into it.

Re: Field API SelectValues method check if result exist

AKN — Fri, 27 Sep 2024 13:35:02 GMT

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.

Re: Field API SelectValues method check if result exist

AKN — Tue, 01 Oct 2024 12:24:51 GMT

This is kind of important so any help is appreciated.