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
Posted: 3 years ago
Posted: 3 years ago
Hi'
I am trying to browse the data actually
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.