topic Where Condition in List Box in App Development

Where Condition in List Box

vinaykotha — Mon, 10 Apr 2017 18:21:05 GMT

Hello,

I have 2 Fields ID & Description. There are 8 ID's from 1 to 8 and have descriptions for each ID. I do now want to show ID 6 in the list. Could someone please help me in writing the Where condition in the List Box. I tried several combinations but it is not working.

Thanks

Vinay K

Re: Where Condition in List Box

sunny_talwar — Mon, 10 Apr 2017 18:58:43 GMT

May be like this

If(ID <> 6, ID)

Aggr(Only({1<ID =-{6}>} ID), ID)

Re: Where Condition in List Box

vinaykotha — Mon, 10 Apr 2017 19:01:42 GMT

Thank you, it worked.

Re: Where Condition in List Box

jhonesnow — Wed, 16 Nov 2022 08:47:59 GMT

@vinaykotha wrote:

Hello,

I have 2 Fields ID & Description. There are 8 ID's from 1 to 8 and have descriptions for each ID. I do now want to show ID 6 in the list. Could someone please help me in writing the Where condition in the List Box. I tried several combinations but it is not working.

Thanks

Vinay K custom boxes

yes man i was also trying to do that but it didn't work if you have found the solution please do help me too