There are no visible columns in the table

[former_member691669]

Hello,

I'm beginner to CAPM. I developed a service and trying to build a fiori app for it. I managed to build the app but initially, it's not loading the data. I have to select fields and apply filters in order to view the data. What I'm trying to do is, to initially load the data with some selected columns of a service. In order to do that, In the annotations.cds file, I added the line item for the service and deployed it, it's still same. Could you please throw some light on how to do it?

Thanks in advance!

Best Regards,

Thousifann2.jpgann1.jpg

[mariusobert · Accepted solution]

Not loading any columns is the default behavior. I agree that it doesn't make sense when you hear it first. But displaying all columns (or defining which columns should be hidden) makes imho less sense for business apps.

So the developers needs to decide during the implementation which columns should be visible via SAP Fiori Annotations and whether the records should be loaded initially. You can find an example of the later case in the current Developer Keynote.

[former_member691669 · Accepted solution]

Hi iobert ,

Thanks for the reply! I followed your suggestions and tried to enable load data initially but unable to open "Show Page Map" and BAS is showing me "Could not find any SAP Fiori projects in workspace". I even tried using right click on webapp folder and click show page map, getting same error. Is there any other to enable initially load the data through scripts or do you know how to get rid of this error? Btw, I created the fiori app using 'List Report Object template' template wizard only and added flp configuration.

Thanks and Regards,

Thousif

[mariusobert · Accepted solution]

Yes, you can also change the property in the manifest manually. Having said that, you should be able to open the page map if (a) you created the list report with the Fiori Tools and (b) you opened the right workspace.

[former_member691669 · Accepted solution]

Thanks! I can see that data has been loading but initial selection of columns are not working with the annotations, in turn, still seeing the same message. annotations.jpg. I'm currently using line item and selection fields annotations but still columns are not being selected. Could you please tell me if I need to use any other annotations

[mariusobert · Accepted solution]

It's hard to tell from this one screenshot but yes, it seems that you are missing some properties. Have a look at this sample file to see how it could look like.

[former_member691669 · Accepted solution]

Annotations are not working in app/.cds folders. Once I move them to srv/.cds folder, they started working!

[Vedette]

Hello, 

I know it has been a few years but I am interested to know if you were able to solve this and load the data by default. If so, which annotation was used for this?

Thanks

Vedette