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; } } }

Object subtypes

Michael_Fennell

Hi Can anyone help me with the following.I was wondering if anyone knew how to list the object subtypes by name as opposed to just the sybtype number ?regardsMike.

Find more posts tagged with

Comments

komments

Message from Greg Kellogg <gkellogg@opentext.com> via eLink

eLink

Run a sysreport – that is the easiest way.

GregKellogg

(361) 815-8950

From: eLink Discussion:Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, January 17, 2011 9:11 AM
To: eLink Recipient
Subject: Object subtypes

Object subtypes

Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/01/17 10:06

Hi
Can anyone help me with the following.
I was wondering if anyone knew how to list the object subtypes by name as opposed to just the sybtype number ?

regards
Mike.

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Jean-Philippe_Martin

Message from <Martin.Jean-Philippe@hydro.qc.ca> via eLink

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

I go to this page to have a list of all Livelink subtypes:

http://www.greggriffiths.org/livelink/reference/subtypes/

De : eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Envoyé : lundi 17 janvier 2011 10:11
À : eLink Recipient
Objet : Object subtypes

Object subtypes Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/01/17 10:06

Hi
Can anyone help me with the following.
I was wondering if anyone knew how to list the object subtypes by name as opposed to just the sybtype number ?

regards
Mike.

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

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

Hi Michael,

I read into your question that you want to output the meaningful names of these subtypes in your LiveReport.

First, I too would get the list of actual subtypes on your own system from a sysreport.

Your mix of optional modules and customisations will affect the subtypes that are in use.

There is a risk that a subtype does not have an accurate and meaningful name, depending upon the origin of that module/customisation.

After that, you can change your Livereport so that the name is output instead of (or as well as) the subtype.

In Oracle I would use DECODE to do this.

select decode(subtype

, 0,'Folder'

, 1,'Alias'

, 144,'Document') SubTypeName, <additional columns>

from DTree where.....

In SQL Server I would use a CASE statement.

select case subtype

when 0 then 'Folder'

when 144 then 'Document'

else 'Unknown'

end

from dtree where.....

Good luck

Lindsay

European Escalation Team

Open Text UK

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 January 17, Mon 15:11
To: eLink Recipient
Subject: Object subtypes

Object subtypes

Posted by michael.fennell@fsa.gov.uk (Fennell, Michael) on 2011/01/17 10:06

Hi
Can anyone help me with the following.
I was wondering if anyone knew how to list the object subtypes by name as opposed to just the sybtype number ?

regards
Mike.

Michael_Fennell

Hi LindsayThanks for your reply that is exactly what i wanted to know, basically i did not know if there were friendly type names stored within the system for object types, so it appears from your answer that the answer is no, this is fine and i will use your suggestion which works just as well, i already have a list of subtypes and their corrosponding friendly names.RegardsMike.