Hi,
I have scenario where I have loaded 2 cateogry attributes data in a temporary table and then I run a query which looks into that temporary table and generate results accordingly.
select
'https://myll/livelink/livelink.exe/open/' ||dt.dataid "DATA ID", la2.valstr||la3.valstr "Document Number"
from dtree dt, llattrdata la2, llattrdata la3
where
dt.parentid!=2067
and
(la2.valstr||la3.valstr) in
(select col1 from hr.temp1 where col1 is not null)
and
(
dt.dataid = la2.id
and la2.defid=1234
and la2.attrid=3
and la2.vernum= (select max(vernum) from llattrdata where id = dt.dataid )
)
and
(
dt.dataid = la3.id
and la3.defid=1234
and la3.attrid=4
and la3.vernum= (select max(vernum) from llattrdata where id = dt.dataid )
)
order by 2,1;
That is working perfect but now another scenario came in that if the latest version name is starting with "XYZ" then it should generate link LATEST VERSION - 1 i.e. 1 version before the latest one.
anyone can help in that?
regards,
Baber.
