topic Re: How to avoid loading data according to the value of a field? in App Development

How to avoid loading data according to the value of a field?

Anonymous — Thu, 12 Apr 2018 19:53:40 GMT

Hello

I need to load data on a Table chart ignoring any record that has a specific value for one of the fields. Is there an elegant way of doing it?

The field name is Status. I want to load and display all records on the Table chart, except for records whose Status = "X".

It seems a rather basic question, but I didn't manage to find an answer anywhere.
Thanks

rachel_delany — Thu, 12 Apr 2018 22:46:40 GMT

Have you tried using a where condition in the load script?

E.g.

LOAD *

FROM data

WHERE Status <> "X"

Anonymous — Fri, 13 Apr 2018 16:51:38 GMT

It worked with where [status] <> ('X');

Thanks a lot.