Hi, It is stored as a big ugly display-property string in the field_dprop table where the fieldId=0. You will need to parse this string stored either in the propShort or propLong field depending on the size of the total string...
It starts with the number of entries in the string followed by a number corresponding to the ar.h information Ben referred to: #define AR_DPROP_ALIAS_SINGULAR 206 #define AR_DPROP_ALIAS_PLURAL 207 #define AR_DPROP_ALIAS_SHORT_SINGULAR 208 #define AR_DPROP_ALIAS_SHORT_PLURAL 209 The second number of each element corresponds to the datatype of the property at hand, and then a set of entries for that datatype. But in this specific case you can cheat and just search for the the string \206\4\ etc. The actual part of the string could look like this: https://www.rrr.se/cgi/tools/main#rrrConfDiff \206\4\29\Product Catalog Alias Mapping\ The 29 refers to the number of characters of the alias, and remember that you need to check all of these to know that you have the alias right. Please explain why you need this, and we might be of better assistance to you. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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"_ > ** > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
