Skip to main content
G
gvyakaranam1-Visitor
1-Visitor
June 28, 2021
Question

Getting unique Thing Property value from ThingTemplates query service

  • June 28, 2021
  • 2 replies
  • 1224 views

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

2 replies

S
SachinSharma16-Pearl
16-Pearl
June 28, 2021

@gvyakaranam 

 

Following community post might help.

 

G
gvyakaranam1-VisitorAuthor
1-Visitor
June 29, 2021

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

S
slangleyCommunity Manager
Support
July 1, 2021

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

S
slangleyCommunity Manager
Support
July 12, 2021

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

Terms & ConditionsAccessibility statement