topic Re: How could i filter my data in table in App Development

How could i filter my data in table

lichang422 — Sat, 16 Nov 2024 08:49:44 GMT

i had a lot kind of data.

But i just only want to show some data in table likes all of bat data

How could i type in expression??

zhadrakas — Mon, 22 Jan 2018 07:07:57 GMT

maybe like this

if(WildMatch(SimpleSignalName, '*Bat*'),SimpleSignalName)

lichang422 — Mon, 22 Jan 2018 07:10:06 GMT

Thank you for rapidly answer!

lichang422 — Mon, 22 Jan 2018 07:13:24 GMT

If I also want to filter FAN data(Bat and FAN),

How could i type ??

zhadrakas — Mon, 22 Jan 2018 07:18:44 GMT

just add another search string

if(WildMatch(SimpleSignalName, '*Bat*', '*FAN*'),SimpleSignalName)

i dont know if that works as expected. you could also try

if(WildMatch(SimpleSignalName, '*Bat*', '*FAN*')>=1,SimpleSignalName)

lichang422 — Mon, 22 Jan 2018 07:21:40 GMT

It is so easy , i thinking too difficult ,

Thank you for your reply again.

lichang422 — Mon, 22 Jan 2018 07:28:52 GMT

Why when i used filter in expression, I also can see some data is hidden(gray color )

Can i not show it ??

lichang422 — Mon, 22 Jan 2018 07:34:14 GMT

Oh, I got it ,

When I cancel the "include NULL value"

It will not show it.