Hi everyone - I have a problem with a view, based on a slice, that sometimes does and sometimes doesn’t update until after a sync.
I have read a few posts about using VCs and references to ensure that slice filters are calculated within the app, but I’ve had no joy getting this to work.
I’ve put together a test app to try and understand how to get this functionality in my full app, and it has the following structure:
Table L - a link table to provide a many-to-many join between table A and table B which are both referenced from L Table C - which is a child of table B
Table L has a VC called “Related Cs” which is a deref to the “Related Cs” ref_rows VC in table B.
I did this to make computation of the slice quicker in the full app by avoiding multiple, nested IN/Selects.
My slice lists the child Cs of rows in B that have a reference to the maxrow of table A via table L, with the formula:
In([CID], Select(L[Related Cs], [AID]=Any(A[MaxrowA])))
It all works fine, except for the fact that very often, I have to wait for the delayed sync to happen, before the view updates with the proper (current) results.
Can anyone give me any pointers on how to have this all happen within the app?