Skip to Content
0
5 days ago

How to use the cursor syntax in a calculated column in a calculation view

39 Views Last edit 5 days ago 2 rev

Hi All,

I am building a simple calculation view of the user history table (AUSR) and want to add the authorizations groups belonging to that user in a single fields, so that it will be just one line per user.

Example


I read up on the cursor, but not sure where or how to use it.. also thought of using the STRING_AGG, also..not sure if that will work.

Ideally, I'd like to create this field in my current calculation view. Please can I get advise and pointers on this.

Thank you all :)
Jerusha