SmartClient Version: SNAPSHOT_v12.1d_2019-04-04/EVAL Deployment (expires 2019.06.03_07.20.41) Licensed to: Isomorphic Software (#ISC_EVAL_NIGHTLY)
Hello, I'm trying to use DataSource.implicitCriteria with an AdvancedCriteria.
I've tried this syntax:
But it produces this fetch criteria:
and I see this message in the log:
So I've tried this:
But on JOFC_PRESIDENTE_IN_CARICA.fetchData()
I get this js error:
Is it possible to express an AdvancedCriteria in an implicitCriteria?
Also: is it possible to use a velocity expression in it?
Hello, I'm trying to use DataSource.implicitCriteria with an AdvancedCriteria.
I've tried this syntax:
Code:
<implicitCriteria operator="and" _constructor="AdvancedCriteria">
<Criterion fieldName="DATA_CESSAZIONE" operator="isNull"/>
<criterion operator="and">
<criteria>
<Criterion fieldName="DATA_DECORRENZA" operator="lessThan" value="$currentDateTime"/>
<Criterion fieldName="DATA_CESSAZIONE" operator="greaterThan" value="$currentDateTime"/>
</criteria>
</criterion>
</implicitCriteria>
Code:
2019-04-05 18:36:25,564 DEBUG RPCManager Request #1 (DSRequest) payload: {
criteria:{
_constructor:"AdvancedCriteria",
operator:"and",
Criterion:[
{
fieldName:"DATA_CESSAZIONE",
operator:"isNull"
},
{
operator:"and",
criteria:[
{
fieldName:"DATA_DECORRENZA",
operator:"lessThan",
value:"$currentDateTime"
},
{
fieldName:"DATA_CESSAZIONE",
operator:"greaterThan",
value:"$currentDateTime"
}
]
}
]
},
operationConfig:{
dataSource:"JOFC_PRESIDENTE_IN_CARICA",
repo:null,
operationType:"fetch",
textMatchStyle:"exact"
},
....
Code:
2019-04-05 18:36:25,565 WARN SQLWhereClause [builtinApplication.JOFC_PRESIDENTE_IN_CARICA_fetch] Subcriteria of AdvancedCriteria not an instance of List - using empty ArrayList
Code:
<implicitCriteria operator="and" _constructor="AdvancedCriteria">
<criteria>
<Criterion fieldName="DATA_CESSAZIONE" operator="isNull"/>
<criterion operator="and">
<criteria>
<Criterion fieldName="DATA_DECORRENZA" operator="lessThan" value="$currentDateTime"/>
<Criterion fieldName="DATA_CESSAZIONE" operator="greaterThan" value="$currentDateTime"/>
</criteria>
</criterion>
</criteria>
</implicitCriteria>
I get this js error:
Code:
ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:32781 Uncaught TypeError: critArray.removeEmpty is not a function
at Object.compressNestedCriteria (ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:32781)
at cons._getCombinedImplicitCriteria (ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:17771)
at cons.addImplicitCriteria (ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:17779)
at cons.sendDSRequest (ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:22873)
at cons.performDSOperation (ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:22701)
at cons.fetchData (ISC_DataBinding.js?isc_version=v121d_2019-04-04.js:20842)
at <anonymous>:1:27
Also: is it possible to use a velocity expression in it?
Comment