...
Expand | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Anchor | ||||
---|---|---|---|---|
|
Gliffy | ||||
---|---|---|---|---|
|
Panel | borderStyle | solid|||
---|---|---|---|---|
Paste code macro | ||||
| ||||
Example <Query var=Query: var: "some"> <Documentation> This query finds all pairs of illuminated street lights next to vacant (or about to become vacant) parking meters operated by the same business outside of 1000 feet radius of a Chevron gas station if any. </Documentation> <Find using=Documentation: > This query finds all pairs of illuminated street lights next to vacant (or about to become vacant) parking meters operated by the same business outside of 1000 feet radius of a Chevron gas station if any. Find: using: "Sensity,City,Business"> <Entity QType= Entity: QType: "Business"as= as: "some.Business"/> <Light operatedBy= Light: operatedBy: "some.Business.EIN"not.state= not: state: "OutOfOrder"as="MyLight"> <Brightness gt="80%"/> <Location> <Lattitude between=as: "MyLight" Brightness: gt: "80%" Location: Lattitude: between: "1.234,0.9876"/> </Location> </Light> <Parking.Meter operatedBy=Parking.Meter: operatedBy: "some.Business.EIN"as="MyParkingMeter"> <or> <eq target="state"> vacant </eq> <and> <eq target="state" value="occupied"/> <le target="remainingTime" value="PT10M"/> </and> </or> </Parking.Meter> <not> <Business name="Chevron" businessType="GasStation" as="Chevron"/> <Distance from="Chevron.EID" to="var.MyLight.LID"> <feet le="1000"/> </Distance> </not> </Find> </Query> Referenced by:
Label: Query label, will be copied into result From: Dot-delimited path to source container TqlAs is written as "As": Colon-separated whole result: result set [:instance] container specifiers FsExpression: any facet script expressions. They can be used both before the "Find/DeleteAll/Save/Create/Update/Delete" tags or after them. In either case, the execution is different
as: "MyParkingMeter"
or:
- eq:
target: "state"
value: "vacant"
- and:
- eq:
target: "state"
value: "occupied"
- le:
target: "remainingTime"
value: "PT10M"
not:
Business:
name: "Chevron"
businessType: "GasStation"
as: "Chevron"
Distance:
from: "Chevron.EID"
to: "var.MyLight.LID"
feet:
le: "1000"
|
Anchor | ||||
---|---|---|---|---|
|
Gliffy | ||||
---|---|---|---|---|
|
Panel | ||||
---|---|---|---|---|
| ||||
Paste code macro | ||||
| ||||
Query:
Find:
as: "X:Y:Z"
format: "version,current"
Zone:
as: "var.Zone"
ZoneID:
ne: ""
ZoneInfo:
ZoneName:
eq: "var.Zone.Name" |
Anchor | ||||
---|---|---|---|---|
|
Gliffy | ||||
---|---|---|---|---|
|
Panel | ||||
---|---|---|---|---|
| ||||
Paste code macro | ||||
| ||||
Query:
Find:
as: "$none:Zone:$none"
format: "version,current"
Zone:
as: "var.Zone"
ZoneID:
ne: ""
ZoneInfo:
ZoneName:
eq: "var.Zone.Name"
|
Anchor | ||||
---|---|---|---|---|
|
Gliffy | ||||
---|---|---|---|---|
|
Panel | ||||
---|---|---|---|---|
| ||||
Paste code macro | ||||
| ||||
Query:
Find:
as: "$none:Zone:$none"
Only: "Zone:Name"
format: "version,current"
Zone:
as: "var.Zone"
ZoneID:
ne: "" |
Anchor | ||||
---|---|---|---|---|
|
Gliffy | ||||
---|---|---|---|---|
|
Panel | ||||
---|---|---|---|---|
| ||||
Example <Query> <Find as="$none:Zone:$none" Only="Zone:Name" format="version,current"> <Zone as="var.Zone"> <ZoneID ne=""/> </Zone> </Find> </Query> Returns <Zone> <Name Value="CV-F1-Zone-1" Version="1"/> </Zone> <Zone> Referenced by:
|
...
Panel | ||||
---|---|---|---|---|
| ||||
Example <Query> <Find as="$none:Zone:$none" format="version,current"> <gateway.agriculture.Zone as="var.X"> <ZoneID ne=""/> </gateway.agriculture.Zone> </Find> </Query> Referenced by:
|
...
Panel | ||||
---|---|---|---|---|
| ||||
Example <Query> <Find as="$none:Zone:$none" format="version,current"> <Zone as="var.X"> <And> <ZoneID ne=""/> <Name ne="CV-F1-Zone-1" /> </And> </Zone> </Find> </Query> Returns all the records except with Name as CV-F1-Zone-1. Referenced by:
|
...
Panel | ||||
---|---|---|---|---|
| ||||
Example
<Create> <Zone> <Name = "Zone-1" /> </Zone> </Create> </Query> Referenced by:
|
...
Panel | ||||
---|---|---|---|---|
| ||||
Example <Query> <Create> <gateway.agriculture.Zone> <Name = "Zone-1" /> </gateway.agriculture.Zone> </Create> </Query> Referenced by:
|
...
Panel | ||||
---|---|---|---|---|
| ||||
Example <Query> <Create format="version,order,timestamp"> <User UserId="User1"> <UserName>myName</UserName> <Password>pass</Password> <isActive>true</isActive> <Address Label="Work"> <Street>1151 Sonora Ct, Suite 2</Street> <City>Sunnyvale</City> <State>CA</State> <ZipCode>94086</ZipCode> </Address> </User> <User> ... </Create> </Query> Referenced by:
|
...
Panel | ||||
---|---|---|---|---|
| ||||
Example <Query> <Update format="version,order,timestamp"> <User UserId="User1"> <UserName>myName</UserName> <Password>pass</Password> <isActive>true</isActive> <Role Do="Create">user</Role> <Address Label="Work"> <Street>1151 Sonora Ct, Suite 2</Street> <City>Sunnyvale</City> <State>CA</State> <ZipCode>94086</ZipCode> </Address> </User> <User> ... </Update> </Query>Referenced by: |