I used guided setup in the grid properties (new in 2023.1) to create several filtered views.
In my example have filters to show open cases, closed cases, cases from company A, cases from Company B, and of course the default “All” view which is unfiltered.
What I am finding is that after selecting a view, its filter “sticks”, so that when a select another view the filters are effectively AND-concatenated. So if I look at Open Cases, then try to look at Closed Cases, I get empty result set; and from this point on all results sets are empty.
Same if I hit Company A view, going back to All still only shows company A results, and choosing Company B will be empty.
Clicking the refresh icon doesn’t help, a browser F5 does and returns me to the “All” filter, so that’s at least an ugly workaround for the users.
2023.1.6 does fix some UX issues for sure, but yes still a lot of things don’t work right.
Especially if you fill in a field and click TAB it does not refresh properly so better off Clearing the Form and entering the new data.
Example:
User Account Maintenance:
Open a Kinetic screen for a user. Then change the user ID Field and hit TAB, it should refresh the screen to that new USER ID’s data but it does not. It leaves the old data but new User ID.
Several things are already reported and in the works, but yeah, not as mature as one would hope.
As long as you have a workaround, that is the best option rather than dropping back to Modern or Classic but each has it’s merits and uses.
Not saying you should have to, but this is an easy fix.
This behavior is happening because the base form field is bound to User.UserID. Change the binding to KeyFields.UserID and it will work just fine.
Awesome! But yeah, not a work stopper for me, just another annoyance in the new UX. I will leave the comments at that, lol
You are awesome at programming the UX and we appreciate your screen-shots and animations!
And on a related note @hmwillett what tool do you use for screen grabbing the animations? Really nice and if a picture is worth a 1000 words, an animation…
i will try deleting the views and adding them manually without brackets; away from pc at the moment. I have logged a case in the meantime.
Syntax: no quotes in the expressions here, how are we mortals supposed to know when quotes around strings are required, let alone whether they should be single or double…
Is this grid populated by a BAQ?
If so, you need to remove the BAQ query ID from the provider model and set it up in each view. Then, remove the client filter and set those in the where clause of the BAQ Options.
It is; it comes from an app generated by “deploy Kinetic Dashboard” from the Dashboard app. i will give this a go shortly.
It appears then that for BAQ generated dashboards and the current situation (my understanding):
The data is pulled only once and filtered by dropping records at the client end each time a filter is selected, so effectively each selected filter criterion is ANDed with the previously selected ones.
The Refresh button actually does nothing useful? I think I’ve noticed this earlier with BAQ dashboards.
Sorry @hmwillett, I’m stuck on syntax again i think.
I moved the BAQ reeference from the provider to each of my views, and the views were actually now working using the client side filters as expected.
But I assume the BAQ parameters where clause approach may be more efficient, but I cannot get the syntax right:
I have tried adding using the “Where List” with no luck as well as just entering the where clause
but gives me in the debug console , and network tab shows no filter applied, as do results.
Don’t scrap the full layer. Just create another grid and set it up similar to see if the error goes away. If it does, migrate to that one and delete the old grid. Just make sure the IDs and bindings are the same before getting rid of the old.
I got the company filters working, went back to check again my column name. Had to read it about ten times to realise the misatke, not HDCase_CaseStatus, but HDCase_HDCaseStatus
