Hello ,
The purpose of this article is to demonstrate and explain how Query functions for String, Value, Date and Boolean works.
This will help Comp Admins to achieve when there is a complex requirement, by trying to construct the Formula and assign in a rule for Pipeline calculation to generate results;
Comp Admin will create a custom SQL SELECT Statements in a efficient way that results to return within 5 seconds incase it will be session run time out and results won’t be appearing.
Admins to ensure that the uptime, performance are taken care.
SQL Statement will have parameter condition to set and to be inserted in Plug-in table (TCMP).
By running the pipeline job, rule gets processed and calls the custom SQL query during the stages so that you can get derived results out of it.
Let’s go overview to understand more details about it.
Query for String
Assign the Formula to a Rule based on Rule usage
Insert the SQL Select Statement to CS_Pluginquery Table
Query for Boolean
Query for Date
Query for Value
Using above use-cases, Pipeline results are generated for the functions ;
Query for String , Boolean , Date & Value
Note : If SQL Select Statements are not inserted, will receive pipeline errors as shown here below
Disclaimers
- SELECT Statement results should return within 5 seconds else timeout
- Allowed ONLY SELECT Statements.
- No UPDATE, INSERT & DELETE Statements allowed.
- No Stored Procs or Packages to call
Informative Yoga!!!
This is interesting! We can get rid of building Stagehooks for any minor requirements. Good that you have stressed on the performance aspect when using Query functions.
Suresh, your thinking on eliminating Stage-hook is highlight and added advantage for Comp admin and support team for risk free deployment and no ticketless
Yogananda Muthaiah – The 5 sec aspect is very important else the function will not work. Nice to see another wonderful article.
you Nailed it ! That’s cool Saurabh!
Yogananda Muthaiah – for getting the query function into the system you have to go through support to get the insert script executed.
yes Agree for Production.
Nice article Yoga 🙂
Thanks Teja(Mike)!!
Thanks much for great article. Read this long back and finally we got a use case to implement recently which was successful. Appreciate for sharing your knowledge.