Problem using "N days ago" options in FilterBuilder

[emmetmryan]

Hi, I am using a Filter Builder to filter my grid. This works until I try to use the N days ago or similar options. For Today or Yesterday it works correctly as in it creates a filter with date >= start of today and <= end of today

SELECT ... FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE >= TO_DATE('2016-03-30 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE <= TO_DATE('2016-03-30 23:59:59','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))

but if I try to use N days ago it renders as this:

SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE = TO_DATE('2016-03-30 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))

So it doesn't look far a date range, rather it looks for an exact date. If I output the criteria as string they look like this:

14:48:14.417:pointerup1:WARN:Log:Filter Criteria = {
"_constructor":"AdvancedCriteria",
"operator":"and",
"criteria":[
{
"fieldName":"START_DATE",
"operator":"equals",
"value":{
"_constructor":"RelativeDate",
"value":"$yesterday"
}
}
]
}

15:34:54.196:pointerup6:WARN:Log:Filter Criteria = {
"_constructor":"AdvancedCriteria",
"operator":"and",
"criteria":[
{
"fieldName":"START_DATE",
"operator":"equals",
"value":{
"_constructor":"RelativeDate",
"value":"-1d[-0D]"
}
}
]
}

Is there anyway to change this behavior? So that it always uses a date range.

Thanks

Emmet

[Isomorphic]

See the FAQ for a list of information you need to include when posting. You've forgotten to tell us what product, what version, forgotten the server logs, DataSource definition, database type, etc.

This looks like it could be a problem with your DataSource declaring the field as type "date" rather than "datetime" when you actually want "datetime", but there are several other possible causes and we can't tell what's going on until you complete your post.

[emmetmryan]

Not entirely sure about product and version I think its Smart GWT 2.5.1. gwt-2.5.1 is the SDK I am using.

Server Log

=== 2016-04-04 12:15:03,357 [ec-6] DEBUG XML - Parsed XML from D:\ryanemm\cvsworkspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\sdpePortal\logsactionsall\sc\system\schema\List.ds.xml: 0ms
=== 2016-04-04 12:15:03,358 [ec-6] DEBUG ISCKeyedObjectPool - Borrowing object for 'DataSource'
=== 2016-04-04 12:15:03,361 [ec-6] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2016-04-04 12:15:03,362 [ec-6] DEBUG RPCManager - Processing 1 requests.
=== 2016-04-04 12:15:03,379 [ec-6] DEBUG ISCKeyedObjectPool - Borrowing object for 'disseminationPrepDS'
=== 2016-04-04 12:15:03,380 [ec-6] DEBUG DSRequest - Caching instance 74 of DS disseminationPrepDS from DSRequest.getDataSource()
=== 2016-04-04 12:15:03,380 [ec-6] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"datasetId",
operator:"equals",
value:"106"
}
]
},
operationConfig:{
dataSource:"disseminationPrepDS",
repo:null,
operationType:"fetch",
textMatchStyle:"substring"
},
startRow:0,
endRow:75,
componentId:"isc_Dissemination_DesignElements$1_0",
useStrictJSON:true,
appID:"builtinApplication",
operation:"disseminationPrepDS_fetch",
oldValues:{
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"datasetId",
operator:"equals",
value:"106"
}
]
}
}
=== 2016-04-04 12:15:03,381 [ec-6] INFO IDACall - Performing 1 operation(s)
=== 2016-04-04 12:15:03,383 [ec-6] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2016-04-04 12:15:03,384 [ec-6] DEBUG DeclarativeSecurity - DataSource disseminationPrepDS is not in the pre-checked list, processing...
=== 2016-04-04 12:15:03,396 [ec-6] DEBUG AppBase - [builtinApplication.disseminationPrepDS_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2016-04-04 12:15:03,397 [ec-6] DEBUG AppBase - [builtinApplication.disseminationPrepDS_fetch] No public zero-argument method named '_disseminationPrepDS_fetch' found, performing generic datasource operation
=== 2016-04-04 12:15:03,398 [ec-6] INFO SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Performing fetch operation with
criteria: {criteria:[{fieldName:"datasetId",operator:"equals",value:"106"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{fieldName:"datasetId",operator:"equals",value:"106"}],operator:"and",_constructor:"AdvancedCriteria"}
=== 2016-04-04 12:15:03,422 [ec-6] INFO SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] derived query: SELECT $defaultSelectClause FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)
=== 2016-04-04 12:15:03,598 [ec-6] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Executing row count query: SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)
=== 2016-04-04 12:15:03,599 [ec-6] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Eval'd row count query: SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (('1'='1'))
=== 2016-04-04 12:15:03,605 [ec-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.disseminationPrepDS_fetch] makeObject() created an unpooled Connection '1173450267'
=== 2016-04-04 12:15:03,605 [ec-6] DEBUG SQLConnectionManager - [builtinApplication.disseminationPrepDS_fetch] Borrowed connection '1173450267'
=== 2016-04-04 12:15:03,605 [ec-6] DEBUG SQLDriver - [builtinApplication.disseminationPrepDS_fetch] About to execute SQL query in 'java:comp/env/jdbc/sdwsdpe' using connection '1173450267'
=== 2016-04-04 12:15:03,605 [ec-6] INFO SQLDriver - [builtinApplication.disseminationPrepDS_fetch] Executing SQL query on 'java:comp/env/jdbc/sdwsdpe': SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (('1'='1'))
=== 2016-04-04 12:15:04,496 [ec-6] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT sdpe.v_portal_dissemination_prep.ACTION_ID, sdpe.v_portal_dissemination_prep.RECURRENCE, sdpe.v_portal_dissemination_prep.TEST_FLAG, sdpe.v_portal_dissemination_prep.DESCRIPTION, sdpe.v_portal_dissemination_prep.ACTION_TYPE, sdpe.v_portal_dissemination_prep.SCHEDULE_USER, sdpe.v_portal_dissemination_prep.EXECUTION_STATUS, sdpe.v_portal_dissemination_prep.PREPARATION_STATUS, sdpe.v_portal_dissemination_prep.START_DATE, sdpe.v_portal_dissemination_prep.END_DATE, sdpe.v_portal_dissemination_prep.RELEASE_TIME, sdpe.v_portal_dissemination_prep.DISS_TYPE, sdpe.v_portal_dissemination_prep.MESSAGE, sdpe.v_portal_dissemination_prep.FAME_TARGET_DB, sdpe.v_portal_dissemination_prep.LOG_FILE, sdpe.v_portal_dissemination_prep.NUMBER_SERIES, sdpe.v_portal_dissemination_prep.SERIES_FILE, sdpe.v_portal_dissemination_prep.SCHEDULE_ID FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (('1'='1'))
=== 2016-04-04 12:15:05,359 [ec-6] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Using paging strategy 'jdbcScroll' - scrolling to absolute position 1
=== 2016-04-04 12:15:05,360 [ec-6] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Scrolling / positioning took 1ms
=== 2016-04-04 12:15:05,425 [ec-6] INFO DSResponse - [builtinApplication.disseminationPrepDS_fetch] DSResponse: List with 75 items
=== 2016-04-04 12:15:05,437 [ec-6] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2016-04-04 12:15:05,437 [ec-6] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2016-04-04 12:15:05,465 [ec-6] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1173450267
=== 2016-04-04 12:15:05,465 [ec-6] DEBUG SQLConnectionManager - About to close PoolGuardConnectionWrapper with hashcode "1173450267"
=== 2016-04-04 12:15:05,466 [ec-6] INFO Compression - /sdpePortal/dissprocessesgwt/sc/IDACall: 52126 -> 3601 bytes
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: accept:*/*
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded; charset=UTF-8
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: referer:https://localhost:8443/sdpePortal/di...lpers/Log.html
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-language:en-GB
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip, deflate
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: host:localhost:8443
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: content-length:677
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: connection:Keep-Alive
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: cache-control:no-cache
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - Header Name:Value pair: cookie:JSESSIONID=DCC8EDDA5B897514ECFE31480D0F4595; GLog=%7B%0D%20%20%20%20left%3A498%2C%20%0D%20%20%20%20top%3A91%2C%20%0D%20%20%20%20width%3A1219%2C%20%0D%20%20%20%20height%3A935%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; isc_cState=ready
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - session exists: DCC8EDDA5B897514ECFE31480D0F4595
=== 2016-04-04 12:15:08,529 [ec-3] DEBUG IDACall - remote user: null
=== 2016-04-04 12:15:09,019 [ec-3] DEBUG XML - Parsed XML from (in memory stream): 2ms
=== 2016-04-04 12:15:09,019 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
=== 2016-04-04 12:15:09,020 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-04-04 12:15:09,020 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
=== 2016-04-04 12:15:09,021 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2016-04-04 12:15:09,022 [ec-3] DEBUG RPCManager - Processing 1 requests.
=== 2016-04-04 12:15:09,022 [ec-3] DEBUG RPCManager - Request #1 (RPCRequest) data: {
appID:"isc_builtin",
className:"builtin",
methodName:"getAvailableScriptEngines",
arguments:[
],
is_ISC_RPC_DMI:true
}
=== 2016-04-04 12:15:09,023 [ec-3] INFO IDACall - Performing 1 operation(s)
=== 2016-04-04 12:15:09,034 [ec-3] DEBUG XML - Parsed XML from jar:file:/D:/ryanemm/cvsworkspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/sdpePortal/WEB-INF/lib/isomorphic_core_rpc.jar!/isc_builtin.app.xml: 2ms
=== 2016-04-04 12:15:09,034 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Application'
=== 2016-04-04 12:15:09,035 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'ServerObject'
=== 2016-04-04 12:15:09,036 [ec-3] DEBUG XML - Parsed XML from D:\ryanemm\cvsworkspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\sdpePortal\logsactionsall\sc\system\schema\ServerObject.ds.xml: 1ms
=== 2016-04-04 12:15:09,036 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-04-04 12:15:09,037 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'fields'
=== 2016-04-04 12:15:09,037 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'ID'
=== 2016-04-04 12:15:09,038 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'valueMap'
=== 2016-04-04 12:15:09,039 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'lookupStyle'
=== 2016-04-04 12:15:09,040 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'attributeName'
=== 2016-04-04 12:15:09,040 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'attributeScope'
=== 2016-04-04 12:15:09,041 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'bean'
=== 2016-04-04 12:15:09,041 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'visibleMethods'
=== 2016-04-04 12:15:09,042 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'dropExtraFields'
=== 2016-04-04 12:15:09,044 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Method'
=== 2016-04-04 12:15:09,046 [ec-3] DEBUG XML - Parsed XML from D:\ryanemm\cvsworkspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\sdpePortal\logsactionsall\sc\system\schema\Method.ds.xml: 1ms
=== 2016-04-04 12:15:09,046 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-04-04 12:15:09,046 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'name'
=== 2016-04-04 12:15:09,047 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'fields'
=== 2016-04-04 12:15:09,053 [ec-3] DEBUG RPCDMI - appConfig: isc.Application.create({
rpcBindings:[
{
ID:"builtin",
className:"com.isomorphic.rpc.BuiltinRPC",
visibleMethods:[
{
name:"downloadWSDL"
},
{
name:"downloadClientContent"
},
{
name:"downloadClientExport"
},
{
name:"xmlToJS"
},
{
name:"uploadProgressCheck"
},
{
name:"saveFile"
},
{
name:"appendToFile"
},
{
name:"loadFile"
},
{
name:"deleteFile"
},
{
name:"loadSharedXML"
},
{
name:"saveSharedXML"
},
{
name:"getAvailableScriptEngines"
},
{
name:"devConsoleEvalServerScript"
},
{
name:"evalJava"
},
{
name:"getLogNames"
},
{
name:"getLogEntries"
},
{
name:"clearLogEntries"
},
{
name:"getLogThresholds"
},
{
name:"setLogThreshold"
},
{
name:"setTemporaryLogThreshold"
},
{
name:"revertTemporaryLogThresholds"
},
{
name:"getPdfObject"
},
{
name:"exportImage"
},
{
name:"areServerTimingsTracked"
},
{
name:"trackServerTimings"
}
]
},
{
ID:"builtin_tools",
className:"com.isomorphic.tools.BuiltinRPC",
visibleMethods:[
{
name:"getDataSourceFromTable"
},
{
name:"getDataSourceJSONFromTable"
},
{
name:"getDataSourceFromHibernateMapping"
},
{
name:"getDataSourceJSONFromHibernateMapping"
},
{
name:"getTables"
},
{
name:"getFieldsFromTable"
},
{
name:"getBeanFields"
},
{
name:"getHibernateBeans"
},
{
name:"getDatabaseProductNameAndVersion"
},
{
name:"getDatabaseTableTypes"
},
{
name:"setAttributes"
},
{
name:"clearAttributes"
},
{
name:"getAttributes"
},
{
name:"getAttribute"
},
{
name:"getDataSourceConfigFromJavaClass"
},
{
args:"cName",
language:"groovy",
name:"getJavaSource",
script:"\n if (!com.isomorphic.auth.DevModeAuthFilter.devModeAuthorized(request)) throw new Exception("Not Authorized"); \n //import org.apache.bcel.Repository;\n\n try {\n return org.apache.bcel.Repository.lookupClass(cName).toString();\n } catch (Throwable e) {\n return "Unable to reverse engineer class "+cName+": "+e.getMessage();\n }\n "
},
{
name:"loadDataSource"
},
{
name:"dsFromXML"
},
{
name:"dsConfigFromXML"
},
{
name:"getDefinedDataSources"
}
]
},
{
ID:"builtin_adminconsole",
className:"com.isomorphic.tools.AdminConsole",
visibleMethods:[
{
name:"getDefinedDatabases"
},
{
name:"testDB"
},
{
name:"saveDBConfig"
},
{
name:"setDefaultDB"
},
{
name:"importDataSources"
},
{
name:"discoverJNDIDatabases"
}
]
}
]
})

=== 2016-04-04 12:15:09,075 [ec-3] DEBUG RPCDMI - rpc returned data
=== 2016-04-04 12:15:09,076 [ec-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2016-04-04 12:15:09,076 [ec-3] INFO Compression - /sdpePortal/dissprocessesgwt/sc/IDACall: 108 -> 107 bytes
=== 2016-04-04 12:15:17,931 [ec-3] DEBUG IDACall - Header Name:Value pair: accept:*/*
=== 2016-04-04 12:15:17,932 [ec-3] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded; charset=UTF-8
=== 2016-04-04 12:15:17,932 [ec-3] DEBUG IDACall - Header Name:Value pair: referer:https://localhost:8443/sdpePortal/dissProcesses.do
=== 2016-04-04 12:15:17,932 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-language:en-GB
=== 2016-04-04 12:15:17,932 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip, deflate
=== 2016-04-04 12:15:17,932 [ec-3] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
=== 2016-04-04 12:15:17,932 [ec-3] DEBUG IDACall - Header Name:Value pair: host:localhost:8443
=== 2016-04-04 12:15:17,933 [ec-3] DEBUG IDACall - Header Name:Value pair: content-length:2446
=== 2016-04-04 12:15:17,933 [ec-3] DEBUG IDACall - Header Name:Value pair: connection:Keep-Alive
=== 2016-04-04 12:15:17,933 [ec-3] DEBUG IDACall - Header Name:Value pair: cache-control:no-cache
=== 2016-04-04 12:15:17,933 [ec-3] DEBUG IDACall - Header Name:Value pair: cookie:JSESSIONID=DCC8EDDA5B897514ECFE31480D0F4595; GLog=%7B%0D%20%20%20%20left%3A502%2C%20%0D%20%20%20%20top%3A98%2C%20%0D%20%20%20%20width%3A1223%2C%20%0D%20%20%20%20height%3A939%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; isc_cState=ready
=== 2016-04-04 12:15:17,933 [ec-3] DEBUG IDACall - session exists: DCC8EDDA5B897514ECFE31480D0F4595
=== 2016-04-04 12:15:17,933 [ec-3] DEBUG IDACall - remote user: null
=== 2016-04-04 12:15:17,945 [ec-3] DEBUG XML - Parsed XML from (in memory stream): 2ms
=== 2016-04-04 12:15:17,945 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
=== 2016-04-04 12:15:17,946 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-04-04 12:15:17,946 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
=== 2016-04-04 12:15:17,947 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2016-04-04 12:15:17,958 [ec-3] DEBUG RPCManager - Processing 1 requests.
=== 2016-04-04 12:15:17,958 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'disseminationPrepDS'
=== 2016-04-04 12:15:17,959 [ec-3] DEBUG DSRequest - Caching instance 74 of DS disseminationPrepDS from DSRequest.getDataSource()
=== 2016-04-04 12:15:17,963 [ec-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"START_DATE",
operator:"betweenInclusive",
start:new Date(1459720800000),
end:new Date(1459807199999)
},
{
fieldName:"datasetId",
operator:"equals",
value:"106"
}
]
},
operationConfig:{
dataSource:"disseminationPrepDS",
repo:null,
operationType:"fetch",
textMatchStyle:"substring"
},
startRow:0,
endRow:75,
componentId:"isc_Dissemination_DesignElements$1_0",
useStrictJSON:true,
appID:"builtinApplication",
operation:"disseminationPrepDS_fetch",
oldValues:{
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"START_DATE",
operator:"betweenInclusive",
start:new Date(1459720800000),
end:new Date(1459807199999)
},
{
fieldName:"datasetId",
operator:"equals",
value:"106"
}
]
}
}
=== 2016-04-04 12:15:17,963 [ec-3] INFO IDACall - Performing 1 operation(s)
=== 2016-04-04 12:15:17,963 [ec-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2016-04-04 12:15:17,963 [ec-3] DEBUG DeclarativeSecurity - DataSource disseminationPrepDS is not in the pre-checked list, processing...
=== 2016-04-04 12:15:17,964 [ec-3] DEBUG AppBase - [builtinApplication.disseminationPrepDS_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2016-04-04 12:15:17,964 [ec-3] DEBUG AppBase - [builtinApplication.disseminationPrepDS_fetch] No public zero-argument method named '_disseminationPrepDS_fetch' found, performing generic datasource operation
=== 2016-04-04 12:15:17,964 [ec-3] INFO SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Performing fetch operation with
criteria: {criteria:[{fieldName:"START_DATE",operator:"betweenInclusive",start:new Date(1459720800000),end:new Date(1459807199999)},{fieldName:"datasetId",operator:"equals",value:"106"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{fieldName:"START_DATE",operator:"betweenInclusive",start:new Date(1459720800000),end:new Date(1459807199999)},{fieldName:"datasetId",operator:"equals",value:"106"}],operator:"and",_constructor:"AdvancedCriteria"}
=== 2016-04-04 12:15:17,965 [ec-3] INFO SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] derived query: SELECT $defaultSelectClause FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)
=== 2016-04-04 12:15:17,969 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Executing row count query: SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)
=== 2016-04-04 12:15:17,971 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Eval'd row count query: SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE >= TO_DATE('2016-04-04 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE <= TO_DATE('2016-04-04 23:59:59','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))
=== 2016-04-04 12:15:17,976 [ec-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.disseminationPrepDS_fetch] makeObject() created an unpooled Connection '1173450267'
=== 2016-04-04 12:15:17,976 [ec-3] DEBUG SQLConnectionManager - [builtinApplication.disseminationPrepDS_fetch] Borrowed connection '1173450267'
=== 2016-04-04 12:15:17,976 [ec-3] DEBUG SQLDriver - [builtinApplication.disseminationPrepDS_fetch] About to execute SQL query in 'java:comp/env/jdbc/sdwsdpe' using connection '1173450267'
=== 2016-04-04 12:15:17,976 [ec-3] INFO SQLDriver - [builtinApplication.disseminationPrepDS_fetch] Executing SQL query on 'java:comp/env/jdbc/sdwsdpe': SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE >= TO_DATE('2016-04-04 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE <= TO_DATE('2016-04-04 23:59:59','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))
=== 2016-04-04 12:15:19,007 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT sdpe.v_portal_dissemination_prep.ACTION_ID, sdpe.v_portal_dissemination_prep.RECURRENCE, sdpe.v_portal_dissemination_prep.TEST_FLAG, sdpe.v_portal_dissemination_prep.DESCRIPTION, sdpe.v_portal_dissemination_prep.ACTION_TYPE, sdpe.v_portal_dissemination_prep.SCHEDULE_USER, sdpe.v_portal_dissemination_prep.EXECUTION_STATUS, sdpe.v_portal_dissemination_prep.PREPARATION_STATUS, sdpe.v_portal_dissemination_prep.START_DATE, sdpe.v_portal_dissemination_prep.END_DATE, sdpe.v_portal_dissemination_prep.RELEASE_TIME, sdpe.v_portal_dissemination_prep.DISS_TYPE, sdpe.v_portal_dissemination_prep.MESSAGE, sdpe.v_portal_dissemination_prep.FAME_TARGET_DB, sdpe.v_portal_dissemination_prep.LOG_FILE, sdpe.v_portal_dissemination_prep.NUMBER_SERIES, sdpe.v_portal_dissemination_prep.SERIES_FILE, sdpe.v_portal_dissemination_prep.SCHEDULE_ID FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE >= TO_DATE('2016-04-04 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE <= TO_DATE('2016-04-04 23:59:59','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))
=== 2016-04-04 12:15:19,922 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Using paging strategy 'jdbcScroll' - scrolling to absolute position 1
=== 2016-04-04 12:15:19,923 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Scrolling / positioning took 1ms
=== 2016-04-04 12:15:19,930 [ec-3] INFO DSResponse - [builtinApplication.disseminationPrepDS_fetch] DSResponse: List with 5 items
=== 2016-04-04 12:15:19,936 [ec-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2016-04-04 12:15:19,936 [ec-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2016-04-04 12:15:19,940 [ec-3] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1173450267
=== 2016-04-04 12:15:19,940 [ec-3] DEBUG SQLConnectionManager - About to close PoolGuardConnectionWrapper with hashcode "1173450267"
=== 2016-04-04 12:15:19,941 [ec-3] INFO Compression - /sdpePortal/dissprocessesgwt/sc/IDACall: 3561 -> 721 bytes
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: accept:*/*
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded; charset=UTF-8
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: referer:https://localhost:8443/sdpePortal/dissProcesses.do
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-language:en-GB
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip, deflate
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: host:localhost:8443
=== 2016-04-04 12:15:32,001 [ec-3] DEBUG IDACall - Header Name:Value pair: content-length:2258
=== 2016-04-04 12:15:32,002 [ec-3] DEBUG IDACall - Header Name:Value pair: connection:Keep-Alive
=== 2016-04-04 12:15:32,002 [ec-3] DEBUG IDACall - Header Name:Value pair: cache-control:no-cache
=== 2016-04-04 12:15:32,002 [ec-3] DEBUG IDACall - Header Name:Value pair: cookie:JSESSIONID=DCC8EDDA5B897514ECFE31480D0F4595; GLog=%7B%0D%20%20%20%20left%3A502%2C%20%0D%20%20%20%20top%3A98%2C%20%0D%20%20%20%20width%3A1223%2C%20%0D%20%20%20%20height%3A939%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; isc_cState=ready
=== 2016-04-04 12:15:32,002 [ec-3] DEBUG IDACall - session exists: DCC8EDDA5B897514ECFE31480D0F4595
=== 2016-04-04 12:15:32,002 [ec-3] DEBUG IDACall - remote user: null
=== 2016-04-04 12:15:32,011 [ec-3] DEBUG XML - Parsed XML from (in memory stream): 3ms
=== 2016-04-04 12:15:32,011 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
=== 2016-04-04 12:15:32,012 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-04-04 12:15:32,013 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
=== 2016-04-04 12:15:32,014 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2016-04-04 12:15:32,016 [ec-3] DEBUG RPCManager - Processing 1 requests.
=== 2016-04-04 12:15:32,016 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'disseminationPrepDS'
=== 2016-04-04 12:15:32,017 [ec-3] DEBUG DSRequest - Caching instance 74 of DS disseminationPrepDS from DSRequest.getDataSource()
=== 2016-04-04 12:15:32,018 [ec-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"START_DATE",
operator:"equals",
value:new Date(1459375200000)
},
{
fieldName:"datasetId",
operator:"equals",
value:"106"
}
]
},
operationConfig:{
dataSource:"disseminationPrepDS",
repo:null,
operationType:"fetch",
textMatchStyle:"substring"
},
startRow:0,
endRow:75,
componentId:"isc_Dissemination_DesignElements$1_0",
useStrictJSON:true,
appID:"builtinApplication",
operation:"disseminationPrepDS_fetch",
oldValues:{
_constructor:"AdvancedCriteria",
operator:"and",
criteria:[
{
fieldName:"START_DATE",
operator:"equals",
value:new Date(1459375200000)
},
{
fieldName:"datasetId",
operator:"equals",
value:"106"
}
]
}
}
=== 2016-04-04 12:15:32,018 [ec-3] INFO IDACall - Performing 1 operation(s)
=== 2016-04-04 12:15:32,018 [ec-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2016-04-04 12:15:32,018 [ec-3] DEBUG DeclarativeSecurity - DataSource disseminationPrepDS is not in the pre-checked list, processing...
=== 2016-04-04 12:15:32,018 [ec-3] DEBUG AppBase - [builtinApplication.disseminationPrepDS_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2016-04-04 12:15:32,019 [ec-3] DEBUG AppBase - [builtinApplication.disseminationPrepDS_fetch] No public zero-argument method named '_disseminationPrepDS_fetch' found, performing generic datasource operation
=== 2016-04-04 12:15:32,019 [ec-3] INFO SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Performing fetch operation with
criteria: {criteria:[{fieldName:"START_DATE",operator:"equals",value:new Date(1459375200000)},{fieldName:"datasetId",operator:"equals",value:"106"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{fieldName:"START_DATE",operator:"equals",value:new Date(1459375200000)},{fieldName:"datasetId",operator:"equals",value:"106"}],operator:"and",_constructor:"AdvancedCriteria"}
=== 2016-04-04 12:15:32,020 [ec-3] INFO SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] derived query: SELECT $defaultSelectClause FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)
=== 2016-04-04 12:15:32,033 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Executing row count query: SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)
=== 2016-04-04 12:15:32,036 [ec-3] DEBUG SQLDataSource - [builtinApplication.disseminationPrepDS_fetch] Eval'd row count query: SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE = TO_DATE('2016-03-31 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))
=== 2016-04-04 12:15:32,042 [ec-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.disseminationPrepDS_fetch] makeObject() created an unpooled Connection '1173450267'
=== 2016-04-04 12:15:32,042 [ec-3] DEBUG SQLConnectionManager - [builtinApplication.disseminationPrepDS_fetch] Borrowed connection '1173450267'
=== 2016-04-04 12:15:32,042 [ec-3] DEBUG SQLDriver - [builtinApplication.disseminationPrepDS_fetch] About to execute SQL query in 'java:comp/env/jdbc/sdwsdpe' using connection '1173450267'
=== 2016-04-04 12:15:32,042 [ec-3] INFO SQLDriver - [builtinApplication.disseminationPrepDS_fetch] Executing SQL query on 'java:comp/env/jdbc/sdwsdpe': SELECT COUNT(*) FROM SDPE.v_portal_dissemination_prep WHERE DATASET_ID='106' AND (((sdpe.v_portal_dissemination_prep.START_DATE = TO_DATE('2016-03-31 00:00:00','YYYY-MM-DD HH24:MI:SS') AND sdpe.v_portal_dissemination_prep.START_DATE IS NOT NULL) AND '1'='1'))
=== 2016-04-04 12:15:33,001 [ec-3] INFO DSResponse - [builtinApplication.disseminationPrepDS_fetch] DSResponse: List with 0 items
=== 2016-04-04 12:15:33,002 [ec-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2016-04-04 12:15:33,002 [ec-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2016-04-04 12:15:33,003 [ec-3] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1173450267
=== 2016-04-04 12:15:33,003 [ec-3] DEBUG SQLConnectionManager - About to close PoolGuardConnectionWrapper with hashcode "1173450267"
=== 2016-04-04 12:15:33,003 [ec-3] INFO Compression - /sdpePortal/dissprocessesgwt/sc/IDACall: 208 -> 160 bytes
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: accept:*/*
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded; charset=UTF-8
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: referer:https://localhost:8443/sdpePortal/di...lpers/Log.html
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-language:en-GB
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip, deflate
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: host:localhost:8443
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: content-length:675
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: connection:Keep-Alive
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: cache-control:no-cache
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - Header Name:Value pair: cookie:JSESSIONID=DCC8EDDA5B897514ECFE31480D0F4595; GLog=%7B%0D%20%20%20%20left%3A502%2C%20%0D%20%20%20%20top%3A98%2C%20%0D%20%20%20%20width%3A1223%2C%20%0D%20%20%20%20height%3A939%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; isc_cState=ready
=== 2016-04-04 12:16:36,673 [ec-3] DEBUG IDACall - session exists: DCC8EDDA5B897514ECFE31480D0F4595
=== 2016-04-04 12:16:36,674 [ec-3] DEBUG IDACall - remote user: null
=== 2016-04-04 12:16:37,183 [ec-3] DEBUG XML - Parsed XML from (in memory stream): 1ms
=== 2016-04-04 12:16:37,183 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
=== 2016-04-04 12:16:37,184 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-04-04 12:16:37,184 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
=== 2016-04-04 12:16:37,185 [ec-3] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2016-04-04 12:16:37,186 [ec-3] DEBUG RPCManager - Processing 1 requests.
=== 2016-04-04 12:16:37,186 [ec-3] DEBUG RPCManager - Request #1 (RPCRequest) data: {
appID:"isc_builtin",
className:"builtin",
methodName:"areServerTimingsTracked",
arguments:[
],
is_ISC_RPC_DMI:true
}
=== 2016-04-04 12:16:37,186 [ec-3] INFO IDACall - Performing 1 operation(s)
=== 2016-04-04 12:16:37,188 [ec-3] DEBUG RPCDMI - appConfig: isc.Application.create({
rpcBindings:[
{
ID:"builtin",
className:"com.isomorphic.rpc.BuiltinRPC",
visibleMethods:[
{
name:"downloadWSDL"
},
{
name:"downloadClientContent"
},
{
name:"downloadClientExport"
},
{
name:"xmlToJS"
},
{
name:"uploadProgressCheck"
},
{
name:"saveFile"
},
{
name:"appendToFile"
},
{
name:"loadFile"
},
{
name:"deleteFile"
},
{
name:"loadSharedXML"
},
{
name:"saveSharedXML"
},
{
name:"getAvailableScriptEngines"
},
{
name:"devConsoleEvalServerScript"
},
{
name:"evalJava"
},
{
name:"getLogNames"
},
{
name:"getLogEntries"
},
{
name:"clearLogEntries"
},
{
name:"getLogThresholds"
},
{
name:"setLogThreshold"
},
{
name:"setTemporaryLogThreshold"
},
{
name:"revertTemporaryLogThresholds"
},
{
name:"getPdfObject"
},
{
name:"exportImage"
},
{
name:"areServerTimingsTracked"
},
{
name:"trackServerTimings"
}
]
},
{
ID:"builtin_tools",
className:"com.isomorphic.tools.BuiltinRPC",
visibleMethods:[
{
name:"getDataSourceFromTable"
},
{
name:"getDataSourceJSONFromTable"
},
{
name:"getDataSourceFromHibernateMapping"
},
{
name:"getDataSourceJSONFromHibernateMapping"
},
{
name:"getTables"
},
{
name:"getFieldsFromTable"
},
{
name:"getBeanFields"
},
{
name:"getHibernateBeans"
},
{
name:"getDatabaseProductNameAndVersion"
},
{
name:"getDatabaseTableTypes"
},
{
name:"setAttributes"
},
{
name:"clearAttributes"
},
{
name:"getAttributes"
},
{
name:"getAttribute"
},
{
name:"getDataSourceConfigFromJavaClass"
},
{
args:"cName",
language:"groovy",
name:"getJavaSource",
script:"\n if (!com.isomorphic.auth.DevModeAuthFilter.devModeAuthorized(request)) throw new Exception("Not Authorized"); \n //import org.apache.bcel.Repository;\n\n try {\n return org.apache.bcel.Repository.lookupClass(cName).toString();\n } catch (Throwable e) {\n return "Unable to reverse engineer class "+cName+": "+e.getMessage();\n }\n "
},
{
name:"loadDataSource"
},
{
name:"dsFromXML"
},
{
name:"dsConfigFromXML"
},
{
name:"getDefinedDataSources"
}
]
},
{
ID:"builtin_adminconsole",
className:"com.isomorphic.tools.AdminConsole",
visibleMethods:[
{
name:"getDefinedDatabases"
},
{
name:"testDB"
},
{
name:"saveDBConfig"
},
{
name:"setDefaultDB"
},
{
name:"importDataSources"
},
{
name:"discoverJNDIDatabases"
}
]
}
]
})

=== 2016-04-04 12:16:37,189 [ec-3] DEBUG RPCDMI - rpc returned RPCResponse
=== 2016-04-04 12:16:37,190 [ec-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2016-04-04 12:16:37,190 [ec-3] INFO Compression - /sdpePortal/dissprocessesgwt/sc/IDACall: 68 -> 74 bytes
=== 2016-04-04 12:16:40,006 [ec-3] INFO Compression - /sdpePortal/dissprocessesgwt/sc/IDACall: 81 -> 86 bytes



Datasource Definition (Preparation Start is the field in question)

<DataSource ID="disseminationPrepDS"
serverType="sql"
tableName="sdpe.v_portal_dissemination_prep"
allowAdvancedCriteria="true"
>
<fields>
<field name="ACTION_ID" type="text" primaryKey="true"/>
<field name="RECURRENCE" type="text"/>
<field name="TEST_FLAG" type="text" title="Test"/>
<field name="DESCRIPTION" type="text"/>
<field name="ACTION_TYPE" type="text"/>
<field name="SCHEDULE_USER" type="text" title="User"/>
<field name="EXECUTION_STATUS" type="text" title="Execution Status"/>
<field name="PREPARATION_STATUS" type="text" />
<field name="START_DATE" type="datetime" title="Preparation Start"/>
<field name="END_DATE" type="datetime" title="Prepared at"/>
<field name="RELEASE_TIME" type="datetime" />
<field name="DISS_TYPE" type="text" />
<field name="MESSAGE" type="text" title="Preparation Message"/>
<field name="FAME_TARGET_DB" type="text" />
<field name="LOG_FILE" type="text" title="Preparation Log" canFilter="false"/>
<field name="NUMBER_SERIES" type="text" title="Series"/>
<field name="SERIES_FILE" type="text" hidden="true"/>
<field name="SCHEDULE_ID" type="text" />

</fields>
<operationBindings>
<operationBinding operationType="fetch">
<tableClause>SDPE.v_portal_dissemination_prep</tableClause>
<whereClause> DATASET_ID=$advancedCriteria.datasetId AND ($defaultWhereClause)</whereClause>
</operationBinding>
<operationBinding operationType="fetch" operationId="fetch_id">
<tableClause>SDPE.v_portal_dissemination_prep</tableClause>
<whereClause> SCHEDULE_ID LIKE ($advancedCriteria.schedule_id)</whereClause>
</operationBinding>
</operationBindings>
</DataSource>

Database Type is Oracle 11.6

The column is defined as:

START_DATE DATE DEFAULT Sysdate NOT NULL,

[emmetmryan]

Is there a way to identify when the N Days Ago and similar pseudo values are being used? I am looking at the Criterion object but I only have .getValueAsString() or similar which gives me "Object"

[emmetmryan]

Any update on this? Can you confirm that it is a bug?

[Isomorphic]

You haven't given us your version yet. 2.5.1 is not a SmartGWT version. See the FAQ for how to determine your version. If you are not already using the latest, fully-patched build for your version, the first thing you should do is download and test with that, as you could be looking at a long-since fixed bug.

Note that we already have a lot of automated tests covering this usage, so it's unlikely you're looking at a bug.

[emmetmryan]

How do I determine the version? Actually 2.5.1 is the GWT version. Down the bottom of the developer console it reports

SmartClient Version: v9.1p_2015-12-10/Enterprise Deployment (built 2015-12-10)

[Isomorphic]

The Developer Console is exactly how you determine the version (this is in the FAQ). So as we've covered, first step is to get the latest build so you have all of the patches. See smartclient.com/builds