...
Expand | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Anchor | ||||
---|---|---|---|---|
|
Gliffy | ||||
---|---|---|---|---|
|
Panel | borderStyle | solid|||
---|---|---|---|---|
Paste code macro | ||||
| ||||
Example
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 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.
Find:
using: "Sensity,City,Business"
Entity:
QType: "Business"
as: "some.Business"
Light:
operatedBy: "some.Business.EIN"
not:
state: "OutOfOrder"
as: "MyLight"
Brightness:
gt: "80%"
Location:
Lattitude:
between: "1.234,0.9876"
Parking.Meter:
operatedBy: "some.Business.EIN"
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: |