I am trying to put together a data source where the column count only shows me results greater than 1. How can I do this?
Solved
Lobby Data Source count greater than 1
+1Best answer by Tomas Ruderfelt
Test and add the having clause in the “Group By” after the columns you have there. Start with a space and then HAVING count(doc_no) > 1
It works fine in 23R1:
Hi,
If you can explain you context a bit more (Why you are trying to do this, where etc.), it would be useful.
Thanks
Hi,
I don’t think there is any support for using HAVING-conditions like HAVING count > 1 in Data Source Designer in IFS. I would love to be proven wrong though.
A workaround would be to make a custom IAL with the correct conditions and use that IAL as a data source instead.
BR
Johan
+1Hi, Thank you for your responses. I am trying to do a data source count for number of document titles to identify duplicates. So I am only interested in seeing count results greater than 1.
Test and add the having clause in the “Group By” after the columns you have there. Start with a space and then HAVING count(doc_no) > 1
It works fine in 23R1:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.