Hi,
You can allways have a look at the free utility RRR|DefFieldList:
https://www.rrr.se/cgi/tools/main#rrrDefFieldList
It will give you a TXT, SKV or XLS file with the following info:
Form
Id
Name
Label
Type
Option
Length
Enum-values
Default
Pattern and Menu
As input, it takes a def-file-export of the forms you want to report on.
Best Regards - Misi, RRR AB, http://rrr.se
> Hi Ben,
>
> when I told to my collegue your explanatiom, he told me that he need the
> value of the Incident and Change impact.....so, it's in a form (SYS:Menu
> items). I misunderstood the question of my collegue.
>
> But, thank for your help!.
> Alberto
>
> 2010/5/12 Alberto Mel. <[email protected]>
>
>> Hi Ben!.
>>
>> First, thanks a lot for your answer. I realized not to take a look to
>> the
>> document "DB reference guide".
>>
>> The question is for making reports with a tool that takes the data
>> directly
>> to the Remedy Data Base. It's for a collegue, but your information is
>> very
>> useful!.
>>
>> Thank you very much again!
>>
>> Albertp
>>
>> 2010/5/12 Ben Chernys <[email protected]>
>>
>> **
>>> Of course, it must be stored in the db. Else how would the ARS server
>>> know
>>> them?
>>>
>>> Labels are view based. That is: each view can have a different label
>>> for
>>> the same field. When a form is saved, if the default view changes, the
>>> labels are subject to change. This makes queries (which accept labels
>>> and
>>> field ids - but NOT field names) ugly to read in multi-language shops.
>>> Meta-Update queries can use field ids, labels, or names.
>>>
>>> Check out the "Database Reference Guide" manual for where field labels
>>> are
>>> stored.
>>>
>>> Sorry, I don't know the view tables off the top of my head as I use the
>>> API for that type of info and I've never had to "adjust" views tables
>>> for
>>> problems I've had to fix.
>>>
>>> What is it you are trying to do?
>>>
>>> Cheers
>>>
>>> Ben Chernys
>>>
>>> Senior Software Architect
>>> Software Tool House Inc.
>>>
>>> Canada / Deutschland / Germany
>>> Mobile: +49 171 380 2329 GMT + 1 + [ DST ]
>>> Email: [email protected]
>>> Web: www.softwaretoolhouse.com
>>>
>>> Check out Software Tool House's free Diary Editor.
>>>
>>> *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 *Alberto Mel.
>>> *Sent:* May 12, 2010 9:27 AM
>>> *To:* [email protected]
>>> *Subject:* Question about labels
>>>
>>> ** Hi all!,
>>>
>>> Anybody knows if the labels of a regular form are stored in any place
>>> of
>>> the server, or on a particular table (of the Database)?.
>>>
>>> Thank you very much!.
>>>
>>> Alberto
>>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>>>
>>
>>
>
> _______________________________________________________________________________
> 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"
