Changeset 19488 for trunk/DataCheck

Timestamp:

04/04/19 18:12:53 (6 years ago)

Author:

Daniela Dorner

Message:

improved solution iwth joins

File:

• trunk/DataCheck/Sourcefile.sh (modified) (2 diffs)

trunk/DataCheck/Sourcefile.sh

@@ -254 +254 @@
    # add table
    query=$query" "$maintable"Status"
-   # add special join
+   # add special joins
    query=$query" "`getfromsetup $maintable "SpecialJoin"`
+   if [ "$1" = "set" ]
+   then 
+      query=$query" "`getfromsetup $maintable "SpecialJoinSet"`
+   fi
    # add join for step unless step is the same as maintable
    if ! [ "$step" = "$maintable" ]
@@ -275 +279 @@
          if [ "$1" = "set" ]
          then 
-            query=$query" "`getfromsetup $otherstep "SpecialJoin2"`
+            query=$query" "`getfromsetup $otherstep "SpecialJoinSet2"`
             query=$query" LEFT JOIN "$otherstep"Status USING("`getfromsetup $otherstep "Primaries"`") "
          fi