Live Report directly from "Help" on the server has a different ID number?

I am trying to use Content Server Help (v 10.5) to write a webreport. The title of the page is "Categories and Attributes- CAT-Method 1"

The first instruction is to create a live report that says this:

select LLAttrData.ID DATAID	from		LLAttrData, DTree	where		LLAttrData.DEFID = 338223 and		LLAttrData.ATTRID = 1 and		LLAttrData.VERNUM = DTree.VERSIONNUM and		LLAttrData.ID = DTree.DATAID

Nothing happens- so I looked at sql manager and the LLAttrData table and the DEFID is listed as 46848. I replaced 338223 with 46848 and got results. Am I doing something wrong? was this a mistake or does that value change from one installation to another?

Find more posts tagged with

Comments

DO you mean from NonProd to Prod? Yes, they would change, more than likely. But if you duplicated the DB from Prod to NonProd, the values should not have changed. In either case, it always helps to review what’s actually in the DB.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, November 09, 2016 3:23 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Live Report directly from "Help" on the server has a different ID number?

Live Report directly from "Help" on the server has a different ID number?

Posted by Beyeler, Lisa On 11/09/2016 03:18 PM

I am trying to use Content Server Help (v 10.5) to write a webreport. The title of the page is "Categories and Attributes- CAT-Method 1"

The first instruction is to create a live report that says this:

select LLAttrData.ID DATAID

         from

                 LLAttrData, DTree

         where

                 LLAttrData.DEFID = 338223 and

                 LLAttrData.ATTRID = 1 and

                 LLAttrData.VERNUM = DTree.VERSIONNUM and

                 LLAttrData.ID = DTree.DATAID

Nothing happens- so I looked at sql manager and the LLAttrData table and the DEFID is listed as46848. I replaced 338223 with 46848 and got results. Am I doing something wrong? was this a mistake or does that value change from one installation to another?

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

Hello Lisa,

The DefID is the dataid of the specific category you want information on

The attrID of 1 is again the category being looked at. If you want to pick attributes they start numbering at attrID 2, 3, ..and so on

There was no specific detail about what you are looking for so hopefully knowing what those two columns have will help you

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, November 09, 2016 3:23 PM
To: eLink Recipient
Subject: Live Report directly from "Help" on the server has a different ID number?

Live Report directly from "Help" on the server has a different ID number?

Posted by Beyeler, Lisa On 11/09/2016 03:18 PM

I am trying to use Content Server Help (v 10.5) to write a webreport. The title of the page is "Categories and Attributes- CAT-Method 1"

The first instruction is to create a live report that says this:

select LLAttrData.ID DATAID

         from

                 LLAttrData, DTree

         where

                 LLAttrData.DEFID = 338223 and

                 LLAttrData.ATTRID = 1 and

                 LLAttrData.VERNUM = DTree.VERSIONNUM and

                 LLAttrData.ID = DTree.DATAID

Nothing happens- so I looked at sql manager and the LLAttrData table and the DEFID is listed as46848. I replaced 338223 with 46848 and got results. Am I doing something wrong? was this a mistake or does that value change from one installation to another?

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

Hi Lisa,

In case you weren't aware, WebReports has a data source specifically for categories. This auto-generates the SQL necessary to return nodes related to a specific category and provides some basic filtering too. Documentation is here: https://knowledge.opentext.com/knowledge/piroot/llescor/v160001/llescor-h-ugd/en/html/lleswebr-h-ugd-wr-datasource-cscategory.htm

Also, if you have the 10.5 Content Intelligence bundle, which WebReports is part of, and are licensed for the Report Pack there is a pre-built Category Manager report that covers a lot of the common requirements for category reporting in Content Server. User Guide is here: https://knowledge.opentext.com/knowledge/llisapi.dll/Open/60886257

Regards
Ian

In case you want to transport the LiveReport without the need to make changes then you have the following options:

<![if !supportLists]>1. <![endif]>Assign a nickname to the category. The SQL query has to be extended to query the NickName table and you need to filter based on the nickname. Nicknames are supported by the transport system.

<![if !supportLists]>2. <![endif]>If you have Extended ECM that you can also Unique Names instead of nicknames. The changes are similar. The transport system of xECM will take care of the different DataIDs for the category in the different systems.

<![if !supportLists]>3. <![endif]>If you are sure that there is only one category with this name then you can also find the category based on the name and subtype.

Hans

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Mittwoch, 9. November 2016 21:23
To: eLink Recipient
Subject: Live Report directly from "Help" on the server has a different ID number?

Live Report directly from "Help" on the server has a different ID number?

Posted by Beyeler, Lisa On 11/09/2016 03:18 PM

I am trying to use Content Server Help (v 10.5) to write a webreport. The title of the page is "Categories and Attributes- CAT-Method 1"

The first instruction is to create a live report that says this:

select LLAttrData.ID DATAID

        from

                 LLAttrData, DTree

        where

                 LLAttrData.DEFID = 338223 and

                 LLAttrData.ATTRID = 1 and

                 LLAttrData.VERNUM = DTree.VERSIONNUM and

                 LLAttrData.ID = DTree.DATAID

Nothing happens- so I looked at sql manager and the LLAttrData table and the DEFID is listed as46848. I replaced 338223 with 46848 and got results. Am I doing something wrong? was this a mistake or does that value change from one installation to another?

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

Attached are a pair of LRs that work together, but they’re ORACLE SQL. One lists all the Categories with a link to a SubLR that lists all the Attributes and their Data Types.

When I had to work some in SQL Server, I found my conversions online. I hope they help.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, November 09, 2016 3:23 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Live Report directly from "Help" on the server has a different ID number?

Live Report directly from "Help" on the server has a different ID number?

Posted by Beyeler, Lisa On 11/09/2016 03:18 PM

I am trying to use Content Server Help (v 10.5) to write a webreport. The title of the page is "Categories and Attributes- CAT-Method 1"

The first instruction is to create a live report that says this:

select LLAttrData.ID DATAID

         from

                 LLAttrData, DTree

         where

                 LLAttrData.DEFID = 338223 and

                 LLAttrData.ATTRID = 1 and

                 LLAttrData.VERNUM = DTree.VERSIONNUM and

                 LLAttrData.ID = DTree.DATAID

Nothing happens- so I looked at sql manager and the LLAttrData table and the DEFID is listed as46848. I replaced 338223 with 46848 and got results. Am I doing something wrong? was this a mistake or does that value change from one installation to another?

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

Cats-n-their-Atts_LiveReport.rpt