Clean Relational Data

From FojiSoft Docs
Revision as of 15:36, 31 March 2026 by Chris.Hansen (talk | contribs) (Created page with "The Clean Relation Data source allows automatic removal of rows from relational data tables. The source will run a query against a connected database and another query against the relational data table to find matching rows. Rows returned by the relational data query and not found in the database query will then be deleted from the relational data table. == Configuration == # Select the target source database connection # Determine the scan interval (time between clean...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The Clean Relation Data source allows automatic removal of rows from relational data tables. The source will run a query against a connected database and another query against the relational data table to find matching rows. Rows returned by the relational data query and not found in the database query will then be deleted from the relational data table.

Configuration

  1. Select the target source database connection
  2. Determine the scan interval (time between cleanup runs)
  3. Select the target relational data table
  4. Select the columns in the relational data table to be used as the key when matching rows between the queries. Any additional columns returned by the queries will be ignored.

Database Query (Records to Keep)

Define the query to run against the connected database. Rows returned by this query will be kept. Any rows in the other query which are not found in this Keep query will be deleted from the table.

Relational Data Query (Potential Deletion Candidates)

Define the query to run against the Relational Data storage. Rows returned by this query that are not found in the Database Query will be deleted from the target table. Any rows not returned by this query will be ignored and remain in the table.

Retrieved from "https://docs.foji.io/index.php?title=Clean_Relational_Data&oldid=3001"