Hi,
I would suspect that you will find it in the propShort or propLong field
of the field_dispprop table. The column depends on which one of
propShort/propLong is set.
You have to get the schemaId from the arschema table, and the vuiId
(fieldId) from the vui table.
After you got the correct row, you have to parse out the correct property,
and according to ar.h, this would be property 206 for the Alias Singular
Long, and 208 for the Alias Short Singular.
Good luck...
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.
> Hi listers,
>
> I'm looking at the database reference guide and I can't find where the
> view
> aliases are found in the AR System metadata. I have a form that can be
> refered to a lot of different forms. I have the form name in a field and I
> want to obtain the singular alias to show it to the user.
>
> Do you know where is this information stored?
>
> Thanks!
>
> Jose M. Huerta
> Project Manager**
>
> Movil: 661 665 088
>
> Telf.: 971 75 03 24****
>
> Fax: 971 75 07 94****
>
> <http://www.sm2baleares.es/>****
>
> SM2 Baleares S.A.
> C/Rita Levi ****
>
> Edificio SM2 Parc Bit****
>
> 07121 Palma de Mallorca****
>
> <http://es-es.facebook.com/pages/SM2-Baleares/158608627954>
> <http://twitter.com/#!/SM2Baleares>
> <http://www.linkedin.com/company/sm2-baleares>
>
> La información contenida en este mensaje de correo electrónico es
> confidencial. La misma, es enviada con la intención de que únicamente sea
> leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje
> por otras personas no está autorizado, por lo que en tal caso, le rogamos
> que nos lo comunique por la misma vía, se abstenga de realizar copias del
> mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de
> inmediato.****
>
> P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es
> necesario.
>
> _______________________________________________________________________________
> 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"
