Forum Discussion
Query editor shows rows but data is not available in data view
Dear all,
one of the issues we found is that in a certain table an array was present and CDS did not handle this the way it was expected. Instead of using CDS we now use ODATA (and manipulated the applicable table), which allows us to link to the necessary data/tables. Using ODATA, in our case, also solves some other random issues like Timeouts.
Dear Icey,
thank you again.
what i see here is that there are 404 (probably no pun indended) rows imported but after adding an index column there are 360 rows left. Also adding a 'Group by' using a 'count Distinct Rows' gives me 360 rows instead of the expected 404.
What i expect now, is that i am missing a 'header table' that is necessary as maybe (just maybe) the 44 missing rows are linked to the same header and the rows are generated upon a change in the data instead of a new data entry.
The screenshot you added also triggered me as i did not see that the ID is not unique (the last 2 rows contain the exact same ID).
I will investigate this further and will let you know any outcome.
Cheers,
Richard
Dear all,
one of the issues we found is that in a certain table an array was present and CDS did not handle this the way it was expected. Instead of using CDS we now use ODATA (and manipulated the applicable table), which allows us to link to the necessary data/tables. Using ODATA, in our case, also solves some other random issues like Timeouts.