Screens: Projects

Project settings

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.

Where you can use itWebDesktopWithout signing inSigned inLocal projectsAccount projects

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.NameDescription
1TabsWhich tabs you see depends on the project type and your role (see 'Tabs and when they appear' below).
2Project Name fieldThe project name. It cannot be empty.
3Connection Order listThe 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.
4Save buttonSaves 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

TabLocal projectAccount projectExplained in
Project settingsProject Config tabShownThe owner and members with the All Permissions permission'What's on the screen' above
Project settingsSQL Editor tabShownAll members'SQL Editor tab' below
Project settingsWatermark tabNot availableThe owner and members with the All Permissions permission. Read-only for those members'Watermark tab' below
Project settingsRole Permissions tabNot availableThe owner and members with the All Permissions permission. Read-only for those membersSharing and members
Project settingsCode Generator tabShownThe owner and members with the All Permissions permissionGenerating source code
Project settingsAudit Table tabShown once code generation is onOnce code generation is on, the owner and members with the All Permissions permissionGenerating source code
Project settingsData Cleanup tabNot availableThe 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 Project settingsSQL Editor 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.NameDescription
1Timezone fieldValues 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.
2Preview buttonOpens 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.
3Format fieldsThe 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.
4Indentation areaChooses 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.
5Highlight unknown columns optionWhen on, the SQL editor underlines columns that do not seem to exist in the referenced tables. On at first. See SQL editor.
6Connection settings by profile areaDesktop 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.
7Restore all profile defaults buttonReturns 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

  1. Open the project settings and the Project settingsSQL Editor tab.
  2. Choose a time zone in the Timezone field (1) and edit the format fields (3).
  3. Check the result with the Preview button (2).
  4. 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.NameDescription
1Enabled optionWhether to add the text you set.
2Watermark Text fieldThe text to add.
3Template variables hintYou 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 planOn the Project settingsWatermark tab
A plan that lets you set the watermark textBoth fields can be edited.
A plan with a fixed NeoSQL watermarkThe fields are dimmed and the Your plan requires the NeoSQL watermark. notice appears.
A plan without a watermarkThe fields are dimmed and the Watermark is removed on your plan. notice appears.
An education planThe 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 Project settingsWatermark 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 Project settingsData Cleanup tab.

No.NameDescription
1Cleanable items markThe number of deletion records left on the server.
2Last cleanup markWhen the last cleanup ran. If it has never run, the Never cleaned up mark appears.
3Clean Up Now buttonCleans 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.

  1. Open the account project as its owner and open the Project settingsData Cleanup tab of the project settings.
  2. Click the Clean Up Now button (3). The Sync Data Cleanup window appears.
  3. 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 Project settingsWatermark tab and the Project settingsRole Permissions 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.