Product and version WebDirect 16
OS and version FMcloud 18.104.22.168
Browser and version Safari 11.0.1 (13604.3.5)
Hardware AWS t2.large
I have a portal based on a relationship across three tables, which uses an unstored calculation, for example:
Table1 -> Table2 -> Table3
...where the layout is based on Table1, the portal shows records from Table3, and Table2 has an unstored calculation field matched to a stored text field in Table3.
In fact, the unstored calculation in question is simply get(persistentID), used to obtain only records from table3 that relate to the device current running FileMaker.
The portal works as expected on FileMaker Pro clients, only showing records with the matching value of persistentID, but no records are shown in the same portal when accessed via WedDirect — even though I can display the unstored calculation field from table2 and see that it is set to the expected value, and there are definitely records with a matching value in table3.
Interestingly, if I move the unstored calculation field to Table1, and make a relationship directly between Table1 and Table3, it works as expected in both FileMaker client and WebD.
Workaround Replacing the unstored calc with a global field (set to the persistentID) works in WebD. This is obviously a bit more awkward to maintain, as the value has to be set by script.