Create a custom table (my.synthesis)

Purpose

A custom table takes a user’s query and makes it look like a table. The query may not contain a group statement.

Applications:

• A custom table is a convenient way to reuse a query that is frequently run, but not frequently edited.

  • The custom table is shared with all users with the default finder. Custom tables are a convenient way to share queries.

  • To add a field to an existing table, create it with a select statement and then create a custom table.

• A custom table can contain the results of several queries. It is a good way to combine data from different tables into a union.

• To restrict access to data. If a role in Devo should have access to some of the content of a table, but not other content in the same table:

To send data to a table that has never existed in Devo, create a my.app table instead of a custom table.

To create a parser for a my.app table, try the autoparser as a more convenient option than a custom table. The autoparser and a custom table can be applied to the same my.app tag.

What permissions do I need?

To use this feature you need two different permissions:

• View level of the Finders permission. This permission is required to access a search, which is necessary to create a custom table.

• The Custom tables permission. This permission is required to enable the custom table options in the toolbar menu of the search window.

Open

Creating your custom table

To define a new custom table, go to Data search and open the data table you want to use as the base for your custom table. Select the options menu in the right-hand side of the toolbar, then go to New → Custom table → New.

You will see the Custom table window, where you can do the following:

Open

1. Give the custom table a name. Choose either my.synthesis, my.tech or my.parser, then enter the third and fourth levels of the table name. Note that the table name must contain at least one alphanumeric character and not contain spaces or special characters (underscores are allowed).

2. Check this option if you want to include raw and rawMessage fields in your custom table. These fields are not shown by default in tables. See more information about unrevealed fields in this article.

3. Select New field to add new fields to the custom table.

4. Configure the custom table fields. You can edit the source table names and the values they show.

5. You can edit the columns' values and names or delete them.

6. Click Create when you are done.

Accessing your custom table

The new custom table will appear in Data search → Explore your data.