Hi
Is there any way to “force update” a big table?
Since Big tables now support Live Updates, im trying to build a “case assignment” system running in a Big table. I add cases to the table automatically, auto-prioritize, and assing cases to employees when they “pull” a new case (they press button: Get new case).
We get 75k+ cases each year, so “normal” tables is only viable if i move completed cases to an archive (Big table). Have tried this before, it works, but complicates thing alot (statistics, reopening cases, archive-scripts…)
My challenge is: Case 1 get assigned (employee email is written i column “email”). But my query trying to find the new available (unassigned) case dosn’t update, unless user refresh window (F5).
I dont need my query updated all the time, i basicly only need it to update when a employee pulls a new case.
Have tried:
On pull request, before query is used to selcet next case, i have tried:
- Opening new window with single data / lists from the Big table.
- Opening new window with data from the query.
- Navigating to a window with the Big table data
- Adding 10 sec wait time after all above.
But my query just wont update = so wrong case i assigned.