transformations:selectdbrowsbykeys
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revision | |||
— | transformations:selectdbrowsbykeys [2021/04/08 23:49] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ======SELECT MATCHING DATABASE ROWS====== | ||
+ | Category: Import / Database\\ | ||
+ | |||
+ | \\ | ||
+ | =====Description===== | ||
+ | Selects rows from a database table where a combination of key fields matches a combination of key fields in an EasyMorph table. \\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | This action can be used for // | ||
+ | |||
+ | Another use case is // | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | Under the hood, the action creates a temporary table in the target database, uploads key field combinations into it, and performs a SELECT..WHERE..EXISTS statement. After the statement is executed the temporary table is deleted.\\ | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: | ||
transformations/selectdbrowsbykeys.txt · Last modified: 2021/04/08 23:49 by craigt