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