User Tools

Site Tools


transformations:selectdbrowsbykeys

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
transformations:selectdbrowsbykeys [2021/03/28 14:10] craigttransformations:selectdbrowsbykeys [2021/04/08 23:49] (current) craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-Selects rows from a database table where a combination of key fields matches a combination of key fields in an EasyMorph table.  +Selects rows from a database table where a combination of key fields matches a combination of key fields in an EasyMorph table. \\
- +
-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.\\+
  
 \\  \\ 
Line 14: Line 12:
  
 Another use case is //cross-source filtering// which means importing database records having IDs that are obtained from another data source (e.g. text file or spreadsheet).\\ Another use case is //cross-source filtering// which means importing database records having IDs that are obtained from another data source (e.g. text file or spreadsheet).\\
 +
 +\\ 
 +=====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.\\
  
 \\  \\ 
transformations/selectdbrowsbykeys.txt · Last modified: 2021/04/08 23:49 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki