When setting up actions on a dashboard, you can either prompt the person to fill in a value for each field, or have a field automatically filled in via parameters (such as values set in dashboard filters). Once filled out, the action will insert the record into the primary table that underlies the model. The Create action will present a form with editable fields for each column in the primary source table backing the model. The Create action is the INSERT INTO action. The Delete action will create a form that prompts people for an entity key, and will delete the record (row) corresponding to that ID in the underlying table that backs the model. For other values, you can either prompt the person to fill in a value for each field, or have a field automatically filled in via parameters (such as values set in dashboard filters). When setting up an Update action on a dashboard, you must pass an entity key (like an ID) to the action from a dashboard filter. The update action will present people with a form with editable fields for each column in the primary source table. The underlying table can only have one primary (entity) key.The query should simply select that table in the data step of the notebook editor, and nothing more: no joins, no custom columns, no filters or summarization, no sorting. The model must “wrap” a single raw table in a database.Basic actions are unavailable for models created with native queries (SQL). Models built using the graphical query builder.Click on the … next to the New Action and select Create basic actions.īasic actions are only available for “basic” models:.On the model detail page, click on the Actions tab.Select a model and click on the info button, then click on Model detail.Once actions are enabled, you can create basic actions on a new or existing model that only wraps a single database table. If you only want to give people the option to update a subset of columns, or update columns in multiple tables, you can write a custom action. By auto-track the schema, we mean that Metabase will create action forms for people to fill out that include all of the fields from the primary source table that underlies that model. Basic actions auto-track the schema of the source table backing the model. Basic actions are “implicit” actions that do things that people typically want to do when interacting with a database: Create, Update, Delete.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |