...
Code Block |
---|
language | xml |
---|
title | Find DataModel Query Result |
---|
linenumbers | true |
---|
|
<Find Status="Success" Format="all">
<Result>
<VendorInfo QName="SimpleModel.MyModels.VendorInfo">
<VendorSysId>KNRX3TBUAAAAUAABA4LIWHP2</VendorSysId>
<vendorTitle Value="Sensor Company" Known="Sensor Company" Version="1" Timestamp="1457663102018" DateTime="2016-03-10 18:25:02.018" QName="SimpleModel.MyModels.VendorInfo.vendorTitle" FName="vendorTitle"/>
<vendorName Value="Phidget" Known="Phidget" Version="1" Timestamp="1457663102004" DateTime="2016-03-10 18:25:02.004" QName="SimpleModel.MyModels.VendorInfo.vendorName" FName="vendorName"/>
</VendorInfo>
</Result>
</Find> |
Example of Find Filter on Attributes of type Datetime
Code Block |
---|
language | xml |
---|
title | Datamodel definiton |
---|
linenumbers | true |
---|
|
<DataModel Name="MyTasks">
<Sid Name="TaskID"/>
<String Name="TaskName"/>
<String Name="TaskDesc"/>
<DateTime Name="TaskTime" Format="$SimpleDateFormat(yyyy-MM-dd'T'HH:mm:ss'Z')"/> <!-- TaskTime is a DateTime of SimpleDateFormat -->
<Integer Name="TaskStatus"/>
<Integer Name="RemindBeforeXMinutes"/>
</DataModel> |
Datetime with simple Greater Than filter
Code Block |
---|
language | xml |
---|
title | Datetime filter |
---|
linenumbers | true |
---|
|
<Query>
<Find>
<MyTasks>
<TaskID ne=""/>
<TaskTime gt="[:$Now('%1$tY-%1$tm-%1$tdT%1$tTZ'):]"/> <!-- Get the time in SimpleDateFormat -->
</MyTasks>
</Find>
</Query> |
Datetime with Range-based filters
Code Block |
---|
language | xml |
---|
title | Datetime filter |
---|
linenumbers | true |
---|
|
<Query>
<Find format="Version">
<MyTasks>
<TaskID ne=""/>
<TaskTime ge="[:$Now('%1$tY-%1$tm-%1$tdT%1$tTZ', +PT15M):]"/>
<TaskTime lt="[:$Now('%1$tY-%1$tm-%1$tdT%1$tTZ', +PT6M):]"/>
<RemindBeforeXMinutes le="15"/>
<RemindBeforeXMinutes gt="0"/>
</MyTasks>
</Find>
</Query> |
Update Query:
Code Block |
---|
language | xml |
---|
title | Update DataModel Query |
---|
linenumbers | true |
---|
|
<Query>
<Find format="version">
<VendorInfo>
<vendorName eq="Phidget"/>
</VendorInfo>
</Find>
<SetResponseData>
<Key>Message.Value.Find.Result.VendorInfo.vendorName</Key>
<Value>Phidget Inc</Value>
</SetResponseData>
<Update>
<From>Result</From>
<Include>$Response.Message.Value.Find</Include>
</Update>
</Query> |
...