• Resolved rsmartens

    (@rsmartens)


    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..

    SELECT
    gp.nom AS LastName,
    gp.prenom AS FirstName,
    CASE WHEN EXISTS(
    SELECT
    1
    FROM payment p
    WHERE p.pid = gp.id AND p.contribution_year = YEAR(CURDATE())
    LIMIT 1) THEN 'Yes' ELSE 'No'
    END AS FeesPaidInCurrentYear,
    FROM
    person gp
    WHERE
    gp.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.