Topics started by Lihui Meng

2 Topics

L
Committed
Lihui MengCommitted

Aggregate to support filtering from linked typeGathering Interest

Hello data modeling team, we define a 'Film' type which links to a 'Director' type, and prepare some test data as below:when executing the "listFilm" query and set the filter with director name,  the query works well and return the expected results.when executing the "aggregateFilm" query, the Director fields are not available on Query Explorer. when adding the filter manually, the query failed.

5
T
Practitioner
4 months ago
L
Committed
Lihui MengCommitted
asked in Developer and User Community

Pagination and returning records at a specific page

Hello data modeling team, I tried the "first" and "after" filter on Query Explorer which enables us to retrieve the query result page by page, it works well.while we have an existing API which enables the consumer to specify an "offset" and a "limit" parameter. by the offset, the consumer could retrieve records at any specific page without the need to always go though from the beginning and then retrieve page by page, it's like the skip and limit syntax in mongodb, for example, db.myCollection.find().skip(200000).limit(50).we want to keep the API behavior so no modification needed for existing consumer, while we do not want to simulate the offset behavior by retrieving page by page within our own API since it will be very low efficient when there is a big dataset, so is it possible to provide the offset supporting in Cognite ? or any suggestions/methods we could try to implement this ? Thanks! 

2
J
Seasoned Practitioner
9 months ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings