XPATH Query Question | Community
Skip to main content
V
vdhim23
New Participant
October 16, 2015
Solved

XPATH Query Question

  • October 16, 2015
  • 2 replies
  • 631 views

Hi,

I am trying to get all the orders under user. I am using below XPTAH query.

/jcr:root/home/users/a/admin/commerce/orders//element(*)[@orderId] this result below records :

/home/users/a/admin/commerce/orders/order-2014-Apr-12 /home/users/a/admin/commerce/orders/order-2015-Apr-15 /home/users/a/admin/commerce/orders/order-2015-Apr-13

Now i have requirements that order should be in the sorted order as per booked(that i am looking for) , Other is i will have dynamic parameter which will I pass through the method in which i have the XPTH query executed e.g. 6 or ALL . 6 will display the last 6 months order only (that i am looking for). For all orders i can use the above query with sort condition. 

Below is QueryBuilder Query which also give me records but not for 6 months:

type=unstructured
path=/home/users/a/admin/commerce/orders
path.flat=true
orderby=@orderPlaced
orderby.sort=desc

Or some one has any idea about SQL2 Query for same use-case, Please tell.

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by vdhim23

vdhim23 wrote...

Hi,

I am trying to get all the orders under user. I am using below XPTAH query.

/jcr:root/home/users/a/admin/commerce/orders//element(*)[@orderId] this result below records :

  1. /home/users/a/admin/commerce/orders/order-2014-Apr-12
  2. /home/users/a/admin/commerce/orders/order-2015-Apr-15
  3. /home/users/a/admin/commerce/orders/order-2015-Apr-13

Now i have requirements that order should be in the sorted order as per booked(that i am looking for) , Other is i will have dynamic parameter which will I pass through the method in which i have the XPTH query executed e.g. 6 or ALL . 6 will display the last 6 months order only (that i am looking for). For all orders i can use the above query with sort condition. 

Thanks

 

 

This solved my problem :

1_relativedaterange.property=orderPlaced
1_relativedaterange.lowerBound=-6M
1_relativedaterange.upperBound=0

2 replies

V
vdhim23AuthorAccepted solution
New Participant
October 16, 2015

vdhim23 wrote...

Hi,

I am trying to get all the orders under user. I am using below XPTAH query.

/jcr:root/home/users/a/admin/commerce/orders//element(*)[@orderId] this result below records :

  1. /home/users/a/admin/commerce/orders/order-2014-Apr-12
  2. /home/users/a/admin/commerce/orders/order-2015-Apr-15
  3. /home/users/a/admin/commerce/orders/order-2015-Apr-13

Now i have requirements that order should be in the sorted order as per booked(that i am looking for) , Other is i will have dynamic parameter which will I pass through the method in which i have the XPTH query executed e.g. 6 or ALL . 6 will display the last 6 months order only (that i am looking for). For all orders i can use the above query with sort condition. 

Thanks

 

 

This solved my problem :

1_relativedaterange.property=orderPlaced
1_relativedaterange.lowerBound=-6M
1_relativedaterange.upperBound=0

smacdonald2008
smacdonald2008
New Participant
October 16, 2015

Thank you for posting the solution. 

Terms & ConditionsAccessibility statement

Loading footer...