ContributionsMost RecentMost LikesSolutionsis it possible to use api_doquery and get the data based on the user role.Need the api_doquery to return the data and consider the role criteria of the user.Re: Lose sorting when exporting to .csvHi Dan - thanks for your help. On the 23263 record table the displayed records on the first page = 200, but records displayed throughout the entire 117 displayed pages is sorting correctly. Only the export sorting is breaking at row 2200. This is exactly the end of page 11 in the display. I just tried your idea and did a defined sort (under customize this report), then exported, and the exported .csv sorting is breaking at exactly the same place as when I sorted via clicking the header - row 2200 of the 23263 records.Lose sorting when exporting to .csvI sort on a header (text field) prior to exporting, then "save as a spreadsheet". The .csv file has the correct sorting up to row 2020 on one table (exported 31083 records), and up to row 2200 on another table (exported 23263 records). After row 2020 and 2200 respectively, the sorting disappears and data is in no particular order. Any ideas?