nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Livelink LLattrdata in SQL server qn

Appu_Nair

Maybe thi is a basic qn and maynot ven have the Oracle vs SQl server problems because they are all supposed be to SQL anyways.Here is what I am trying to do.screen cap document enclosed.In my example I have an objid (id in llattrdata) that is common to three different category objects(or less confusing three different category objects have been applied to the same dataid.My outer query gives me what I am after however I need to staple the two other queries together so the user like it.I am really unsure whether to union them or "join" them.So if anybody needs a steamy workout before Christmas here you go.Notice the only objects that I am after is ones that have a date attribute that I am looking for.Obviously in this test database there is only one object that I created but it should stand the test of time as well.:)

Find more posts tagged with

Comments

sıɹɥɔ

Message from Chris Webster <cwebster@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi Appu,

The best way to think about the solution is to believe there are 3 separate tables, one for each of the categories. It so happens that all the tables are actually the same one: LLATTRDATA, but your SELECT clause and conditions can all reference the particular table for each category using respective aliases. In your example you have an alias "a" for LLATTRDATA but that's presumably just to save typing and to make the expressions more consise. So you could add an "LLATTRDATA b" and an "LLATTRDATA c" to the FROM clause and then use "b" and "c" in your second and third examples for the LLATTRDATA table they each reference.

I hope I understand your issue properly, and I'm not telling you something obvious you already know. :-)

-chris

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, December 10, 2008 11:18 AM
To: eLink Recipient
Subject: Livelink LLattrdata in SQL server qn

Livelink LLattrdata in SQL server qn

Posted by appu.nair@dynegy.com (Nair, Appu) on 12/10/2008 12:15 PM

Maybe thi is a basic qn and maynot ven have the Oracle vs SQl server problems because they are all supposed be to SQL anyways.

Here is what I am trying to do.screen cap document enclosed.
In my example I have an objid (id in llattrdata) that is common to three different category objects(or less confusing three different category objects have been applied to the same dataid.My outer query gives me what I am after however I need to staple the two other queries together so the user like it.I am really unsure whether to union them or "join" them.
So if anybody needs a steamy workout before Christmas here you go.Notice the only objects that I am after is ones that have a date attribute that I am looking for.Obviously in this test database there is only one object that I created but it should stand the test of time as well.:)

Appu_Nair

Thank you Chris,John said the same thing.I am trying to piece a query that I hoped so that I don't put llattrdata for how many times I need it(the infamous view that one is supposed to create).I think I am gonna try what you said

Appu_Nair

I rewrote this as per Chris,he set me right so it looks like thisselect a.id as "objID",d.name as "name" ,b.valstr,c.valstr,case a.attrid when 20 then a.valdate end "general date",case a.attrid when 21 then a.valdate end "Auto",case a.attrid when 22 then a.valdate end "Excel",case a.attrid when 23 then a.valdate end "Workers"from intermediate.interlluser.llattrdata a,intermediate.interlluser.llattrdata b,intermediate.interlluser.llattrdata c,intermediate.interlluser.dtree dwhere a.id=d.dataid and d.subtype=31067 and a.id=95072 and a.defid=95088 and a.defvern=11 and a.valdate <= '2008-12-19 00:00:00.000'and b.defid=49886 and b.defvern=5 and b.attrid=17 and b.id=a.idand c.defid=49889 and c.defvern=24 and c.attrid=58 and c.id=a.idThanks Chris

Claudia_Meyer

Message from Christopher Meyer <cmeyer@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi Appu,

I've written a small EasyLAPI class for generating custom flattened views of the LLAttrData table. Attached is the class (just modify the package header for your needs). Here's an example of using it:

--------------

LLObject category = mySession.getCategoryWorkspace().getChild("MyCategory");
LLAttrData2FlattenedView fv = new LLAttrData2FlattenedView(category);

fv.add("Attribute Name 1", "MyIntField");
fv.add("Attribute Name 2", "MyStringField");
fv.add("Attribute Name 3", "displayname_nospaces3");

System.out.println(fv.getFlattenedView());

--------------

The output will be something like this:

select MyIntField.ID DATAID, MyIntField.VALINT MyIntField, MyStringField.VALSTR MyStringField from llattrdata MyIntField, llattrdata MyStringField where MyIntField.DEFID=16344 AND MyStringField.DEFID=16344 AND MyIntField.ATTRID=9 AND MyStringField.ATTRID=10 AND MyIntField.ID=MyStringField.ID AND MyIntField.VERNUM=MyStringField.VERNUM

The query will return a view with column headers: DATAID, MYINTFIELD, MYSTRINGFIELD ...

Limitations:

Only one category can be defined (but shouldn't be hard to merge two outputs together, as you need)
Sets are not supported (or just not tested yet)
Multi-Valued attributes don't work.
Version information (i.e., different attribute values on different versions of a document) are not returned
Only tested with Oracle, but it should work with MSSQL

cheers

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, December 10, 2008 20:39
To: eLink Recipient
Subject: Thanks Chris

Thanks Chris		Posted by appu.nair@dynegy.com (Nair, Appu) on 12/10/2008 02:34 PM
In reply to: Thank you Chris,John said the same thing.I am trying to piece a query that I...		Posted by appu.nair@dynegy.com (Nair, Appu) on 12/10/2008 02:10 PM

I rewrote this as per Chris,he set me right so it looks like this
select a.id as "objID",d.name as "name" ,b.valstr,c.valstr,
case a.attrid when 20 then a.valdate end "general date",
case a.attrid when 21 then a.valdate end "Auto",
case a.attrid when 22 then a.valdate end "Excel",
case a.attrid when 23 then a.valdate end "Workers"
from
intermediate.interlluser.llattrdata a,
intermediate.interlluser.llattrdata b,
intermediate.interlluser.llattrdata c,
intermediate.interlluser.dtree d
where a.id=d.dataid and d.subtype=31067 and a.id=95072
and a.defid=95088 and a.defvern=11 and a.valdate <= '2008-12-19 00:00:00.000'
and b.defid=49886 and b.defvern=5 and b.attrid=17 and b.id=a.id
and c.defid=49889 and c.defvern=24 and c.attrid=58 and c.id=a.id

Thanks Chris

Appu_Nair

Thank you Chris for this as well.The BI partners of OT ,it is probably old Hummingbird has one or two excellent UDF's .I have actually taken that and changed that into a more generic way as well.Play with the OT BI tool it is very interesting.