Announcement

Collapse
No announcement yet.

Create DB Select Statement

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Create DB Select Statement

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

Working...
X