Hi Everyone,

I am using a simple jdbc node with Lavastorm 4.5.3 to retrieve data from a MS SQL database.
As we then use this data and export it into a brd file for the business to use i have changed the SqlDateType parameter to datetime to match what is in the database table.

My issue is that when i run this via the bre it exports the data into the brd as datetime but when scheduled and using the Lae Controller from the deplyed Brx file it only exports the datetime fields as a date which is causing issues for the people who need this data.

Can someone please tell me why this is happening and how to rectify as the brx has the correct property associated prop:ls.brain.node.java.QueryDump.sqlDateType=date time

Regards,


Keith