DBGet for retreiving a Date

Posted Tue, 05/25/2010 - 11:43am by olel

Hi Guys

I need to develop a script in which I will retrive the last time an agent has been connected (the eventDateTime from dbo.AgentStateDetail table from db_CRA UCCX database). I have then set up a dbRead step and then the dbGet. But the eventDateTime is a JAVA.SQL.TimeStamp and I don't find any UCCx variable type corresponding. Did someone succeed to retreive a date from dbGet step?

 

Thanks

 

Regards

 

Olivier LELIEVRE

‹ New to scripting UCCX Scripting - simple logging ›

DBGet for retreiving a Date

by olel - May 26 2010 - 2:28am

I have found it. When you declare a variable ito UCCX, you can use the drop down list to define its type (Interger, String) ...

If the type you search for is not included in the list, just enter it as it should be. For the problem here, just enter java.sql.Timestamp.

 

Regards

Recommended Reading: