...
This is a little trickier to get, a Mongo shell script could be used to simplify it but this approach uses Metabase instead. Use the following query and export the result to CSV named metabase_tss_ids.csv.
Placement
| Code Block |
|---|
|
[{"$project":{"_id": 0, "traineeId":"$traineeTisId","tisId":"$placements.tisId"}}] |
Programme Membership
| Code Block |
|---|
|
[{"$project":{"_id": 0, "traineeId":"$traineeTisId","tisId":"$programmeMemberships.tisId"}}] |
You’ll get a CSV with the IDs in an array.
| Code Block |
|---|
|
traineeId,tisId
315594,"[""ae5350af-2a3c-4439-b118-f57ea1d8bc94""]"
140114,"[""e92a313c-d83d-11ec-9eb2-0638a616fc76"" ""e92a3259-d83d-11ec-9eb2-0638a616fc76""]" |
...