Path Query Language

Syntax

Base query:

select iteratorname in query (where qwhere )? (order by qorder+=pathQueryOrder (then by qorder+=pathQueryOrder)* )?

pathQueryOrder:

pathQueryOrder: exp=expression as ORDERAS ( asc | desc);

ORDERAS:

(number |text | datetime);

DIRECTION:

( asc | desc);

Examples

Path	value
local.shops.1.name	"apple"
local.shops.2.name	"bannana"
local.shops.3.name	"mango"
local.shops.4.name	"papaya"

select i in local.shops.% order by {i}.name as text asc i will get the paths 'local.shops.1.name' ... sorted by the name 'apple'...

"select i in local.shops.% order by i.lastpathsegment() as number asc return the shops by the number in the path {1,2,3,4,5}