Hi, in order to make the 'multiple searchable list' criteria work with Postgres, I made two changes:
in the _build_where_extralist method I made some changes to the string, which otherwise gave error because of wrong dashes. Also I changed LIKE to ILIKE for better lookup.
If a report had more than one 'database lookup criteria' , when doing an ajax lookup the searched string was put in every query, resulting in error. I added a check in the _buildquery function, so that only the right query, matching the given criteria, was modified.
Hi, in order to make the 'multiple searchable list' criteria work with Postgres, I made two changes:
in the _build_where_extralist method I made some changes to the string, which otherwise gave error because of wrong dashes. Also I changed LIKE to ILIKE for better lookup.
If a report had more than one 'database lookup criteria' , when doing an ajax lookup the searched string was put in every query, resulting in error. I added a check in the _buildquery function, so that only the right query, matching the given criteria, was modified.
Feel free to give feedback. Kind regards, Ettore