Filter in the list page form on init

(0) Share

Report

Posted on by Wekey

302

Hello All,

I am having a field DMFTransfer status which is an ENUM with not started, Completed, Error as its values. I want to filter the list page while opening with all the records not eqaul to completed.

Please guide me here to achieve the same.

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

You can use initializeQuery

Was this reply helpful? Yes No
Wekey 302 on at

Like (0)

Report

Hello Ergun,

I tried the following code,

public void initializeQuery(Query _query) { QueryBuildRange transferStatusRange; super(_query); transferStatusRange = _query.dataSourceTable(tableNum(CGIPickUpdateStaging)).addRange(fieldNum(CGIPickUpdateStaging, TransferStatus)); transferStatusRange.value(SysQuery::valueNot(DMFTransferStatus::Completed)); }

But the form is filtered as expected but I couldnt able to see the completed record even if I wanted to. Hope you can understand.

Thanks

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

If you haven't specifically selected hidden, you should be able to see it with ctrl + G.

Was this reply helpful? Yes No
Wekey 302 on at

Like (0)

Report

Thanks it worked

Was this reply helpful? Yes No