Solved

Lobby Data Source count greater than 1

  • 19 December 2023
  • 5 replies
  • 68 views
B
Rank
Badge +1
  • Becky
  • Do Gooder (Customer)
  • 4 replies

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?

icon

Best answer by Tomas Ruderfelt 22 December 2023, 07:56

View original

5 replies

A
Rank
Userlevel 6
Badge +11

Hi,

If you can explain you context a bit more (Why you are trying to do this, where etc.), it would be useful.

Thanks

Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
J
Rank
Userlevel 4
Badge +8

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

B
Rank
Badge +1

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.

 

T
Rank
Userlevel 7
Badge +19

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:

 

B
Rank
Badge +1

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

Reply


Terms & ConditionsCookie settings