Extract Data Control Utility
- Last UpdatedNov 10, 2025
- 4 minute read
The Extract Data Control form will only open if there is an extract database in the current MDB.
To open the Extract Data Control form select Paragon, then select Extract Control.

Extract Data Control Window Options
The following options are visible at the top of the Extract Data Control Form:
|
Get All Changes |
refreshes your view of data in databases which own extracts in the current MDB. Two options control if data is collected From the Parent extract only or From all extract ancestors. |
|
Update CE |
When you click Update CE, the list of elements is updated to show the extract element hierarchy for the current element. This option may be used to bring up-to-date the information shown on this form if displayed data has changed since the form was last shown or updated. |
|
Extract Claimlists |
Will open the Extract Claimlists form. |
|
User Claimlists |
Will open the User Claimlists form. |
Elements
An Elements scroll list shows the hierarchy of database elements around a selected element along with information about the extract claim status of each element.
The element hierarchy shown is not the complete element hierarchy as shown in the Members list: only significant elements are shown (or elements which own significant elements) because extract operations only apply to significant elements.
Changes to elements selected from this list can be Flushed, Issued or Dropped by clicking the appropriate option (described later in this section).
Selecting an element in the list will make it the current element. The codes in front of the elements describe the extract claim state:
|
H |
Indicates a claim exists at a lower hierarchy level. |
|
C |
Element is claimed by current user. |
|
E |
Element is significant and claimed to an extract in this MDB. |
|
M |
Element is significant and it, or one of its non-significant children, has been modified in an extract in this MDB |
|
R |
When working in an extract database, issuing, flushing or dropping an element that has a referencing Integrator link will automatically include the link object. The new reference array attribute INCFLU (include flush) returns any Integrator or Status link elements that reference the current element. Flushing, issuing or dropping an element with referencing link objects will act on those link objects even if the element itself is not claimed or modified. The Extract Control form will display an R label on such elements. |
|
X |
Element is claimed from an extract in this MDB, so changes to this element cannot be issued or aborted. |
|
V |
Element has been modified in a Variant extract in this MDB |
Prefix Info
A summary of codes in the above table can be displayed by clicking on Prefix Info.
If there is no code in front of the element then it is either a non-significant element, or it has not been claimed to an extract in this MDB.
When an element is marked CM, changes to the element can be flushed, issued or dropped.
Extract
Click Extract to claim an element and add it to the Extract Claimlist.
Change Highlighting
Change Highlighting can be used to colour changes that have been made to a database during an Extract session by selecting the following:
|
Outstanding in Extract |
Click to highlight in the extract 3D view any elements that have been changed but not yet Flushed or Issued back into the parent database. The highlighting is cleared when the form is closed, or when a subsequent extract operation is performed using the form. In the latter case the checkbox becomes unselected. |
|
Introduced by Get All Changes |
Click to highlight in the extract 3D view any elements that were changed in the parent database outside the extract. The highlighting is cleared when the form is closed, or if the Outstanding in Extract checkbox is selected. In the latter case the Introduced by Get All Changes checkbox becomes unselected. Note: This will only have an effect after Get All Changes has been selected because the changes must be retrieved first before a comparison can be made. |
|
Colour |
Click to open the Change Highlighting Colour window. Choose a colour to use in the 3D view when either of the above have been selected. |
If the World element is selected, then all changes made in all extract databases in the MDB are selected for the Flush/Issue/Drop operation.
Extract DB Operations
Use the following Extract DB Operations options to change the way a Flush, Issue or Drop operation is performed.
|
Element Hierarchy |
If selected Flush/Issue/Drop will work on the selected element and all elements that it owns directly or indirectly. |
|
Single Element |
If selected Flush/Issue/Drop to work on the selected element only |
Rules & Connections
Use the Rules & Connections options to control how a Flush or Issue operation will behave when considering elements which have Rules assigned or Connected items.
|
Always Issue/Flush Changed Rules/Connections |
Click to always Issue or Flush any changed Rules or Connecting items in the database. |
|
Default |
Reset the check box to the default value. |
|
Resultant Additional Elements |
Open a pop up listing all elements which may be impacted when a Flush or Issue takes place. |
Flush, Issue, and Drop
Clicking on the Flush, Issue or Drop option will have an impact on any changes made by all users in the Element hierarchy displaying in the Extract Data Control form.
|
Flush |
Updates the database owning the extract. Extract claims for selected elements are retained. A single element, or part of the hierarchy will be flushed, depending on the Operate on setting. |
|
Issue |
Updates the database owning the extract and release the extract claim. A single element, or part of the hierarchy will be issued, depending on the Operate on setting. |
|
Drop |
Drops changes made to selected elements in extracts in this MDB and releases extract claims. |