Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Manasa Chidirala (ManasaCh)
HCL
Senior Consultant
HCL
IN
ManasaCh Member since 2014 3 posts
HCL
Posted: Jul 25, 2017
Last activity: Jul 25, 2017
Posted: 25 Jul 2017 7:44 EDT
Last activity: 25 Jul 2017 8:03 EDT
Closed

Is it possible to user functions inside a Connect-SQL rule

Hi,

I have a requirement to use Connect-SQL rule. I have to fetch the records which are resolved today. I am planning write a query using pyResolvedTimeStamp and pxCurrentDateTime. I need only the date and year part of these two properties.(Time is not required). For this is it possible to use functions in Connect-SQL query.

Thanks in advance.

Regards,

Manasa

To see attachments, please log in.
Low-Code App Development

Posted: 7 years ago
Posted: 25 Jul 2017 8:01 EDT
Paul Gentile (PaulGentile_GCS)
PEGA
Principal Engineer, Technical Support, 1:1 Customer Engagement
Pegasystems Inc.
US

I've seen it many times in select and from clauses. I suspect you can also do it inside a DECLARE BEGIN END in the Obj-Save of a Connect-SQL as stored procedures are often configured. 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice