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

Hi, 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:

Thank you Tomas, it worked! I thought I tried every eventuality but obviously not :)