|
<< Click to Display Table of Contents >> Request Views and Stored Procedures |
Introduction
In Bizagi PaaS, managing requests for Views and Stored Procedures (SP) is a structured process designed to ensure the correct implementation and functionality of these queries in your environment. This article outlines the necessary steps to submit and process such requests, along with important recommendations and considerations.
Keep in mind that the requested Views and SPs are created in the main database and replicated to the ODS. You will consult the ODS to verify and execute the views and SPs requested.
Prerequisites
Before submitting a request, you must ensure:
•Create the query to display in the View or that the SP should contain.
•Identify whether the request is for a View or a Stored Procedure.
•Identify the environment where it will be applied (it can be applied to all your environments).
•Propose a name for the view or stored procedure.
Procedure
1.Send the query through a Support ticket, specifying whether it is a View or a Stored Procedure, the environment to apply it, and the proposed name.
2.Internal Review: The ticket is escalated internally for the Bizagi DBA to review and create the view or SP.
3.Customer Responsibility: It is your responsibility to correctly assemble the query and ensure it reflects what you want to display.
4.If any changes are required, you should submit a new ticket with the updated query.
Important considerations
•Stored procedures cannot include write actions. If any are detected, Bizagi will return the query through the ticket, and request changes.
•Views cannot have ORDER BY clauses.
•Both views and SPs are executed on your ODS, thus these are read-only procedures.
•Bizagi WILL adjust the name proposed for requested Views and SPs to align with internal nomenclature to manage all customer's requests. These names cannot be changed.
•Bizagi is not responsible for the accuracy of the query content. If the query is poorly constructed or does not display the desired information, you should request the adjustment via ticket by submitting your adjusted query.
Conclusion
The process of handling requests for Views and Stored Procedures in Bizagi PaaS is designed to ensure the correct implementation and functioning of these queries. By following the mentioned steps and recommendations, you can ensure requests are processed efficiently and effectively.
For reference to create views and procedures visit:
Procedures: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16
Last Updated 5/6/2025 4:42:24 PM