From cd99aece8f3f32303ece5f78e732046a36fabf97 Mon Sep 17 00:00:00 2001 From: kspurgin Date: Fri, 11 Nov 2022 10:06:52 -0500 Subject: [PATCH] fix query in object_valuation report (#304) --- .../src/main/resources/object_valuation.jrxml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/object_valuation.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/object_valuation.jrxml index b15ff66f3..df2d25c2b 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/object_valuation.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/object_valuation.jrxml @@ -68,7 +68,7 @@ inner join valueamounts va on avh.id = va.id order by objects.objcsid, coalesce(vc.valuedate, core.createdat) DESC ) -SELECT objects.objnum, ot.title, ong.objname, +SELECT objects.objnum, ot.title, ong.objname, bd.item AS briefdesc, olv.valuationcontrolrefnumber AS valuationid, olv.valuedate, olv.valuetype, olv.rel_objs, olv.valueamount, CASE @@ -78,7 +78,7 @@ CASE FROM objects LEFT OUTER JOIN obj_titles ot ON ot.objnum = objects.objnum LEFT OUTER JOIN obj_names ong ON ong.objnum = objects.objnum -INNER JOIN collectionobjects_common_briefdescriptions bd ON bd.id = objects.objid AND bd.pos = 0 +LEFT OUTER JOIN collectionobjects_common_briefdescriptions bd ON bd.id = objects.objid AND bd.pos = 0 LEFT OUTER JOIN obj_latest_val olv ON olv.objcsid = objects.objcsid]]> -- 2.47.3