-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathGroupingQueries.sh
66 lines (55 loc) · 3.85 KB
/
GroupingQueries.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
# Usage of Groups to define complex Queries
#Search for Property with multiple values AND Property 2 with 1 value
#(Title is Products or Square or Events)AND Template is ContentPage
#http://localhost:4502/bin/querybuilder.json?1_property=jcr%3atitle&1_property.1_value=Products&1_property.2_value=Square&1_property.3_value=Events&2_property=cq%3atemplate&2_property.value=%2fapps%2fgeometrixx%2ftemplates%2fcontentpage&p.limit=-1&type=cq%3aPageContent
type=cq:PageContent
1_property=jcr:title
1_property.1_value=Products
1_property.2_value=Square
1_property.3_value=Events
2_property=cq:template
2_property.value=/apps/geometrixx/templates/contentpage
p.limit=-1
#Search for Property with multiple values OR Property 2 with 1 value
# { (Title is Products or Square or Events ) OR Template is ContentPage }
#http://localhost:4502/bin/querybuilder.json?1_group.1_property=jcr%3atitle&1_group.1_property.1_value=Products&1_group.1_property.2_value=Square&1_group.1_property.3_value=Events&1_group.2_property=cq%3atemplate&1_group.2_property.value=%2fapps%2fgeometrixx%2ftemplates%2fcontentpage&1_group.p.or=true&p.limit=-1&type=cq%3aPageContent
type=cq:PageContent
1_group.1_property=jcr:title
1_group.1_property.1_value=Products
1_group.1_property.2_value=Square
1_group.1_property.3_value=Events
1_group.2_property=cq:template
1_group.2_property.value=/apps/geometrixx/templates/contentpage
1_group.p.or=true
p.limit=-1
#Search for Group 1 with OR conditions in properties AND Group 2 with OR conditions in properties
# ({(Title is Products or Square or Events ) OR (CQ:LastModifiedBy is Admin) } AND { Template is ContentPage or Homepage })
#http://localhost:4502/bin/querybuilder.json?1_group.1_property=jcr%3atitle&1_group.1_property.1_value=Products&1_group.1_property.2_value=Square&1_group.1_property.3_value=Events&1_group.2_property=cq%3alastModifiedBy&1_group.2_property.value=admin&1_group.p.or=true%20%20%20&2_group.2_property=cq%3atemplate&2_group.2_property.1_value=%2fapps%2fgeometrixx%2ftemplates%2fcontentpage&2_group.2_property.2_value=%2fapps%2fgeometrixx%2ftemplates%2fhomepage&p.limit=-1&type=cq%3aPageContent
type=cq:PageContent
1_group.1_property=jcr:title
1_group.1_property.1_value=Products
1_group.1_property.2_value=Square
1_group.1_property.3_value=Events
1_group.2_property=cq:lastModifiedBy
1_group.2_property.value=admin
1_group.p.or=true # if you remove this the condition between Group1 properties becomes an AND.
2_group.2_property=cq:template
2_group.2_property.1_value=/apps/geometrixx/templates/contentpage
2_group.2_property.2_value=/apps/geometrixx/templates/homepage
p.limit=-1
#Search for Group 1 with OR conditions in properties OR Group 2 with OR conditions in properties
# { ({(Title is Products or Square or Events ) OR (CQ:LastModifiedBy is Admin) } OR { Template is ContentPage or Homepage }) }
#http://localhost:4502/bin/querybuilder.json?1_group.1_group.1_property=jcr%3atitle&1_group.1_group.1_property.1_value=Products&1_group.1_group.1_property.2_value=Square&1_group.1_group.1_property.3_value=Events&1_group.1_group.2_property=cq%3alastModifiedBy&1_group.1_group.2_property.value=admin&1_group.1_group.p.or=true&1_group.2_group.2_property=cq%3atemplate&1_group.2_group.2_property.1_value=%2fapps%2fgeometrixx%2ftemplates%2fcontentpage&1_group.2_group.2_property.2_value=%2fapps%2fgeometrixx%2ftemplates%2fhomepage&1_group.p.or=true&p.limit=-1&type=cq%3aPageContent
type=cq:PageContent
1_group.1_group.1_property=jcr:title
1_group.1_group.1_property.1_value=Products
1_group.1_group.1_property.2_value=Square
1_group.1_group.1_property.3_value=Events
1_group.1_group.2_property=cq:lastModifiedBy
1_group.1_group.2_property.value=admin
1_group.1_group.p.or=true
1_group.2_group.2_property=cq:template
1_group.2_group.2_property.1_value=/apps/geometrixx/templates/contentpage
1_group.2_group.2_property.2_value=/apps/geometrixx/templates/homepage
1_group.p.or=true
p.limit=-1