All public logs

Combined display of all available logs of KeystoneIntranet. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 15:34, 27 March 2024 Chanson talk contribs created page QueryGen Case: Add missing item to all Jobs (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_...")