Fiori Elements List Report OData V4- Excel Export Configuration

[DC]

Hi Team,

We have a FE Odata V4 application in SAP CAP. We are using the Excel Export functionality. This works fine but we need the DATETIME fields to be exported where UTC=false. i.e in the user locale. Also wanting to format other fields also.

We understand we might be able to extend our FE application and attach our custom code in the beforeExport Event.

Just struggling to config the manifest file and create the extension controller. We have done V2 extensions but NOT V4 ones so appreciate any help here 🙂

Is there anyone who has a working example for FE Odata V4 extension please.

Any help very much appreciated.

Cheers

D

[Marian_Zeis · Accepted solution]

Hi Darmesh,

you should be able to add them via Fiori Tooling and Page Map in BAS

Here is the code from the manifest

        "extends": {
            "extensions": {
                "sap.ui.controllerExtensions": {
                    "sap.fe.templates.ListReport.ListReportController": {
                        "controllerName": "namespace.ext.controller.Test"
                    }
                }
            }
        },

[DC · Accepted solution]

Hi Marian,

Thanks for getting back with this information.

I have looked at my BAS and i don't see what you see with your screen illustrations above

My FE application is part of a MTA with CAP Java project

I dont see show controller options!

I have added the manifest entry manually and created the ext controller but when i run it in BAS, i dont see the controller js file loaded in the source tab in chrome debugging.

 "extends": {
    "extensions": {
               "sap.ui.controllerExtensions": {
                    "sap.fe.templates.ListReport.ListReportController": {
                      "controllerName": "packagenameXXX.extension.controller.ListingsExtension"
                    }
                }            
               }
           }

[DC · Accepted solution]

Hi 20eed143c19f4b82bc4cf049916102cb

Thank you for information on this.

I have managed to update the manifest manually and created the controller. I see these in the source tab in chrome now.

We want to use the beforeExport event to modify the settings for DateTime Fields.

What would our ext controller look like. The beforeExport is trigger automatically so how do we catch that in our ext controller??

Any examples would be handy 🙂

Cheers

D