Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
We would like to have a filter option for “Retrieve rows from a table” that makes it possible to fetch certain rows instead of every row in the RAW table. The filter should be able to use any column which contains a certain value and return every row containing this value.
Add filter functionality based on column and row values
API and SDKs
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Hi@Sverre Lofthus , thank you for submitting this product idea.
Would you be able to provide a bit more context and describe your use cases for such a feature? This would help us better understand the need and how it could be addressed.
Hi@Jørgen Lund
We retrieve data from this API through a function app that has 14 different triggers. Currently, each of these has to fetch everything, before we filter out what we don't need on our end. By adding a filter to extract specific rows based on column values, we will be able to retrieve only what we need. In our case, this would mean going from having to fetch 1 million rows at each run (which we have to do 14 times in total per day) to just between 100,000 to 200,000 rows.
Got it. Just to make sure I understand: there is some overlap between the the data the 14 different triggers need, but also some differences? I.e. it would not be a solution to separate the data into more granular tables?