Introduction
It is important to be able to go in and modify existing queries and sub queries so that they work and are up to date.
Prerequisites
The query or sub query must already exist.
|
Quick Steps |
| 1 |
Search for and open the entity |
| 2 |
Open the Queries section |
| 3 |
Open the group section, then open the query |
| 4 |
Edit the query |
| 5 |
Save the entity |
Detailed Steps
Step 1. Search for and open the entity.
Step 2. Open the Queries section.
This is where you can edit a query.
Step 3. Open the group section, then open the query.
This opens the selected group where you can select the correct query. Open the Test group section and select the query you'd like to edit. This opens the window where you will be modifying your SQL code.
Step 4. Edit the query.
Update the SQL code so it executes the way you want it to.
If you have added parameters you can change the data type if you want to, or you can update the mapping for unmapped columns, if required.
Step 5. Save the entity.
It will save the entity.
What are the improvements over S3 Version 6?
The process is identical.
Related Articles
Create a New Sub Query
Add a Sub Query
Add a Query to an Entity
Add a Query to an Entity with the Query Builder
Add a Query with a Join and Map the Columns
Delete a Query
This post is part of the Entity topic. Click here to open the Entity Overview.
#Xelence
#Entity