List pre filter with menu and checkbox element

[7webcreator]

Hello,

I have a list that used to be pre-filtered using menus and checkbox elements before the migration to Joomla 4. Now, since the migration, it doesn't work anymore. No data is displayed. The screenshot below is the setting.

The element "scadenze" is a checkbox element. Any idea why?
Joomla 4.3.4
Fabrik Epsilon
Thank you

 

[wezetel]

Just wondering: have you an element with a double point in its name (Saldo: ) ?

 

[juuser]

How does your checkbox settings / options look like?

@wezetel , this shoudn't be an issue as it shows the element label in the prefilters' dropdown and not the value.

 

[7webcreator]

Thank you for your suggestions. I tried them all, and the results still don't display like before. Remember, the same settings worked for years before I migrated to Fabrik Epsilon.
The below screenshot is the Fabrikdebug.

The checkbox setting is nothing fancy.

 

[troester]

Have a look at WHERE condition in the "list GetData" part of the debug.

 

[7webcreator]

Below is what I have at WHERE condition in the list GetData

FROM `j25_users`
LEFT JOIN `pagamenti` AS `pagamenti` ON `pagamenti`.`utente_id` = `j25_users`.`id`
WHERE ( pagamenti.saldo <> '0' AND pagamenti.rate2 = '0' AND (pagamenti.scadenze = '2' OR pagamenti.scadenze LIKE '[\"2\"%' OR pagamenti.scadenze LIKE '%\"2\"%' OR pagamenti.scadenze LIKE '%\"2\"]') )
ORDER BY `pagamenti`.`quota_asso2` DESC, `j25_users`.`id` DESC LIMIT 50

 

[troester]

Is this looking how it should? Does it return records if directly put into phpMyAdmin?
Which values do you have (directly in the DB) for column scadenze

 

[7webcreator]

That is what I obtain when I paste it with phpMyAdmin SQL

I have number as value for the column scadenze

 

[juuser]

You are missing "SELECT *" from your PhpMyAdmin query. It should be:
SELECT * FROM 'j25_users' etc.

 

[7webcreator]

Oh sorry! Empty result.

 

[juuser]

Menu pre-filter with exactly the same setup works totally fine on my test site. Are you sure your other (not checkbox) filters are not the issue. Remove all other pre-filter and only leave the "checkbox" one. Does it work then?

 

[7webcreator]

Yes, it works when I remove the other pre-filters, both text elements (decimal format). It is also still working with the second pre-filter; however, as soon as I add the pre-filter on the "pagamenti.novembre" (text element), no results are displayed. That is something that has always worked before the migration.

 

[7webcreator]

Do you have any other tips on this issue, please?

 

[juuser]

Do exactly the same steps with the novembre element. Remove other elements from the pre-filter and check the GetData part, then test this in PhpMyAdmin and see what you get etc.

 

[7webcreator]

I appreciate your support. I have changed the pre-filter as follows, and it is now working.

 

[wezetel]

Great it works now.
Regarding the pre-filter rules you have changed essentially various things:

• For Scadenze you changed from 'novembre' to 'Novembre' (case sensitivity)
• For Novembre you changed from 'Equals 0' to 'is null' (null and 0 are not the same)
• For Saldo you now check for values greater than 0 (positive values), instead of values different from 0 (I don't believe this is the real problem).

This is just a summary what I can see between not-working and working

 

[7webcreator]

I don't know. I can only say that before the migration, the pre-filter used to function for years.