reference group in execute query

(0) Share

Report

Posted on by Petr Drevenka

Hello,

please do you know how to keep filter on form control reference group?

Example: in form there is field "Worker_Requisitioner" (reference group) it shows names of workers. In table there is RecId of HcmWorker.RecId.

I am trying to filter in form *Petr* and do some action but it is going to execute query and it will refresh (it deletes *Petr*) filter. I need to keep that string... and i tried to put code below

find range and keep him but it is not working.

qBR = SysQuery::findOrCreateRange(
    PurchReqTable_DS.query().dataSourceTable(
            tableNum(PurchReqTable)),
            fieldNum(PurchReqTable, Worker_Requisitioner)
            );
qBR.value(
    PurchReqTable_DS.queryRun().query().dataSourceTable(
            tableNum(PurchReqTable)).findRange(fieldNum(PurchReqTable, Worker_Requisitioner)).value()
            );

All responses (2)

Answers (1)

Petr Drevenka 5 on at

Like (0)

Report

RE: reference group in execute query

Hello Martin,

thank you for reply.
Verified answer

Martin Dráb 230,149 Most Valuable Professional on at

Like (1)

Report

RE: reference group in execute query

You're wrong in thinking that the *Petr* filter is applied to PurchReqTable.Worker_Requisitioner. As you correctly mentioned, that's a numeric RecId field, therefore such a filter value can't apply to it.

In fact, the range is applied to the HcmWorker table automatically joined to added under the hood to support the reference group.