Filter on Grid does not work

(1) Share

Report

Posted on by CRSW

627

I created a filter (dropdown) on a custom form. This is realted to a custom enum I created.

In the first version I had 4 enum values(0, 1, 2, 3) I filter with. Everything works fine. Now I had to add a 5th value to the enum. I add the enumvalue (4) and I do have some records in the table (they are showing the filtervalue when filter is disabled. As soon as I enable the filter (by checkbox) I cann filter the first 4 values but on the new, 5th value the grid is empty

What could be the reason?

Best regards

Chris

All responses (6)

Answers (0)

Sort by

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CRSW,

Can you please share with us more details (screenshots, code, design ...).

Best regards,

Mohamed Amine MAHMOUDI
CRSW 627 on at

Like (0)

Report
Copy link

Link copied!

New Status visible if not filtered

one of the first 4 filtervalues and active filter...WORKS

filter with new enum value, EMPTY GRID even with data in table as seen on unfiltered screenshot (1)

Here the filter code:

qbrDayEndStatus = Query.dataSourceNo(1).addRange(fieldnum(WABCashDayEndHead, DayEndStatus));

if (FilterActive.value() == NoYes::Yes)
{
FilterDayEndStatus.allowEdit(true);
qbrDayEndStatus.value(queryValue(FilterDayEndStatus.selection())));
André Arnaud de Cal... 307,445 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Chris,

After making the change with the fifth element, did you also create a new CIL and synchronize the database? Have you checked if the value in the database itself is "4" for "Keine" or does it have another enumeration value?
CRSW 627 on at

Like (0)

Report
Copy link

Link copied!

Hi Arnaud

As mentioned in my first post the values in the DB are there

Best regards

Chris
Martin Dráb 240,972 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please check the query currently used by the data source (at Query tab of Personalization form).
CRSW 627 on at

Like (0)

Report
Copy link

Link copied!

@Martin

Here it it. Looks good to me