DB Picker¶
The Pick Resource Instances dialog opens when clicking Pick from Database inside the Primary Key Values panel of a database-imported resource. It provides a live browser of the actual records in the datasource table linked to this environment, allowing you to remap the resource to a different database record.
When to Use It¶
Use the DB Picker when:
- The resource was mapped to the wrong record during import
- The underlying primary key value changed in the source database
- You want to reassign the resource instance to a different entity in the same table
Dialog Layout¶
Header¶
The dialog header shows:
| Element | Description |
|---|---|
| Title | "Pick Resource Instances" |
| Subtitle | Environment name and table path (e.g., SIT · banking.account) |
| Selection counter | 1 / 1 badge — shows how many records are currently selected out of the maximum allowed (1) |
| Clear | Button to deselect the current selection without closing the dialog |
| × | Closes the dialog without making changes |
Datasource Info Bar¶
Below the header, a summary bar shows the datasource context for the current query:
| Pill | Description |
|---|---|
| DATASOURCE | The datasource name linked to this environment (e.g., SIT-DS) |
| TABLE | The specific table being browsed (e.g., banking.account) |
| STATUS | Connectivity status of the datasource — Online (green) or offline |
Search Bar¶
A full-width search field filters records across all visible columns. The search is applied as you type.
Record Table¶
The table displays the actual records from the datasource with columns corresponding to the resource type's attributes. Columns are color-coded by their role:
| Color | Role | Description |
|---|---|---|
| 🟠 Orange header | Primary Key | The attribute marked as PK — uniquely identifies each record |
| 🟢 Green header | Resource Name | The attribute marked as RN — the human-readable name extracted from each record |
| 🔵 Blue header | Description | The attribute marked as RD — the descriptive field extracted from each record |
| 🟩 Light green | Already Imported | Records that are already mapped to another resource in this profile |
| 🔴 Red | Sensitive | Attributes marked as sensitive — values are obfuscated |
The color legend is shown at the bottom of the dialog.
Pagination¶
| Control | Description |
|---|---|
| Jump to first page | |
| / | Previous / next page |
| Page number buttons | Direct navigation to a specific page |
| Show N rows | Dropdown to control how many records are displayed per page |
| X–Y of Z | Shows the current range and total record count |
Selecting a Record¶
Click anywhere on a record row to select it. The row highlights and the checkbox on the left becomes checked. The selection counter in the header updates to reflect the current selection.
Single selection
Only one record can be selected at a time. Selecting a new row automatically deselects the previous one.
Confirming the Selection¶
Click Confirm N Record(s) to apply the selection. The dialog closes and the PK input field in the Environments tab is updated with the primary key value of the selected record.
Click Cancel to close the dialog without making any changes.
Remapping impact
Confirming a new record updates the PK value for this environment. Save Changes must still be clicked in the Edit Resource dialog to persist the remapping.