Getting unique Thing Property value from ThingTemplates query service

[gvyakaranam]

Hi,

I would like to get unique Things Properties from query service. I don't want to use infoTable.Distinct()

Example below...

ThingName Property(name of property is custom_pro)

t1                "abc"

t2                "xyz"

t3                "abc"

t4                "xyz"

result should be {abc, xyz}

Kindly let me know or any suggestions.

Thanks

Gopi

[SachinSharma]

@gvyakaranam 

Following community post might help.

[gvyakaranam]

Hi Sachin,

As having bulk amout of things in the platform(>10000), not able loop many times...

For the same purpose, I would like to know if any query service, which will be proving result as distinct list of Property value like "{"xyz","abc"}". Mean that the count of result is 1000 out of 10000 things or more.

Kindly let me know.

Thanks

Gopi

[slangley]

Hi @

If we understand you correctly, you could try using the QueryImplementingThingsWithNamedData service to return specific properties you're interested in within a given template.  Then you can use distinct to filter the list.

If there is more to this use case than we're understanding, please provide more details and we'll be glad to help.

Regards.

--Sharon

[slangley]

Hi @gvyakaranam

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.  If you are still having problems, please let us know.

Regards.

--Sharon