Question Re: Temporal Data: no data shown in Technology Q&A

Temporal Data: no data shown

former_member729305 — Tue, 06 Apr 2021 15:15:08 GMT

Dear all,

we want to make the data within our CAP app temporal.

first we import the temporal aspect into our schema and add the temporal aspect to our entity.

additionally the ValidFrom value has been added to uploaded csv files for our entity.

Once this is done the list report view does not show any entry any more.

using {
 cuid,
 managed,
 temporal
} from '@sap/cds/common';
namespace test;
entity Books : cuid, managed, temporal {
 title : String;
 stock : Integer
}

Does anyone know why this occures respecitvely which step is missing?

capire - Temporal Data (cloud.sap)

Best Regards

Max

Re: Temporal Data: no data shown

martinstenzig — Tue, 06 Apr 2021 15:25:57 GMT

Max, I don't think you are missing anything. When you add the temporal aspect, the system adds valid from to the Primary Key of the table. You can validate that by running 'cds compile ./db/[schema_name].cds --to sql'

At present there is no standard handler to automatically populate validFrom and validTo. Have a look at this thread CAP Temporal Data with NodeJS

I would also be interested to hear what standard behavior you would expect.

Re: Temporal Data: no data shown

former_member729305 — Tue, 06 Apr 2021 16:02:34 GMT

Hi martin.stenzig3

thanks for the quick response! I understand and I agree. But how would I upload records to that data format for column ValidFrom (within my csv file)?

format like e.g. 2021-04-06T10:00:00Z still returns empty in my list report view.

Best Regards

Max

Re: Temporal Data: no data shown

TobiT — Tue, 06 Apr 2021 16:13:36 GMT

Hi Martin,

i would expect the service to return all entries valid as of now (entries with empty validTo). If i understand the cap documentation correctly this should be the case:

As-of-now Queries

READ requests without specifying any temporal query parameter will automatically return data valid as of now.

GET Employees?
$expand=jobs($select=role&$expand=dept($select=name))

Source: https://cap.cloud.sap/docs/guides/temporal-data

Do i understand this correctly?

Re: Temporal Data: no data shown

martinstenzig — Wed, 07 Apr 2021 16:49:15 GMT

I just posted an update over here.

Re: Temporal Data: no data shown

martinstenzig — Wed, 07 Apr 2021 16:51:18 GMT

I agree with you that an empty validTo should be defaulted to something far, far in the future, but that's not happening as of today.

Re: Temporal Data: no data shown

OlenaT — Fri, 09 Apr 2021 07:56:25 GMT

Hi Max,

We've made some changes in the temporal data, they are available in the last release. Please update to @sap/cds 5.0.4 and check the release notes https://cap.cloud.sap/docs/releases/mar21#fixed--temporal-data.

Let us know if the problem still persists.

Best regards,

Olena