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

‹ Longest available agent in UCCX 7 UCCX 8.0 Developer documentation available? ›

DBGet for retreiving a Date

by jasmine - Sep 13 2011 - 2:24am

A test or an examination (or "exam") is an assessment intended to measure a test-taker's knowledge, skill, aptitude, physical fitness, or classification in many other topics (e.g., beliefs). A test may be administered orally, on paper, on a computer, or in a confined area that requires a test taker to physically perform a set of skills. Tests vary in style, rigor and requirements. PK0-003\\ HP2-T18\\ 70-450\\ 000-118\\ 350-040\\ 000-M155\\ 642-357\\ 642-972\\

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: