QueryGen Case: Add missing item to all Jobs: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

27 March 2024

  • curprev 15:3415:34, 27 March 2024‎ Chanson talk contribs‎ 2,101 bytes −6‎ No edit summary
  • curprev 15:3415:34, 27 March 2024‎ Chanson talk contribs‎ 2,107 bytes +2,107‎ Created page with "Sometimes you want to add an detail item to all jobs. In this case, we will add the item ENVIRO.01 (adjusted to plant) to all jobs wher it is missing. In the query below we select all jobs and identify which do NOT have a product like ENVIRO. Artjob as d1 represents the detail line that should exist if ENVIRO.XX is in the job detail. Artjob as d0 is used to find a valid plant number on a product. (you can't count on the job header). <pre> select h.session_no,h.trans_..."
Retrieved from "http://in.compucrete.com/index.php/QueryGen_Case:_Add_missing_item_to_all_Jobs"