Hey
I have an array of years for example [1999,2000,2001, 2002] and I wanna only show those rows who has exactly four entries like Count(*) = 0 or Count(*) %4 = 0
How can I create a DB Statement like that? Do I have to change something in the Selectmanager for that?
Example
My Table
Name Address Years
User 1 Germany [1999,2000,2001, 2002]
User 2 French [1999,2000,2001, 2002]
User 3 Germany [1999,2000]
User 4 Germany [1999,2000,2001]
After Filter
Name Address Years
User 1 Germany [1999,2000,2001, 2002]
User 2 French [1999,2000,2001, 2002]
Thanks for helping ^^
I have an array of years for example [1999,2000,2001, 2002] and I wanna only show those rows who has exactly four entries like Count(*) = 0 or Count(*) %4 = 0
How can I create a DB Statement like that? Do I have to change something in the Selectmanager for that?
Example
My Table
Name Address Years
User 1 Germany [1999,2000,2001, 2002]
User 2 French [1999,2000,2001, 2002]
User 3 Germany [1999,2000]
User 4 Germany [1999,2000,2001]
After Filter
Name Address Years
User 1 Germany [1999,2000,2001, 2002]
User 2 French [1999,2000,2001, 2002]
Thanks for helping ^^