How to add dynamic value to the query datasource range

(1) Share

Report

Posted on by Walid12

Dear All,

I have a query which I use in a form, and in the query I want to filter a datasourse filed and the value I want to add from a display method in a table.

Need your kind support please.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

This is not possible; you'll need to come up with a better design.

First of all, look at what the display method does and consider if you can use a join, a SysQueryRangeUtil method or something. If you want the current date, you can forget display methods and simply use (day()) value instead.

If it's not possible, consider rewriting the display method to SQL, creating a view and using the SQL code in a computed column.

Was this reply helpful? Yes No