Hi All
Collection is not displaying as expected. Best way to illustrate is with this video.
Filter Issue
The filter on the collection is “Does the array contain the JSON string of the record in the helper table.”
I have compared the strings:
Array data:
1 {“standard”:“Time & Attendance”,“offence”:“Unauthorised absence from the work station”,“consequences”:[“First Offence: Written Warning”,“Second Offence: Final Written Warning”,“Third Offence: Termination With Notice”],“rationale”:“Henry Olonga’s consistent mid-week absences without valid illness and never longer than a single day at a time fall under unauthorised absence and potentially habitual absenteeism if it meets the criteria of 5 absences per quarter.”}
Record JSON:
1 {“standard”:“Time & Attendance”,“offence”:“Unauthorised absence from the work station”,“consequences”:[“First Offence: Written Warning”,“Second Offence: Final Written Warning”,“Third Offence: Termination With Notice”],“rationale”:“Henry Olonga’s consistent mid-week absences without valid illness and never longer than a single day at a time fall under unauthorised absence and potentially habitual absenteeism if it meets the criteria of 5 absences per quarter.”}
They are identical and so there is a match - the underlying data is there, but the collection is not displaying the record.
Initially the filter works as expected when adding items to the “selected” group but “breaks down” if I try to update the array with the remove array column, despite the underlying data being updated as expected.
Can anyone see what the issue is?
) but I discovered that using template columns to represent both the array of JSON and the record JSON column to text strings, and using these in the collection filter, resolved the issue and the filters are working as expected.