Using SetFilter With two Filter Conditions

(0) Share

Report

Posted on by Indira88

980

Hi,

Need a little piece of information on using SetFilter for a page by using multiple filters.

For E.g. in the jobs List i want to filter the Jobs page using Blocked and the Status Field through an extension.

How could I achieve this,

my present code of using SetFilter not working using two fields one after the other,it somehow overwrites the first condition to the second consition.

trigger OnOpenPage()

var

JobBlocked: Enum "Job Blocked";

JobStatus: Enum "Job Status";

begin

Rec.SetFilter(Rec.Status, '<>%1', JobStatus::Completed);

Rec.SetFilter(Rec.Blocked, '%1', JobBlocked::" ");

end;

Thanks

Indira

I have the same question (0)

All responses (10)

Answers (1)

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

You can use filters on multiple fields. Can you share your whole code ?

Are you sure you don't have other extension that affecting your code.

Was this reply helpful? Yes No
Indira88 980 on at

Like (0)

Report

hi Teddy,

This is the code in the Job List PageExtension:

   trigger OnOpenPage()

    var

        JobBlocked: Enum "Job Blocked";

        JobStatus: Enum "Job Status";

    begin

        Rec.SetFilter(Rec.Blocked, '<>%1', JobBlocked::All);

        Rec.SetFilter(Rec.Status, '=%1&=%2&=%3&=%4', JobStatus::Planning, JobStatus::Open, JobStatus::Quote, JobStatus::Completed);

    end;

it does not work however

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Are you sure you have records with those filters ? can you place same filter on a page and view the records ?

Was this reply helpful? Yes No
Indira88 980 on at

Like (0)

Report

yes I have records the problem is in the filter pane the filter parameters do not show when I am adding the secnd filter ,with the first filter it works fine.I need records where( Status<> Completed and Blocked = All)

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

What do you mean by filter parameters are not available when adding the second filter

Was this reply helpful? Yes No
Indira88 980 on at

Like (0)

Report

So Whwnever I am adding a second filter condition in the filter pane the fields are showing without the filters working which means the fields on the filter pane have nothing checked or unchecked.

Regards,

Indira

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Can you please send us the screenshot of those?

Was this reply helpful? Yes No
Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

Are you sure you don't have two page extensions modifying the same page ?

Was this reply helpful? Yes No
Indira88 980 on at

Like (0)

Report

to Clarify I do have two different page extensions but have not used a filter in the previous extension

Was this reply helpful? Yes No
Verified answer

Indira88 980 on at

Like (0)

Report

I have Set a different filter now that populates based on the previous two conditions,to avoid using two conditions.In the pane shown below the filters Status and Blocked show but how it is showing in this screenshot with all the conditions it does not show the conditions when two filtes are added.I am not able to give you the screenshot xctly because I have reversed the code with the solution stated above.

Thanks,

Indira

Was this reply helpful? Yes No