TCC Need to export all collaborators of requisition in one single line — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TCC Need to export all collaborators of requisition in one single line

Summary:

I have a TCC script that exports requisitions details.
However, I want to add the collaborators to my export without duplicating the lines (so I want 1 line per req)

Content (please ensure you mask any confidential information)

My issue is that I have an exisiting functional TCC export (export mode = CSV-Report) that has many projections and subqueries.
Without modifying the export mode, I need to add a column that will retrieve all the collaborators on a requisition in the same line.
It's either I concatenate all the collaborators in one column or I add as many columns as there are collaborators.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!