Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

How to get date in UCCX script from Database

Hi.

I have configured simple script for testing purpose and now available to get any single field from database and write this field to UCCX  variable.

Now i need to perform such query:

select convert(varchar(10), getdate(), 111)

It returns date in SQL.

Is it possible to write it to UCCX variable in script using DB Read and DB Get steps?

Everyone's tags (8)
1 REPLY

How to get date in UCCX script from Database

Hi,

sure, you need to alias it, e.g. SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [MYDATE]

Don't forget to create a 'dummy' view containing the column MYDATE.

Or, if it's possible, create a view on your custom SQL. This is what I would recommend.

G.

353
Views
0
Helpful
1
Replies