Smart table error - Select at least one column to perform the search

[TimMuchena]

Hi people

I am encountering an error when using a smart table to display data.

I have developed an annotation based gateway service and everything looks fine with the metadata structure. Please see https://plnkr.co/edit/ofaMLWj3WhMvOVakIpsZ?p=catalogue for my metadata and view file

Kind ragards

[CarlosRoggan]

Hi Timothy,

the metadata that you've uploaded contains only the schema, but the toplevel nodes are missing.

I've completed it by surrounding it.

Afterwards, I was able to finish the wizard, the metadata and annotations are properly parsed, I guess.

Please see below.

Kind Regards,

Carlos

<?xml version="1.0" encoding="UTF-8"?>

<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:sap="http://www.sap.com/Protocols/SAPData">

<edmx:DataServices m:DataServiceVersion="2.0">

now all your xml

Then closing tags:

</edmx:DataServices>

</edmx:Edmx>

[TimMuchena]

Hi

I left the top nodes on purpose. You can check the whole metadata file here

I have also tried to implement a separate annotation model by following your blog post but still getting the same error. My service metadata and annotation model metadata is here

Kind regards

[TimMuchena]

hi

Is there any other way of displaying subtotals in a table besides using a smart table?

Regards

[former_member125464]

Timothy,

could you please attach here the metadata.xml file of your application?

Normally when you receive this message is because the annotation file is not available (or maybe simply wrong).

Regards,

Simmaco

[TimMuchena]

Hi

My metadata file and view file is also in this plunker.

Thank you

[former_member125464]

It seems that your metadata file is wrong. It doesn't have the right format.

If I try to import the file you gave me in order to build a new Smart Template app I get an error:

If I try to import a metadata file coming from the public gateway system it works fine and I can get the entity sets:

Regards,

Simmaco

[TimMuchena]

Hi Simmaco

I also suspected that it might be because of my metadata file but I cant figure out what exactly it is that is causing it not to work

Thanks

[former_member125464]

Timothy,

could you please give me more details about what you are trying to do?

i.e.:

• Where is your data source located?
• Did you build a CDS view? Could you attach here its source code?
• Is it possible for me to access your data source so that I can try by myself?

You can answer me in private if you want and then we can publish here the outcome.

Regards,

Simmaco

[TimMuchena]

Hi

My data soource is an ECC6 system. I created the gateway service using the service builder SEGW using Service with Vocabulary-Based Annotations option. The only abap code that I have is in the getEntitySet method where I am retrieving all the data that I want to display in the table

Kind regards