When I try to add Grouping feature to my code I get a SQL Error from vvcall.
{"SUCCESS":"0","MSG":"ERROR OCCURED-SQL prepare failed (SQLSTT=42601) - SQL0104 - Token [ was not valid. Valid tokens: ( + - ? : DAY INF NAN RID ROW RRN C."}
I also get a error logged in the error monitor:
Program In Error VVSRVPGM
Module In Error VVOUT
Procedure In Error VVOUT_EXECSQLTOJSON
Message ID VV00007
Statement Number N/A
Message Text The value of the statement is: SELECT XH_SOLD, XH_ITEMC, XH_ITEMCUM, XH_ACTUM, XH_PRSTDT,
XH_PRENDT, XH_PRDESC, XH_POPF, XH_PRLOW, XH_PRHI, XH_CUSTPR FROM
RSL/EDPCIXRHD order by upper([{"propert)
Valence User RSL
IBM i User RSL
Timestamp 2013-06-21-11.07.25.185000
Job Number 924875
Calling Program EDR0400
Call Stack VVCALL[VVCALL]-->EDR0400[EDR0400]-->EDR0400[SENDBACKRECORDS]-->VVSRVPGM{VVOUT}
[VVOUT_EXECSQLTOJSON]-->VVSRVPGM{VVOUT}[EXECSQLTOJSONINSENSITIVE]
I added the following code in my store for grouping:
remoteSort: true,
sorters: [{
property: 'XH_SOLD',
direction: 'ASC'
}],
groupField: 'XH_SOLD',
fields : [ 'XH_SOLD', 'XH_ITEMC', 'XH_ITEMCUM', 'XH_ACTUM', 'XH_PRSTDT', 'XH_PRENDT', 'XH_PRDESC', 'XH_CUSTPR',
'XH_PRLOW', 'XH_PRHI','XH_POPF' ]
I added the following code in my View for grouping:
features: [ {
ftype:'grouping',
groupHeaderTpl : '{[values.groupValue?"Not in":"In"]} Group'
} ],
Without Grouping everything works fine. Any ideas?
{"SUCCESS":"0","MSG":"ERROR OCCURED-SQL prepare failed (SQLSTT=42601) - SQL0104 - Token [ was not valid. Valid tokens: ( + - ? : DAY INF NAN RID ROW RRN C."}
I also get a error logged in the error monitor:
Program In Error VVSRVPGM
Module In Error VVOUT
Procedure In Error VVOUT_EXECSQLTOJSON
Message ID VV00007
Statement Number N/A
Message Text The value of the statement is: SELECT XH_SOLD, XH_ITEMC, XH_ITEMCUM, XH_ACTUM, XH_PRSTDT,
XH_PRENDT, XH_PRDESC, XH_POPF, XH_PRLOW, XH_PRHI, XH_CUSTPR FROM
RSL/EDPCIXRHD order by upper([{"propert)
Valence User RSL
IBM i User RSL
Timestamp 2013-06-21-11.07.25.185000
Job Number 924875
Calling Program EDR0400
Call Stack VVCALL[VVCALL]-->EDR0400[EDR0400]-->EDR0400[SENDBACKRECORDS]-->VVSRVPGM{VVOUT}
[VVOUT_EXECSQLTOJSON]-->VVSRVPGM{VVOUT}[EXECSQLTOJSONINSENSITIVE]
I added the following code in my store for grouping:
remoteSort: true,
sorters: [{
property: 'XH_SOLD',
direction: 'ASC'
}],
groupField: 'XH_SOLD',
fields : [ 'XH_SOLD', 'XH_ITEMC', 'XH_ITEMCUM', 'XH_ACTUM', 'XH_PRSTDT', 'XH_PRENDT', 'XH_PRDESC', 'XH_CUSTPR',
'XH_PRLOW', 'XH_PRHI','XH_POPF' ]
I added the following code in my View for grouping:
features: [ {
ftype:'grouping',
groupHeaderTpl : '{[values.groupValue?"Not in":"In"]} Group'
} ],
Without Grouping everything works fine. Any ideas?
Comment