Re: How to obtain the 'Schema-Alias' value for any given Schema
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
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.comhttp://www.wwrug.com ARSlist: Where the Answers Are_
Re: How to obtain the 'Schema-Alias' value for any given Schema
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
