To edit a custom SQL query's name, description or visibility properties:

  • Go to the Schema Browser ( (Admin) > Developer Links > Schema Browser)
  • Select the schema and query/table of interest and then click Edit Properties.
  • The Edit query properties page will appear, for example:

Available Query Properties

Name: This value appears as the title of the query/table in the Schema Browser, data grids, etc.

Description: Text entered here will be shown with your query in the Schema Browser.

Available in child folders: Queries live in a particular folder on LabKey Server, but can be marked as inheritable by setting this property to 'yes'. Note that the query will only be available in child folders containing the matching base schema and table.

Hidden from the user: If you set this field to 'yes', then the query will no longer appear in the Schema Browser, or other lists of available queries. It will still appear on the list of available base queries when you create a new query.

Discussion

previousnext
 
expand all collapse all