Campus Solutions PS_PERSONAL_DATA in Query Manager no longer provides data as expected after 9.2 upg
We have a query that was working in Campus Solutions 9.0 without issue, however since we started testing on upgrading Campus Solutions 9.2 the query does not report any results.
I have tested and confirmed that it has something to do with the PS_PERSONAL_DATA Bio Snapshot data and the PS_PERALL_SEC_QRY view which is added in Query Manager as soon as you use the PS_PERSONAL_DATA record.
What are we missing, is there some kind of secondary security or process that needs to be run?
Any help would be great!