Kinetic Dashboards - Filters how to handle null filters

Kinetic ERP
,
1

I’m about mid way through our uplift to Kinetic and now comfortable enough to make dashboards from scratch and got the formatting for filters to work.

But one question (so far). what if the filter is blank? I’d like it to show all records.

Neither setting Honor Null (on or off) nor Empty Value (null or “”) seem to be doing anything.
The filter works but has to have a value.

image
image511×651 43.6 KB

Do I have to do something wacky?

I will miss building trackers in classic where I can select a bunch of filters and it builds them in one shot.

2

This trick doesn’t work either but does work as a starts condition

image
image481×557 25.3 KB

3

What I have had to do in the past is add a calculated field to the BAQ that simply converts the boolean value to a True/False or Yes/No string field. As a string field, you get the results you are looking for.

Now this is for classic dashboards where I can put a dropdown filter on a field that I’m not displaying. I’m not familiar with Kinetic dashboards yet.

1 Like
4

I have used this trick with Booleans.
Thanks for sharing it, it is very handy when doing Boolean filters.

But unfortunately this is not a Boolean field.

This is a string - PO number

I want the grid to show all records if the tracker field is blank like it would with a classic tracker.

Blank - Show all records

Any value - invoke the starts with where clause - this part is working.

5

The weird part is that if you make a tracker for a classic dashboard and then select the option to generate a Kinetic application the tracker text boxes allow this behavior. If you leave the tracker field blank all records are selected.

So Kinetic can do it - but how?

I thought setting the wherelist value to ‘%?{TransView.PONum}%’ would work but that makes it work like a contains clause. Good to know lol but not what I needed.

image
image765×657 51.1 KB

6

Try adding a second (?).

I think ‘??{TransView.PONum}’ may pass all values if it doesn’t find a match.

1 Like
7

You have my gratitude. That did it!

1 Like