Skip to main content

Imported SQL Editor Dialog

  • Updated

BackPrevious Topic Next TopicNext

This image notes any new content for version 17 of the product. For more information please see the Release Notes or What's New topics.Imported SQL Editor Dialog

You can use the editor to edit your SQL statement directly in Logi Report Designer. It appears when you do one of the following:

  • In the Catalog Manager, right-click a JDBC connection node and then select Add SQL from the shortcut menu.
  • In the Catalog Manager, right-click an SQL under the Imported SQLs node and then select Update from the shortcut menu.
  • In the Choose Data dialog or component wizard when working with a page report created based on query resources, expand the Imported SQLs node in a data source that has a JDBC connection and then select <Add SQL...>.

Imported SQL Editor

SQL Name

Specifies the name of the SQL statement when you are adding it to the catalog.

From DB Catalog

Specifies the catalog in the database where comes the SQL statement.

Save & Exit

Saves the SQL statement with the provided name and exits the editor if there are no errors in the SQL statement. Otherwise, a warning message will pop up showing the errors. You need to correct all the errors to save the SQL statement.

Import SQL

Imports the SQL statement from an SQL file.

Export SQL

Exports the SQL statement to an SQL file.

Help

Displays the help document about this feature.

Toolbar

Lists the commands that facilitate the process of composing the SQL statement.

  • Cut buttonCut
    Cuts the selected text in the text panel.
  • Copy buttonCopy
    Copies the selected text in the text panel.
  • Paste buttonPaste
    Pastes the text that was previously cut or copied in the text panel.
  • Delete buttonDelete
    Deletes the selected text from the text panel.
  • Undo buttonUndo
    Undoes an action.
  • Redo buttonRedo
    Cancels undoing an action.
  • Search buttonSearch
    Searches for text in the text panel, and replaces the found text with different text.
  • Check buttonCheck
    Tests whether there are errors in the SQL statement.
  • Add Bookmark buttonAdd Bookmark
    Adds a bookmark to a line.
  • Go to Previous Bookmark buttonGo to Previous Bookmark
    Goes to the previous bookmark.
  • Go to Next Bookmark buttonGo to Next Bookmark
    Goes to the next bookmark.
  • Clear buttonClear All Bookmarks
    Removes all the bookmarks.

Text panel

You can write or edit your SQL statement here. You can type the statement directly, paste it from another text editor, or import it from an SQL file.

BackPrevious Topic Next TopicNext