SPM and default filters

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
Posts: 19
Joined: 2018-01-04 18:49

SPM and default filters

Post by SSchimkat » 2018-10-08 17:26

Hi everyone

Just installed the Search Page Maker .. but ran into troubles with my default filters. The following default filters works just fine without the SPM:

Code: Select all

                $options->DefaultSortField = '7 asc, 12 asc';
                $options->DefaultSortDirection = '';

                if(!$_POST['FilterField'][1] && !$_GET['FilterField'][1]){
                         addFilter(1, 'and', 15, 'equal-to', 'No');
                         addFilter(2, 'and', 14, 'not-equal-to', 'UAT');
                         addFilter(3, 'and', 14, 'not-equal-to', 'Completed');
.. but when using the SPM (by enabling the $options->FilterPage = 'hooks/Packages_filter.php'; line) the columnnumbers (15 and 14) hits wrong columns, and the not-equal-to comparison operator is changed to like.

How should I alter my default filter (and sorting) to work with SPM?

User avatar
Site Admin
Posts: 912
Joined: 2012-09-27 14:46

Re: SPM and default filters

Post by a.gneady » 2018-10-11 14:01

When using SPM filters, addFilters won't work correctly unless you use indices that are not being used by SPM ... So, instead of using index 1, 2 and 3 in the above example, try 13, 14 and 15 (you should start the count with a number that matches 4n + 1, where n is any integer .. For example: 1, 5, 9, 13, 17, ... etc.)
AppGini: Responsive, collaborative web db apps in minutes.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

Post Reply