Skip to main content
Closed

Cognite FDM: Need Help on Queries

Related products:Data Modeling
  • ibrahim.alsyed
  • Carol Delavalli
    Carol Delavalli

  • It is not possible to aggregate edges, making it impossible to create queries such as: How many reporting units are at the Reporting Site CLK?
  • The aggregation API of Cognite has several limitations; we cannot group by date. More complex filters do not work either. Aggregations are limited to primitive fields in the GraphQL API.
  • Using the GraphQL API, we cannot filter an object type based on its edge. For example, querying the reporting sites associated with a specific reporting unit is not possible.
  • Pagination parameters are unstable. For instance, the "has previous page" parameter does not work.
  • The limit of 10,000 items for subqueries in the SDK Query method makes pagination extremely costly. We believe this limit should only apply to the select output.
  • It should be possible to filter and sort by the createdTime and lastUpdatedTime columns in FDM.
  • There is a lack of search capabilities using wildcards or case-insensitive searches with multiple parameters.
  • The Cognite API lacks transaction capabilities.
  • FDM documentation should have more examples.

3 replies

Jørgen Lund
Seasoned Practitioner
  • Product Manager
  • 113 replies
  • August 2, 2024

Hi @ibrahim.alsyed .

Thank you for submitting this product idea. One of our product managers will follow up shortly.


Forum|alt.badge.img

looking for an update. This is quite urgent.


Elka Sierra
MVP
Forum|alt.badge.img

Hi @ibrahim.alsyed 

Thank you for your inputs.

To provide better tracking and manage each point more efficiently, we have divided the original post into multiple smaller hub posts. Each hub post will address a specific area, and we will provide updates and answers within each one accordingly.

With this approach in place, I will be closing this ticket.

Thank you for your understanding. 

Best regards,
Elka

P.S. I am linking the related posts below

Jay Vansickle
Jay Vansickle
Jay Vansickle

 


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings