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
.nom
ASLastName
,gp
.prenom
ASFirstName
,
CASE WHEN EXISTS(
SELECT
1
FROMpayment
p
WHEREp
.pid
=gp
.id
ANDp
.contribution_year
= YEAR(CURDATE())
LIMIT 1) THEN 'Yes' ELSE 'No'
END ASFeesPaidInCurrentYear
,
FROMperson
gp
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)
- You must be logged in to reply to this topic.