diff --git a/s4-funcs.sh b/s4-funcs.sh index 910cf9e..2d83fea 100755 --- a/s4-funcs.sh +++ b/s4-funcs.sh @@ -3149,7 +3149,8 @@ CREATE TEMPORARY TABLE _target AS SELECT b.rowid trowid, b.id FROM "$2" b JOIN "$2_s" s - ON b.id=s.id AND s.key='owner' AND s.val=$DT_QOWNER; + ON b.id=s.id AND s.key='owner' + ${DT_QOWNER:+ AND s.val=$DT_QOWNER}; CREATE TEMPORARY TABLE _children AS SELECT a.trowid trowid, $_i, a.id, s.val ctime @@ -3211,7 +3212,7 @@ scols="$scols${scols:+, }b.$as" done #case author when '$user' then a.rowid else '---' end as ID, - if [ -z "DT_SQL" ]; then + if [ -n "$DT_SQL" ]; then echo "$DT_SQL" else cat<<-EOF