is there a distinct filter for Data modeling sdk instance query method

No, we do not have a distinct filter. But I might be missing something here, but can’t this be solved with aggregation? Something like

from cognite.client.data_classes.aggregations import Count

view_id= ViewId(space="slb-pdm-dm-governed", external_id="TimeseriesProperty",version="2_0")
client.data_modeling.instances.aggregate(view_id, Count("propertyType"), limit=10)

Hi ​@Anders Albert !
Thank you for the response. This gives the count of "TimeseriesPropertyType" instances that are attached to "TimeseriesProperty" view, which has a lot of duplicates. we only what unique values of "TimeseriesPropertyType" instances that are attached to "TimeseriesProperty" view. is there any way to achieve that?

Thanks for the clarification. I think the the following should do the trick.

view_id= ViewId(space="slb-pdm-dm-governed", external_id="TimeseriesProperty",version="2_0")
v_id_2_PROP = ViewId(space="slb-pdm-dm-governed", external_id="TimeseriesPropertyType",version="2_0")
query= Query(
    with_=
            {
                "TimeseriesProperty":NodeResultSetExpression(
                        limit=10,
                        filter= HasData(views=[view_id])),

                "TimeseriesPropertyType":NodeResultSetExpression(
                        limit=10000,
                        direction="outwards",
                        from_ = "TimeseriesProperty",
                        through = view_id.as_property_ref("propertyType"),
                        filter= HasData(views=[v_id_2_PROP]))
            }
            ,
    select={
        "TimeseriesPropertyType": Select([SourceSelector(view_id, properties=['*'])]),
            })
result = client.data_modeling.instances.query(query)

Note the difference between this an the original query is the select part. You select ‘TimeseriesPropertyType’, which will return only the unique TimeSeriesPropertyTypes regardless if it is linked to multiple timeseries properties.

Thank you!

hi ​@Anders Albert !
This gives the unique TimeSeriesPropertyTypes with its externalId and space, but this doesn’t give all fields from ‘TimeSeriesPropertyTypes’  view, just its space and externalId. do i need to extend this query?