General​

Overview

In the General page, you can modify the default settings for the entire QueryPie application.

Default Settings

• Company Name : Enter the company name to be displayed in the profile area and other relevant sections.

• Timezone : Set the time zone that will be applied to all date and time information displayed throughout QueryPie.

• Date Format : Specify the format for displaying dates.

• Audit Log Retention Period : Configure the retention period for audit logs. Currently, this is fixed at 5 years.

• Go to System Properties : Click to view the system configuration details.

System Properties

In the System Properties page, you can view the configuration settings for QueryPie's system components and save them as a file.

Query Sharing Settings

In the Query Sharing section, you can choose whether to send SQL queries to Git. By default, query sharing is turned off. A settings modal will pop up when you click the Query Sharing Setting button. Additional input fields will appear if you select the option to turn Query Sharing on.

• Git Repository URL : The URL of the Git repository where the queries will be sent.

• Git Branch : The name of the branch within the repository.

• Authentication Type : The method used to authenticate query transfer requests.

  • OAuth : Enter your GitHub ID and Access Token.

  • SSH : Provide the public key, private key, and passphrase.

Once all fields are completed, click the Test button to verify authentication. If successful, click the OK button to save the settings.