gemfirespring-data-gemfireoqlpivotal-web-services

OQL to Query a List in GemFire


I am trying to form a OQL in GemFire which would query a particular attribute within the list.

I have huge number of Employee objects in GemFire with employeeId as the key.

On querying by ID we receive the following object. We convert the object into XML for some use.

<Employee>
         <employeeId>592266</employeeId>
         <employeeExperienceList>
                 <experience>
                             <org>XYZ</org>
                             <toDate>10/1/2010</toDate>
                             <fromDate>2/3/2014</fromDate>
                 </experience>
                  <experience>   
                             <org>ABC</org>
                             <toDate>2/15/2014</toDate>
                             <fromDate>3/17/2018</fromDate>
                 </experience>
         </employeeExperienceList>
</Employee>

Now I want to develop an OQL which retrieves all the Employees who are from the Organization ABC.

How can I add this to the where clause?


Solution

  • Perhaps this is best explained with an example; see here. Specifically, this is the OQL query you are looking for.

    You can find more on Pivotal GemFire's Query capabilities here.

    Hope this helps.

    Cheers! John