Re: Object list information?

[Scott Philben]

**

Thanks. I can see some of this information in the vui table (schemaid, vuiId, vuiName) but nothing in there leads me to the actual Alias name.

select * from vui

where schemaId = '990'

Shows me all the data for HPD:Help Desk (990) but nothing that could be construed as Alias information.

Where do I go from here?

On Sep 14, 2012, at 07:14 AM, Ben Chernys <ben.cher...@softwaretoolhouse.com> wrote:

The alias name is quite ugly to get from the database though you could certainly do it. 

 

Even through the API it is rather a convoluted algorithm to get.  Meta-Schema (bundled with Meta-Update) picks it up through the API and if you’re running ITSM, you can see the results in our ITSM 7.6.04 Form and Fields spreadsheet in our Freebies section.  The forms sheet specifies these labels.

 

The alias name depends on the locale and the view, so it is held in each VUI’s properties - which themselves are a list of integer identifiers and values. 

 

Deriving the correct VUI is not easy as well as the VUI name is itself a property and the key is the VUI id. 

 

When you get the schema info, you get a “Default VUI Name”. 

You then get data from all VUIs associated with the form.  

Finally, you look for a Name property matching the default VUI name (AR_DPROP_LABEL) and in the locale you want.  That’s the VUI you want.

In that VUI, you look for properties such as 

AR_DPROP_ALIAS_SINGULAR,                                  AR_DPROP_ALIAS_PLURAL,

AR_DPROP_ALIAS_SHORT_SINGULAR,                                 AR_DPROP_ALIAS_SHORT_PLURAL

 

Remember that these properties are a list of integers and values.  In the database they will be a sequence of characters with one or two different separators (between the property integer and value and between properties in the list and possibly some lengths.  This will be stored in a single attribute.

 

You could write an SQL proc I suppose but with Meta-Schema you can specify the locale you’re interested in and it does it through the API.

 

Cheers

Ben Chernys
Senior Software Architect

<image003.jpg>

 

Canada / Deutschland
Mobile:      +49 171 380 2329    GMT + 1 + [ DST ]
Email:       Ben.Chernys_AT_softwaretoolhouse.com
Web:         www.softwaretoolhouse.com

Check out Software Tool House's free Diary Editor and out Freebies

Section for an ITSM 7.6.04 Forms and Fields spreadsheet.

Meta-Update, our premium ARS Data tool, lets you automate
your imports, migrations, in no time at all, without programming,
without staging forms, without merge workflow. 
http://www.softwaretoolhouse.com/ 

 

 

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Philben
Sent: September-14-12 15:41
To: arslist@ARSLIST.ORG
Subject: Object list information?

 

**

 

 

In the user tool, when you open the object list and see the list of forms, you do not see the form name (in some cases) but the alias value in the Name column. So when you search on the form name (HPD:Help Desk) it does not come up. You have to scroll down to see the alias name (Incidents)

 

Where is that alias data stored in the database?

 

The arschema table does not have it.

 

Thanks.

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

**

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_