topic Re: Sorting field using 2 values in the same column in Water Cooler

Sorting field using 2 values in the same column

matbelli — Wed, 19 Dec 2018 10:06:50 GMT

Hi, i have a table like this
Id idcausale
1 28
2 27
1 27
2 27

I have to filter the id, such that it shows only id that has both 27 and 28 on idcausale value. How can i do it? Thanks

Re: Sorting field using 2 values in the same column

tresB — Wed, 19 Dec 2018 10:15:38 GMT

To get those Ids in text object, try like:

for only those two

=Concat(DISTINCT {<Id={"=Concat(Distinct idcausale)='2728'"}>} Id, ',')

For at least those two

=Concat(DISTINCT {<Id={"=Wildmatch(Concat(Distinct idcausale),'*2728*')"}>} Id, ',')

Re: Sorting field using 2 values in the same column

sunny_talwar — Wed, 19 Dec 2018 11:40:50 GMT

You can also try

{<Id = p({<idcausale = {27}>})*p({<idcausale = {28}>})>}