Question

2
Replies
132
Views
 Manasa Chidirala (ManasaCh)
HCL
Senior Consultant
HCL
IN
ManasaCh Member since 2014 3 posts
HCL
Posted: July 25, 2017
Last activity: July 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

Low-Code App Development
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 25 Jul 2017 8:01 EDT
Paul Gentile (PaulGentile_GCS)
PEGA
Sr. Software Solutions Engineer
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.