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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about labels
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 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ 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/ http://www.softwaretoolhouse.com/ _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Alberto Mel. Sent: May 12, 2010 9:27 AM To: arslist@ARSLIST.ORG 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about labels
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 ben.cher...@softwaretoolhouse.com ** 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 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com 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: arsl...@arslist.org] *On Behalf Of *Alberto Mel. *Sent:* May 12, 2010 9:27 AM *To:* arslist@ARSLIST.ORG *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
Re: Question about labels
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. alberto.rem...@gmail.com 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 ben.cher...@softwaretoolhouse.com ** 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 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com 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: arsl...@arslist.org] *On Behalf Of *Alberto Mel. *Sent:* May 12, 2010 9:27 AM *To:* arslist@ARSLIST.ORG *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
Re: Question about labels
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. alberto.rem...@gmail.com 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 ben.cher...@softwaretoolhouse.com ** 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 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com 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: arsl...@arslist.org] *On Behalf Of *Alberto Mel. *Sent:* May 12, 2010 9:27 AM *To:* arslist@ARSLIST.ORG *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