Thoughts on custom export to Excel implementation
I have already implemented some export to excel functions against our Coveo indexes. Iâve created HTTP get methods I call on our front end that on the back end composes a Coveo query and executes the query against the index. Then it gets the resulting documents and using the OpenXML library builds the Excel and sends it back to the user. In these cases the parameters for the queries are fixed. So I can compose the query server side. All is well.
I need to build a export to excel link so a user can export the results they just searched for. The problem with the default Coveo export is all columns are included in the export. We need to specify which columns to export.
How could I get the full query that the user executed? Does the AQ contain the full query? Could I pass that back to my server side code and re-execute it against the index and get the same results the user would see? If so how do I get the AQ?
If you have any other insight on this I would appreciate it very much. Thank you, Sybil