Query Management
In Database Browser users can create, delete, clone, update queries as per their requirement.
Create Query
Click Add-ons > Database Browser > Start.
The following screen appears.
Click on Create New Query to create new query.
Mention the required Query name.
Select the required Database Connection.
Select Query Wizard or Custom SQL.
Select the required table.
Select the required fields to pull data from Database into sheet.
Click on Filter to add Filters.
Select the required field, value etc for filtering.
Click the delete icon to delete filter.
Users can add multiple filters.
Select the required fields for sorting.
Click delete icon to delete sorting.
Select the required max results.
Destination
Choose the required sheet to save data.
Select the starting Cell.
Switch on Include Header to include header.
Switch on Clear Sheet before execution to clear old sheet data.
Switch on Run automatically to schedule a service.
Notification Settings
Switch on Notify on Execution to send notification after successful execution.
Click on Setup Email Template to setup Email template.
Switch on Add attachments from Google Drive to add attachments from Google Drive.
Select the required Sheet.
Select the range as Full Sheet or Range.
Mention the required range.
Switch on Embed as Inline table if required.
Switch on Ignore empty rows if required.
Switch on Attach PDF if required.
The sample Email Template looks like the following.
Mention the required From Name.
Mention the required To, Cc, Subject.
Compose the message as required.
Select save to save email template.
Select Cancel to cancel email template.
Click Execute to execute the service.
Click Save to save the service.
Click Back to go back.
Delete Query
Click on Delete icon to Delete the service.
Clone Query
Click on Clone icon to clone the service.
Clone means making an identical copy of the previously saved service.
Update Query
Open ththe saved query.
Edit as per requirement.
Save the service.
Again execute the service.
