Fetching records from External db

bondicoffee

Hi,

While fetching last updated records from external DB, following is the process I am trying to implement :

FIND RegularUser WHERE RegularUser.ID IS DEFINED ORDER BY RegularUser.ID DESC TAKE BEST 1
RegularUser.TempDate=DATE_ADD(CURRENT_DATE,-10)
FIND ExternalTable WHERE ExternalTable.ModifiedDate >=01/01/2018 ----------->Works fine
FIND ExternalTable WHERE ExternalTable.ModifiedDate >=RegularUser.TempDate ---> Gives error :

On Browser :
Internal error. Error reading business object. conversion error from string "29/12/2017 00:00" [SQLState:22018, ISC error code:335544334]
Server Output:
2018-01-08 13:53:36,553 ERROR bsv#admin -Execution Exception after starting process SearchOrder message Internal error. Error reading business object. conversion error from string "29/12/2017 00:00" [SQLState:22018, ISC error code:335544334]

I tried AS_DATE function, but still, it is failing.

aware_support

This is really a deficiency in the system - some functions do not work with external databases. We'll try to fix it in the next builds. In the meantime you should use a stored procedure if your external database supports it. If not, create another attribute in the RegularUser of the Date type, rather than Timestamp, with the following rule:

RegularUser.DateAttr = DATE_PART (RegularUser.TempDate)

and then use this attribute in the query.

bondicoffee

Hi,

The above logic has stopped working on the latest build. Have there been any changes in this?

Thanks.