Filter with state saved within the session using a global variable

  1. My goal: Get my filters to (1) set, and (2) stick when I move to another form and them move back. I just want to update the items in a global json variable and use them to drive the table filtering.
  2. Issue: I THOUGHT I did what was recommended but I’m in an infinite brain fog loop
  3. Steps I've taken to troubleshoot: I verified every setting for the filter fields and the table’s default filter definitions, the global json object that holds the current setting of the filter fields. I tried recreating it, moving it, etc. I hover over my Change event attached to a filter field (In the case below, Name) and see its value it never gets assigned. I’m using ā€œIn Posā€ to set the value of the item in the json variable. it does not update. I can’t find documentation about how it ought to be set. my form’s default filters reference the items in that global json variable.
  4. Additional info: (Cloud or Self-hosted, Screenshots)

Here’s the entry in the table’s default filters…

Here’s the default value and current state of the json variable…

I can’t get it to change, therefore, the table does not filter. I need an extra pair of eyes. Please point out my dumb. I’m making a silly assumption or for whatever reason blinded to how it really works and what I should be doing.

Thanks!

-Ron

1 Like

The problem was indeed my misunderstanding of how to set the In Pos. I was close originally with values of Name and ā€˜Name’, then I got woefully creative. To replace a value in a json array it should be [ā€˜ā€™] so I needed to put [ā€˜Name’] in the In Pos. That fixed it there and in every other filter’s Change event.

Thanks for providing an update, @rlhane.2_19635! Glad to hear you got it working.

1 Like