PI Square

Forum Pi web API filterExpression format

State Not Answered
Replies 1 reply
Subscribers 3 subscribers
Views 330 views
Users 0 members are here

Options

Related

Pi web API filterExpression format

TFry over 1 year ago

I’m having trouble using a filter expression in the web api that normally works using AF SDK.

Im trying to filter a summary by the value of a different item/attribute. Example filter expression: filterExpression=EQUIP2:ATTR_VALUE>100

webid is for a separate EQUIP:ATTR_VALUE

shortened url: /piwebapi/streams/{EQUIP1webid}/summary?summaryType=Minimum&startTime=blah&endTime=blah&filterExpression=noted above

Parents

0 Community User over 1 year ago

Hi TFry ,
The filterExpression syntax follows the Performance Equations syntax here. In your case, it'd be close to below where your tag/attribute name is enclosed in a single quote.
/piwebapi/streams/{EQUIP1webid}/summary?summaryType=Minimum&startTime=blah&endTime=blah&filterExpression='EQUIP2:ATTR_VALUE'>100
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Community User over 1 year ago

Hi TFry ,
The filterExpression syntax follows the Performance Equations syntax here. In your case, it'd be close to below where your tag/attribute name is enclosed in a single quote.
/piwebapi/streams/{EQUIP1webid}/summary?summaryType=Minimum&startTime=blah&endTime=blah&filterExpression='EQUIP2:ATTR_VALUE'>100
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data