I have a query that concatenates data to get a bar code in a specific format. I am going back to the OnBase DB in order to concatenate a barcode in the following format *Attr00000000 ERSDR *
Here is the query
select CONCAT('*', RTRIM(rmo.attr1021), REPLICATE('0', 8 - LEN(RTRIM(rmo.attr1031))) + RTRIM(rmo.attr1031), ' ESRDRX ','*') as [RXBarcode]
from
hsi.rmObjectInstance1001 rmo
where rmo.attr1022 = '&EncounterNum'
When I run this query through SSMS it works fine and I get a result. When I try this through Document Composition and have the output as a barcode nothing is displayed on the template.
What am I doing wrong?
