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

All responses (4)

Answers (1)

Wekey 302 on at

Like (0)

Report

RE: Filter in the list page form on init

Thanks it worked
ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: Filter in the list page form on init

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

Like (0)

Report

RE: Filter in the list page form on init

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
Verified answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: Filter in the list page form on init

You can use initializeQuery