FIND

Syntax of a FIND query

<Query>   

    <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="Sencity,City,Business" format="version,current">

        <Light operatedBy="some.Business" not.state="OutOfOrder" as="MyLight">

            <Brightness gt="80%"/>

            <Location>

                <Lattitude between="1.234,0.9876"/>

            </Location>

        </Light>

        <Parking.Meter operatedBy="some.Business" as="MyParkingMeter">

            <or>

                <eq target="state">vacant</eq>

                <and>

                    <eq target="state" value="occupied"/>

                    <le target="remainingTime" value="PT10M"/>

                </and>

            </or>

        </Parking.Meter>

        <Entity Qtype="Business" as="some.Business"/>

        <not>

            <Business name="Chevron" as="Chevron"/>

            <GasStation operatedBy="Chevron">

                <le target="MyLight.distance.Chevron" value="1000ft"/>

            </GasStation>

        </not>

    </Find>

</Query>

Example

Simple Find Query

 <Query>    

       <Find format="version, current">

             <SensorModel>

                     <sensorID ne=""/>

             </SensorModel>

        </Find>

</Query>

Returns the result set with all SensorModel instances, where sensorID is not empty.

     <Find Status="success", Format="version, current">

        <Result>

             <SensorModel>

                  ....

             </SensorModel>

        </Result>

        <Result>

             ...

         </Result>

    </Find>

to remove the Result node -

<Query>

    <Find as="$none" format="version,current">

        <SensorModel>

            <ZoneID ne=""/>

        </SensorModel>  

    </Find>

</Query>

which will return the collection of all SensorModel instances under <Find> node

Simple Join Query

<Query>

    <Find format="version,current">

        <Zone as="var.Zone">

            <ZoneID ne=""/>

        </Zone>

        <ZoneInfo >

            <ZoneName  eq="var.Zone.Name" />

        </ZoneInfo>

    </Find>

</Query>

Returns the collection of Result nodes with the pairs of Zone and ZoneInfo

To concatenate the two models, one can send the following query

<Query>

    <Find as="$none:Zone:$none" format="version,current">

        <Zone as="var.Zone">

            <ZoneID ne=""/>

        </Zone>

        <ZoneInfo >

            <ZoneName  eq="var.Zone.Name" />

        </ZoneInfo>

    </Find>

</Query>

Constraints

and this will return all the Zones (with ZoneInfo).

Constraints that can be used with FIND

other structure can be used

Queries

• Use of Standard Prefixes : "var", "lit", "fun"
• Function Queries
• Only & Distinct