As I said, it's in a list of number value pairs. In the following example, you will see the labels for one view (I cut off the text) of HPD:Help Desk help in a CLOB field where the label is "Incidents" See \206\4\8\Incident Below. The 206 is one of the integers I specified as a symbol. The 4 says a character value, the 8 says it's 8 bytes long, and the text "Incident" is the value.
Similarly, the name of that view (from the VUI table) is itself a property
in the field_dispprop table where the fielded is null (the display
properties for a form view) in this case \20\4\17\Default User View
Cheers
Ben
Note this was done on a 7.0.1 server but it should be the same.
SQL> describe vui
Name Null? Type
----------------------------------------- --------
----------------------------
SCHEMAID NOT NULL NUMBER(15)
VUIID NOT NULL NUMBER(15)
VUINAME NOT NULL VARCHAR2(254)
LOCALE VARCHAR2(30)
VUITYPE NUMBER(15)
TIMESTAMP NOT NULL NUMBER(15)
OWNER NOT NULL VARCHAR2(254)
LASTCHANGED NOT NULL VARCHAR2(254)
HELPTEXT CLOB
CHANGEDIARY CLOB
SQL> describe field_dispprop
Name Null? Type
----------------------------------------- --------
----------------------------
SCHEMAID NOT NULL NUMBER(15)
FIELDID NUMBER(15)
LISTINDEX NOT NULL NUMBER(15)
VUIID NUMBER(15)
PROPSHORT VARCHAR2(255)
PROPLONG CLOB
e:\Dta> SthMqry -f -q select * from vui where schemaid = (select schemaid
from arschema where name = 'HPD:Help Desk')
SthMqry ver 4.3 for ARS 7.6.04
(c) copyright 1996-2011 by Software Tool House Inc.
www.softwaretoolhouse.com
170604.195 i ArQryGet returns 7 records for select * from vui where schemaid
= (select schemaid from arschema where name = 'HPD:Help Desk')
1076,399990088,"536895968",NULL,1,1179757056,"Remedy","Demo",NULL,NULL
1076,399990106,"New5368959682",NULL,1,1179757056,"Remedy","Demo",NULL,NULL
1076,399990109,"New5368959683",NULL,1,1179757056,"Remedy","Demo",NULL,NULL
1076,399990127,"New536895968",NULL,1,1179757056,"Remedy","Demo",NULL,NULL
1076,399990128,"NewNew5368959682",NULL,1,1179757056,"Remedy","Demo",NULL,NUL
L
1076,399990154,"NewNew536895968",NULL,1,1179757056,"Remedy","Demo",NULL,NULL
1076,399990155,"NewNewNew536895968",NULL,1,1179757056,"Remedy","Demo",NULL,N
ULL
e:\Dta> SthMqry -f -q select * from field_dispprop where schemaid = (select
schemaid from arschema where name = 'HPD:Help Desk') and fieldid is null
SthMqry ver 4.3 for ARS 7.6.04
(c) copyright 1996-2011 by Software Tool House Inc.
www.softwaretoolhouse.com
170800.734 i ArQryGet returns 7 records for select * from field_dispprop
where schemaid = (select schemaid from arschema where name = 'HPD:Help
Desk') and fieldid is null
1076,NULL,0,399990088,NULL,"33\20\4\17\Default User
View\201\2\118912\202\2\68200\162\2\7\203\40\1\205\40\1\166\4\8\0xe5dfd4\206
\4\8\Incident\207\4\9\Incidents\208\4\8\Incident\209
\4\9\Incidents\210\4\0\\211\4\0\\215\40\1000000161\213\4\43\7\401\3\402\3\40
3\3\404\3\405\3\406\3\407\3\216\4\34\1000003009\3\3\255\2\40349\1\43008\169\
40\1\168\40\1\212\4\2\0\\600
19\4\21\ViewWebAlias536895968\167\9\2\21503\ffd8ffe000104a464946000101000001
00010000ffdb0043000101010101010101010101010101010101010101010101010101010101
0101010101010101010101010101
010101010101010101010101010101010101010101ffdb004301010101010101010101010101
0101010101010101010101010101010101010101010101010101010101010101010101010101
0101010101010101010101010101
ffc0001108003c03e603012200021101031101ffc4001f000001050101010101010000000000
0000000102030405060708090a0bffc400b5100002010303020403050504040000017d010203
0004110512213141061351610722
7114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738
393a434445464748494a535455565758595a636465666768696a737475767778797a83848586
8788898a92939495969798999aa2
a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3
e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000
000102030405060708090a0bffc4
00b5110002010204040304070504040001027700010203110405213106124151076171132232
8108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a3536373839
3a434445464748494a5354555657
58595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2
a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4
e5e6e7e8e9eaf2f3f4f5f6f7f8f9
faffda000c03010002110311003f00fe69ff00e14878179ff89068bcf5ff0042b5e7ebfe8bcd
1ff0a43c0bcffc48345e7aff00a15af3f5ff0045e6bd6b7bff0078fe9fe7b0fca9fe60ff006b
fcfe3ec3f2aff4ff00fd4ae1ad3f
e12e97fe09f4fbb6d3e5d8ff0032bfe22171775ce315adbfe5ed4d6dc9f7ecbd2fd2ccf22ff8
521e05e7fe241a2f3d7fd0ad79faff00a2f347fc290f02f3ff00120d179ebfe856bcfd7fd179
af5df307fb5fe7f1f61f951e60ff
006bfcfe3ec3f2a6b82786bfe85947ff00052e96dbf0b74dbb07fc443e2eff00a1be2ba5ff00
7d575b72eff77cbe4cf22ff8521e05e7fe241a2f3d7fd0ad79faff00a2f347fc290f02f3ff00
120d179ebfe856bcfd7fd179af5a
deff00de3fa7f9ec3f2a7f983fdaff003f8fb0fca97fa93c35ff0042ba5ff826db5bfcb4f976
0ff8887c5dff00437c574bfefaaeb6e5dfeef97c99e45ff0a43c0bcffc48345e7aff00a15af3
f5ff0045e68ff8521e05e7fe241a
2f3d7fd0ad79faff00a2f35eb7e637b7ebfe3ec3f2a77983fdaff3f8fb0fca8ff52786bfe857
4bff0004db6b7f969f2ec1ff00110f8bbfe86f8ae97fdf55d6dcbbfddf2f933c8bfe14878179
ff0089068bcf5ff42b5e7ebfe8bc
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Scott Philben
Sent: September-14-12 16:39
To: [email protected]
Subject: Re: Object list information?
**
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
<[email protected]> 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
<http://www.softwaretoolhouse.com/freebies/index.html> 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: <mailto:Ben.Chernys_AT_softwaretoolhouse.com>
Ben.Chernys_AT_softwaretoolhouse.com
Web: <http://www.softwaretoolhouse.com/> 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/> http://www.softwaretoolhouse.com/
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Scott Philben
Sent: September-14-12 15:41
To: [email protected]
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"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
