Hi,
Or if you just want to look up an ITSM-Alias, you can use this page:
http://rrr.se/cgi/alias
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* 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.
> Hi,
>
>
>
> Thanks for the info Mark.
>
>
>
> I found that if I use the PROCESS called Application-Get-Form-Alias in a
> Set Field action of a Active Link, then I can get the value that I need.
>
>
>
> Thanks.
>
>
>
> Nyall
>
>
>
> ______________________________________________________________________
> Nyall McCavitt
> Software Engineer
> CND/COE/VI/SQ
> Tel: +33 1 69 88 73 02
> Fax: +33 1 69 88 72 21
> Mobile: +33 6 64 85 96 23
>
> Please consider the environment before you print this e-mail
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Walters, Mark
> Sent: Friday, July 23, 2010 11:52 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: How to obtain the 'Schema-Alias' value for any given Schema
>
>
>
> The alias is encoded in the field_dispprop record entry for the view â
> in either the propShort or propLong column depending on the size if the
> display properties data. Unfortunately itâs not stored in its own
> field. Find the schemaid (X) and vuiid (Y) for the view youâre
> interested in and then
>
>
>
> SQL> select propshort, proplong from field_dispprop where schemaid=X and
> vuiid=Y and fielded=0
>
>
>
> And you should see something like this;
>
>
>
> 12\20\4\18\Default Admin
> View\264\6\0\60019\4\21\ViewWebAlias536870912\201\2\127012\202\2\36600\206\4\17\THIS
> IS THE ALIAS\207\4\0\\208\4\0\\209\4\0\\5026\4\0\\5027\4\0\\215\40\1\
>
>
>
> Mark
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall
> Sent: 23 July 2010 10:31
> To: arslist@ARSLIST.ORG
> Subject: How to obtain the 'Schema-Alias' value for any given Schema
>
>
>
> **
>
> Hi,
>
> I canât seem to locate the database field that contains the
> âSchema-Aliasâ value for a given schema. I know that it is stored in
> the Alias section of the View Properties of a form.
>
> I am selecting a form (schema) from a list (obtained by an SQL query on
> the arschema table) attached to a field. Once selected I would like to
> obtain the alias associated with the form.
>
> Could someone point me in the right direction please?
>
> Nyall
>
> ______________________________________________________________________
>
> Nyall McCavitt
>
> Software Engineer
>
> CND/COE/VI/SQ
>
> Tel: +33 1 69 88 73 02
>
> Fax: +33 1 69 88 72 21
>
> Mobile: +33 6 64 85 96 23
>
> Please consider the environment before you print this e-mail
>
> ____
>
>
>
> This message and any files transmitted with it are legally privileged and
> intended for the sole use of the individual(s) or entity to whom they are
> addressed. If you are not the intended recipient, please notify the sender
> by reply and delete the message and any attachments from your system. Any
> unauthorised use or disclosure of the content of this message is strictly
> prohibited and may be unlawful.
>
>
>
> Nothing in this e-mail message amounts to a contractual or legal
> commitment on the part of EUROCONTROL, unless it is confirmed by
> appropriately signed hard copy.
>
>
>
> Any views expressed in this message are those of the sender.
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> ____
> Â
> This message and any files transmitted with it are legally privileged and
> intended for the sole use of the individual(s) or entity to whom they are
> addressed. If you are not the intended recipient, please notify the sender
> by reply and delete the message and any attachments from your system. Any
> unauthorised use or disclosure of the content of this message is strictly
> prohibited and may be unlawful.
> Â
> Nothing in this e-mail message amounts to a contractual or legal
> commitment on the part of EUROCONTROL, unless it is confirmed by
> appropriately signed hard copy.
> Â
> Any views expressed in this message are those of the sender.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
