Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.
Hello,
Is it possible in the UI to change the column order of fields in a search? For example, the search fields are currently in this order no matter which field selected from the Column Chooser:
Display Name | Given Name | Family Name | Work Email | Created | Lifecycle State | Location Code | Username | Company |
**However, for our use case, it makes more sense for the recipients of this report to receive the emailed CSV in the following order: (the re-ordered fields are bolded)
Display Name | Given Name | Family Name | Username | Work Email | Created | Lifecycle State | Company | Location Code |
I asked Harbor Pilot which advised I used the “Reports Data Extraction”, here was my request, I’m not sure where this sends to but I’m hoping there’s an easier way from the UI to re-order the columns?
Identity Security Cloud V3 API > Reports Data Extraction > Run Report
Body:
{
“reportType”: “SEARCH_EXPORT”,
“arguments”: {
“indices”: [“identities”],
“query”: “@apps(name:“AD”) AND attributes.locationCode:“foo” AND created:[now-7d TO now]”,
“columns”: “displayName,firstName,lastName,name,email,created,attributes.cloudLifecycleState,attributes.company,attributes.locationCode”,
“sort”: [“+created”]
}
}
Perhaps I’m missing something simple here or this is an idea?
Curious everyone’s thoughts:
Thanks
