How can I change this in a way that al the dates are in one row behind the same Patchname?
Try to add the MAX-function instead of the Group function on the columns with the if()-function. The Patch column is correct.
Acctually the Original database looks like:
What I want is to show which patch is created in which Database. I used If(DATABASE = "cogasp01", AUD_CREATIE_DATUM, " ") to change the table into a form in which is shown in my first post. But now I want to show the creatiedates in one row.
I know I do something wrong, but I don't know how to fix it.
Depends what you want to do, but imho, a simple advanced query will make it easier?
I want an easy way to show, which patch isn't installed in which DB.
you have to pivot the table i think.
Does That work in Outsystems? And how should I do That?
Like I said before, use advanced queries.
Mind you, the limitation is in the fact you cannot pivot dynamically, you have to know upfront how many columns you end up with.
Thanks, I will try to do it with some changes in the Preparation first.