Filter on Grid does not work

(1) Share

Report

Posted on by CRSW

593

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)

CRSW 593 on at

Like (0)

Report

Filter on Grid does not work

@Martin

Here it it. Looks good to me
Martin Dráb 230,370 Most Valuable Professional on at

Like (0)

Report

Filter on Grid does not work

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

Like (0)

Report

Filter on Grid does not work

Hi Arnaud

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

Best regards

Chris
André Arnaud de Cal... 291,359 Super User 2024 Season 2 on at

Like (0)

Report

Filter on Grid does not work

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 593 on at

Like (0)

Report

Filter on Grid does not work

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())));
Mohamed Amine Mahmoudi 9,738 Super User 2024 Season 2 on at

Like (0)

Report

Filter on Grid does not work

Hi @CRSW,

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

Best regards,

Mohamed Amine MAHMOUDI