[FEATURE] Enable queries using "root" and "-1" for pidInList
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / Tests / Functional / Fixtures / Frontend / JsonRenderer.ts
1 config {
2 no_cache = 1
3 debug = 0
4 xhtml_cleaning = 0
5 admPanel = 0
6 disableAllHeaderCode = 1
7 sendCacheHeaders = 0
8 sys_language_uid = 0
9 sys_language_mode = ignore
10 sys_language_overlay = 1
11 # additionalHeaders = Content-Type: application/json; charset=utf-8
12 }
13
14 watcher {
15 tableFields {
16 pages = uid,_ORIG_uid,pid,sorting,title
17 sys_category = uid,_ORIG_uid,_LOCALIZED_UID,pid,sys_language_uid,title,parent,items,sys_language_uid
18 tt_content = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,header,categories,tx_irretutorial_1nff_hotels
19 tx_irretutorial_1nff_hotel = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title,offers
20 tx_irretutorial_1nff_offer = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title,prices
21 tx_irretutorial_1nff_price = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title,price
22 tx_irretutorial_1ncsv_hotel = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title,offers
23 tx_irretutorial_1ncsv_offer = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title,prices
24 tx_irretutorial_1ncsv_price = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title,price
25 tx_testdatahandler_element = uid,_ORIG_uid,_LOCALIZED_UID,pid,sorting,sys_language_uid,title
26 }
27 }
28
29 page = PAGE
30 page {
31 10 = CONTENT
32 10 {
33 watcher.parentRecordField = __pages
34 table = pages
35 select {
36 orderBy = sorting
37 pidInList = this
38 }
39 }
40 20 = CONTENT
41 20 {
42 watcher.parentRecordField = __contents
43 table = tt_content
44 select {
45 orderBy = sorting
46 where = colPos=0
47 languageField = sys_language_uid
48 }
49 renderObj = COA
50 renderObj {
51 10 = CONTENT
52 10 {
53 if.isTrue.field = categories
54 watcher.parentRecordField = categories
55 table = sys_category
56 select {
57 pidInList = root,-1
58 selectFields = sys_category.*
59 join = sys_category_record_mm ON sys_category_record_mm.uid_local = sys_category.uid
60 where.data = field:_ORIG_uid // field:uid
61 where.intval = 1
62 where.wrap = sys_category_record_mm.uid_foreign=|
63 orderBy = sys_category_record_mm.sorting_foreign
64 languageField = sys_category.sys_language_uid
65 }
66 }
67 20 = CONTENT
68 20 {
69 if.isTrue.field = tx_irretutorial_1nff_hotels
70 watcher.parentRecordField = tx_irretutorial_1nff_hotels
71 table = tx_irretutorial_1nff_hotel
72 select {
73 orderBy = sorting
74 where.field = uid
75 where.intval = 1
76 where.wrap = parenttable="tt_content" AND parentid=|
77 languageField = sys_language_uid
78 }
79 renderObj = CONTENT
80 renderObj {
81 if.isTrue.field = offers
82 watcher.parentRecordField = offers
83 table = tx_irretutorial_1nff_offer
84 select {
85 orderBy = sorting
86 where.field = uid
87 where.intval = 1
88 where.wrap = parenttable="tx_irretutorial_1nff_hotel" AND parentid=|
89 languageField = sys_language_uid
90 }
91 renderObj = CONTENT
92 renderObj {
93 if.isTrue.field = prices
94 watcher.parentRecordField = prices
95 table = tx_irretutorial_1nff_price
96 select {
97 orderBy = sorting
98 where.field = uid
99 where.intval = 1
100 where.wrap = parenttable="tx_irretutorial_1nff_offer" AND parentid=|
101 languageField = sys_language_uid
102 }
103 }
104 }
105 }
106 30 = CONTENT
107 30 {
108 if.isTrue.field = tx_irretutorial_1ncsv_hotels
109 watcher.parentRecordField = tx_irretutorial_1ncsv_hotels
110 table = tx_irretutorial_1ncsv_hotel
111 select {
112 uidInList.data = field:tx_irretutorial_1ncsv_hotels
113 orderBy = sorting
114 # not including sys_language_uid lookup
115 # languageField = sys_language_uid
116 }
117 renderObj = CONTENT
118 renderObj {
119 if.isTrue.field = offers
120 watcher.parentRecordField = offers
121 table = tx_irretutorial_1ncsv_offer
122 select {
123 uidInList.data = field:offers
124 orderBy = sorting
125 # not including sys_language_uid lookup
126 # languageField = sys_language_uid
127 }
128 renderObj = CONTENT
129 renderObj {
130 if.isTrue.field = prices
131 watcher.parentRecordField = prices
132 table = tx_irretutorial_1ncsv_price
133 select {
134 uidInList.data = field:prices
135 orderBy = sorting
136 # not including sys_language_uid lookup
137 # languageField = sys_language_uid
138 }
139 }
140 }
141 }
142 50 = CONTENT
143 50 {
144 if.isTrue.field = tx_testdatahandler_select
145 watcher.parentRecordField = tx_testdatahandler_select
146 table = tx_testdatahandler_element
147 select {
148 uidInList.data = field:tx_testdatahandler_select
149 pidInList = 0
150 orderBy = sorting
151 # not including sys_language_uid lookup
152 # languageField = sys_language_uid
153 }
154 }
155 60 = CONTENT
156 60 {
157 if.isTrue.field = tx_testdatahandler_group
158 watcher.parentRecordField = tx_testdatahandler_group
159 table = tx_testdatahandler_element
160 select {
161 uidInList.data = field:tx_testdatahandler_group
162 pidInList = 0
163 orderBy = sorting
164 # not including sys_language_uid lookup
165 # languageField = sys_language_uid
166 }
167 }
168 }
169 }
170 }
171
172 [globalVar = GP:L = 1]
173 config.sys_language_uid = 1
174 [end]