Skip to main content
Known Participant
Jul 30, 2024 5:28 AM UTC
Question

ootb export in record having grouping

Hi Folks,

I want to provide OOTB export functionality of record in my interface; but seems like there is limitation in grid, we can only use it if data is sourced from record. 

I am getting my record data by using a!queryRecordType instead of a!recordData as a!recorddata doesn't have parameters for grouping. 

Is there any easy way to achieve the same instead of again creating a view and using as DSE and doing export functionality separately as we were doing earlier.

Regards,

Ghanashyam

5 replies

venkatrea696188
Inspiring
Jul 30, 2024 5:46 AM UTC
I am getting my record data by using a!queryRecordType instead of a!recordData as a!recorddata doesn't have parameters for grouping

 Use  record filters and Custom record fields  to aggregate data and use this data for exporting.

Known Participant
Jul 30, 2024 7:03 AM UTC

I have a column called countryid in requesttable and that is linked to country table in many to one relationship. When I am trying to use aggregate with countryID in requesttable..I am not getting that field .

venkatrea696188
Inspiring
Jul 30, 2024 9:24 AM UTC
When I am trying to use aggregate with countryID in requesttable..I am not getting that field .

Can you elaborate it a bit, What you are trying to achieve. Screenshots would be much helpful.

stefanhelzle0001
Brainy
Jul 30, 2024 6:31 AM UTC

The OOTB functions do only provide the most basic features. When you need more, you have to implement it the "old" way.

Known Participant
Jul 30, 2024 7:01 AM UTC

Yeah in old way we need two clicks for the data to be downloaded; but it's single click with OOTB record export functionality and moreover I though to use the record sync feature as we are going to do aggregate and that will have a performance impact if we are using the view.