Question
Can we pass parameter to Connect SQL ?
Was wondering if we can pass parameter to connect sql rule.
Ideally we have a page whose value is used in the connect sql rule ?
Can we use something like Param.Varaible in connect SQL.
I think he wants to know whether we can pass/refer parameters in Connect SQL and not properties on a page
You are right Bhanu.
I am trying to find whether parameter can be refered in connect sql.
Hi,
We can pass the parameters for Connect-SQL rule.
Below is the sample format for parameterizing stored procedure.
\{ call schemaname.procname ( {ASIS:MyPageName.PropertyName},{MyPageName.PropertyName OUT}) \}
https://pdn.pega.com/forums/integration/it-possible-call-stored-procedures-pega
Hope this info helps!
Here you are using MyPageName.PropertyName.
I am trying to avoid creation of page.
Hi ,
can anyone tell me if passing date as below is correct,
AND pxCreateDateTime>={myPage.FromDate Date}
AND pxCreateDateTime<={myPage.ToDate Date}
AND pxCreateDateTime>={myPage.StartDateRange Date}
And my requirement is to search based on where clause (A and B and C.) If user enters A and B , then have to search only based on A and B , excluding C.
But IN Connect-SQL, it is searching like A value, B value and taking C as null.
Please let me know where am making mistake.
Thanks,
Sas
Hi
Have a look at this article : https://pdn.pega.com/asis-keyword-build-dynamic-where-clause-connect-sql-rules