Filter query columns based on field values?

(0) Share

Report

Posted on by andreas@protektit.no

Hi,

I am developing a query that selects certain fields to be exposed through a web API. Is it possible to filter the columns to be exposed based on if they have a value or not?
Say for instance on item cards, if a boolean is set to true then the query should send 3 extra fields for those items that meet the condition, and the rest of the items are sent with the usual fields.

How can i achieve this? I can't seem to make it work with columnfilters or DataItemTableFilter.

Thanks in advance.

All responses (2)

Answers (1)

Verified answer

YUN ZHU 84,562 Super User 2025 Season 1 on at

Like (0)

Report

RE: Filter query columns based on field values?

Hi, I agree with Josh, this should be done using Page object.

More details:

Using the query as a data source for a page (Query.Open Method)

https://yzhums.com/4869/

Dynamic Visibility of Controls

https://yzhums.com/14752/

Hope this will help.

Thanks.

ZHU
Suggested answer

JAngle 95 on at

Like (0)

Report

RE: Filter query columns based on field values?

Seems too advanced for a query object. A page might be a better option