Force / select update Big table

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:

  1. Opening new window with single data / lists from the Big table.
  2. Opening new window with data from the query.
  3. Navigating to a window with the Big table data
  4. Adding 10 sec wait time after all above.

But my query just wont update = so wrong case i assigned.

I’m not sure if it would help (and it really shouldn’t be necessary), but have you tried a Reload Query action?

Other than that, it sounds like buggy behaviour to me. I’d probably reach out to support.

1 Like

@Darren_Murphy you sneaky genius… works, thanks :smiley:

I woke up with an idea. I could have a “normal” table called “Assignment” with only three columns:
Row-ID of cases not assigned | Priority | Relate to Case

I would add rows to Assignment table via API (script in background i got running anyway), and run the whole assinment workflow of this table.

Think this would be more reliable / fast then running assinment in big table with 100K rows?

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.