The project settings window changes project-wide settings such as the project name and connection order, and settings that apply only to you, such as the date format of SQL results. In account projects, the watermark, role permissions and sync data cleanup are also set here.
Open it with the Project Settings button (the gear) at the top of the project screen. On desktop you can also right-click a work tab and click the Project Settings item. If that tab is not visible, it is brought to the front first.
What's on the screen
| No. | Name | Description |
|---|---|---|
| 1 | Tabs | Which tabs you see depends on the project type and your role (see 'Tabs and when they appear' below). |
| 2 | Project Name field | The project name. It cannot be empty. |
| 3 | Connection Order list | The project's connections. Drag a row to change the order in which connections appear in the explorer and the lists. Private connections have the Private mark, and connections disabled by plan cleanup have the Disabled mark. |
| 4 | Save button | Saves the changes on all tabs at once. Dimmed until you change something. After saving, the window closes and the project is loaded again with the new settings. The Cancel button closes without saving. |
- If a field has a problem when you save, the window moves to the tab with that field and does not save.
- In account projects, the project name and connection order change for every member.
Tabs and when they appear
| Tab | Local project | Account project | Explained in |
|---|---|---|---|
| tab | Shown | The owner and members with the All Permissions permission | 'What's on the screen' above |
| tab | Shown | All members | 'SQL Editor tab' below |
| tab | Not available | The owner and members with the All Permissions permission. Read-only for those members | 'Watermark tab' below |
| tab | Not available | The owner and members with the All Permissions permission. Read-only for those members | Sharing and members |
| tab | Shown | The owner and members with the All Permissions permission | Generating source code |
| tab | Shown once code generation is on | Once code generation is on, the owner and members with the All Permissions permission | Generating source code |
| tab | Not available | The owner | 'Data Cleanup tab' below |
- In a local project, the user of this device is the owner, so every tab a local project has is shown even without sign-in.
- Other members of an account project see only the tab. Saving stores only the personal settings on that tab and does not change the project's settings.
SQL Editor tab
How SQL results are shown and how the editor behaves. The values on this tab are personal settings: they apply only to you in this project and do not affect other members. Local projects save them on this device; account projects save them in your account, so they are the same on other devices.
| No. | Name | Description |
|---|---|---|
| 1 | Timezone field | Values with time zone information (such as TIMESTAMP WITH TIME ZONE) are converted to this time zone. Values without time zone information are shown as stored in the database. It starts as this device's time zone. |
| 2 | Preview button | Opens a window that shows the current time in the three formats below and the chosen time zone. Use it to check the formats before saving. |
| 3 | Format fields | The Timestamp Format field, the Date Format field and the Time Format field. Combine YYYY (year), MM (month), DD (day), HH (hour), mm (minute), ss (second) and SSS (millisecond). The initial values are the formats shown dimmed in the fields. |
| 4 | Indentation area | Chooses whether indenting with the Tab key in the SQL editor inserts Spaces or Tabs, and the width (2, 4 or 8). It starts as two spaces. |
| 5 | Highlight unknown columns option | When on, the SQL editor underlines columns that do not seem to exist in the referenced tables. On at first. See SQL editor. |
| 6 | Connection settings by profile area | Desktop only. Sets the Connection idle timeout field and the Transaction idle timeout field for each connection profile environment. Only whole numbers from 30 to 720 minutes are accepted. Changes apply from the next connection. |
| 7 | Restore all profile defaults button | Returns the idle timeouts of all environments to their initial values. They take effect when you save. |
- The formats of the Timestamp Format field, the Date Format field and the Time Format field apply to the result grid, the value preview panel and dashboard tiles.
- The initial idle timeouts per environment and what happens when they run out are explained in Connection profiles.
- The web app has no environment tabs; it only shows a notice that the connection idle timeout is fixed at 30 minutes.
- If an idle timeout field is out of range, a warning icon appears on that environment tab, and saving brings you back to this tab.
Changing how dates are shown
- Open the project settings and the tab.
- Choose a time zone in the Timezone field (1) and edit the format fields (3).
- Check the result with the Preview button (2).
- Click the Save button. The SQL results of this project are shown in the new format.
Watermark tab
Sets the text of the watermark added when an ERD is exported or copied as an image. Account projects only. Which watermark is added depends on the plan; the rules are explained in Export as image.
| No. | Name | Description |
|---|---|---|
| 1 | Enabled option | Whether to add the text you set. |
| 2 | Watermark Text field | The text to add. |
| 3 | Template variables hint | You can put ${loginId} (login ID), ${nickname} (nickname), ${time} (time of export) and ${projectName} (project name) in the text. They are replaced with the values of the person exporting. |
Whether you can edit the fields depends on the project's plan.
| Project's plan | On the tab |
|---|---|
| A plan that lets you set the watermark text | Both fields can be edited. |
| A plan with a fixed NeoSQL watermark | The fields are dimmed and the Your plan requires the NeoSQL watermark. notice appears. |
| A plan without a watermark | The fields are dimmed and the Watermark is removed on your plan. notice appears. |
| An education plan | The text set by the education plan is shown dimmed and the Your education plan uses a fixed watermark that always appears on ERD exports. notice appears. |
- Who actually gets the text is set with the Watermark Enforce item of the role permissions (Sharing and members).
- Only the owner changes the values on the tab. Members with the All Permissions permission see it read-only, with the Only the project owner can change role permissions and the watermark. You can view the current values. notice.
Data Cleanup tab
When schemas, tables or ERDs are deleted in an account project, deletion records remain on the NeoSQL server for synchronization. As they pile up, members' first opening of the project gets slower, so the owner cleans them up on the tab.
| No. | Name | Description |
|---|---|---|
| 1 | Cleanable items mark | The number of deletion records left on the server. |
| 2 | Last cleanup mark | When the last cleanup ran. If it has never run, the Never cleaned up mark appears. |
| 3 | Clean Up Now button | Cleans up right away. It runs regardless of the window's Save button. |
The Clean Up Now button can be clicked only when the number of records has reached the amount set by the server and the set time has passed since the last cleanup. Otherwise, the time of the next possible cleanup or the number still needed appears above the button.
- Open the account project as its owner and open the tab of the project settings.
- Click the Clean Up Now button (3). The Sync Data Cleanup window appears.
- Confirm to clean up. When it finishes, the Cleanup complete. Reloading the project. notice appears, and confirming it reloads the app.
- After a cleanup, every member downloads the project data again the next time they open the project. That first opening takes longer.
- If a cleanup ran recently, the A cleanup was run recently. Please try again later. notice appears.
Things to keep in mind
- Before the app reloads after a data cleanup, on desktop it first asks about unsaved changes in other projects open in tabs. If you cancel, the app does not reload.
- The tab and the tab are also shown to members with the All Permissions permission, but read-only. To change the values, open them with the owner's account.
- The values on the SQL Editor tab are separate for each project. To use the same formats in another project, change them in that project's settings too.
- If your personal settings could not be loaded, saving stops and the Personal settings could not be loaded. Reopen this dialog before saving. notice appears. Close the window and open it again.
Related screens
- Project screen layout: The screen with the settings button.
- Sharing and members: Setting permissions for each role on the tab.
- Generating source code: The tab and the tab.
- Connection profiles: Environments and the initial idle timeouts per environment.
- Export as image: The rules for adding the watermark.
- Project AI settings: The window opened by the AI Settings button in the header.