How to edit the join clause

Version: Yurbi v12

Role: Architect

Permission: Architect access to the application


Access the Architect Section

This section shows the step on how you can access the architect section

1. Once logged in, Click on Architect found in the sidebar.

A screenshot of a web pageAI-generated content may be incorrect.

Application and Report Type

This section shows the steps on how you can access the application and report type where the join clause you want to edit is housed in.

1. Select the app to edit in App List and click Configure.

Note: For this guide, we have created a sample. Applications will vary depending on your organization's admin.

A screenshot of a computerAI-generated content may be incorrect.

2. In the Report Type section, click the report type where the desired join clause you want to edit is housed in and click Configure

A screenshot of a computerAI-generated content may be incorrect.

 

Editing Join Clause

This section shows the steps on how you can edit the join clause of your database.

1. To edit a database table with a join clause, select the database

A screenshot of a search engineAI-generated content may be incorrect.

2. Click the three dots button

A screenshot of a search engineAI-generated content may be incorrect.

3. Click Edit Join Table

A screenshot of a computerAI-generated content may be incorrect.

4. Edit Table Join dialog box will appear.

A screenshot of a computerAI-generated content may be incorrect.

5. Select your new desired join type.

A blue line on a white backgroundAI-generated content may be incorrect.

6. Do not change anything within the Parent Alias field box.

A white rectangular object with a black borderAI-generated content may be incorrect.

7. Choose your new Field 1.

A screenshot of a computerAI-generated content may be incorrect.

8. 1st Operator should be equal sign [=].

A white rectangular object with black linesAI-generated content may be incorrect.

 9. Alias should not be changed.

A white rectangular object with a black borderAI-generated content may be incorrect.

 10. Select your new 1st Field 2 in the dropdown box.

A screenshot of a computerAI-generated content may be incorrect.

 11. For the 2nd Operator it should always be And.

A white rectangular object with a black borderAI-generated content may be incorrect.

 12. Click Save.

A blue rectangle with white textAI-generated content may be incorrect.

Deleting a Join Clause

1. To delete a join causeselect the database

A screenshot of a search engineAI-generated content may be incorrect.

2. Click the three dots button

A screenshot of a search engineAI-generated content may be incorrect.

3. Click Delete Table Join

A screenshot of a computerAI-generated content may be incorrect.

4. Type DELETE

A screenshot of a computerAI-generated content may be incorrect.

5. Click Remove

A screenshot of a computer errorAI-generated content may be incorrect.

 

To know if the delete has been successful, the join clause column of the database table will be empty


And there you have it! You now know how to edit an existing join clause of your database!