Table app based on DB view using filters
-
There seems to be an issue with filters on columns in a view which are not defined as a mapping of a table field, but are the result of a sub query in the view definition.
The problem is clearly due to the fact the underlying 'table' for the table app is a view. When I create a temporary table as select * from the view, and clone the app, the filter works fine...
An example view would be this one with 3 columns..
SELECTgp.nomASLastName,gp.prenomASFirstName,
CASE WHEN EXISTS(
SELECT
1
FROMpaymentp
WHEREp.pid=gp.idANDp.contribution_year= YEAR(CURDATE())
LIMIT 1) THEN 'Yes' ELSE 'No'
END ASFeesPaidInCurrentYear,
FROMpersongp
WHEREgp.statut= 'Member'
A filter on the FeesPaidInCurrentYear does not seem to work properly.
It works fine on the same app on a table created as select * from the view.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘Table app based on DB view using filters’ is closed to new replies.