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

[JerushaLala]

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

[LoHa]

Hi Jerusha,

can you provide, what you already got.

regards Lothar