AW: How to save huge qual string in Table / Tree Property? RESOLVED
All, BMC has created a new defect ref for this issue. SW00324113 Kind Regards Conny Von: Martin, Conny Gesendet: Freitag, 13. Februar 2009 16:06 An: 'arslist@ARSLIST.ORG' Betreff: AW: How to save huge qual string in Table / Tree Property? RESOLVED Howard, I reported this to BMC. I'm waiting for response. I'll let you know the result. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Charles Baldi Gesendet: Freitag, 13. Februar 2009 16:04 An: arslist@ARSLIST.ORG Betreff: Re: How to save huge qual string in Table / Tree Property? RESOLVED ** Howard, As others on the thread have said, the 4k limit appears to be a database one. The 2k limit is a bug. Chuck On Fri, Feb 13, 2009 at 9:53 AM, Howard Richter wrote: ** Chuck, Great news, bowever, is the size limit a bug with that patch or a new feature going forward? Howard On Fri, Feb 13, 2009 at 9:45 AM, Charles Baldi wrote: ** All, I was able to update the table query in question. Here is what I did: 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows creation of qualification strings up to 4k (4096 chars). 2. Since the OOB qual was already at 4081 chars, I could barely add the EXTERNAL() before running out of room. So I took the OOB qual and removed a pile of the superfluous spaces that the Admin tool adds to the qual, such as those around the "=", etc. This got the OOB qual down to 3727 chars. 3. Because I'm adding a half-dozen custom fields to the qual, the addition would still put it over the 4k limit, so I added another "AND EXTERNAL(custom_do_field)" and loaded my addition on Window Open. (thanks Scott and others). The real trick was to remove the extra spaces to make room. It is important to save a copy of the "compressed" qual for later because if you ever modify the table field, like to add a column, the Admin tool will barf again because it will have expanded the qual with the extra spaces again so that it exceeds the 4k limit. Saving a copy avoids having to remove all the spaces again. Thanks again, Chuck Baldi On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi wrote: Thanks for all the suggestions. I will see what I can get to work. FYI my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. I will let you all know the result. Regards, Chuck Baldi On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black wrote: However, you should also be warned that in at least a previous version (v5 or was it v6 era) there was a practical limit to the length of these qualifications. I was never clear if it was a RDBMS limitation or an ARS limitation, but I remember a number like 4000 characters as an upper limit to what actually works. Which was true even if you used the EXTERNAL() operator. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (BRSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari wrote: > ** > > Chuck, > > > > I would follow these steps > > 1) Create a hidden display only character field on the > form. Just be sure the DB size of the field is 0 to hold the qualification > if it ever grows.
AW: How to save huge qual string in Table / Tree Property? RESOLVED
Howard, I reported this to BMC. I'm waiting for response. I'll let you know the result. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Charles Baldi Gesendet: Freitag, 13. Februar 2009 16:04 An: arslist@ARSLIST.ORG Betreff: Re: How to save huge qual string in Table / Tree Property? RESOLVED ** Howard, As others on the thread have said, the 4k limit appears to be a database one. The 2k limit is a bug. Chuck On Fri, Feb 13, 2009 at 9:53 AM, Howard Richter wrote: ** Chuck, Great news, bowever, is the size limit a bug with that patch or a new feature going forward? Howard On Fri, Feb 13, 2009 at 9:45 AM, Charles Baldi wrote: ** All, I was able to update the table query in question. Here is what I did: 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows creation of qualification strings up to 4k (4096 chars). 2. Since the OOB qual was already at 4081 chars, I could barely add the EXTERNAL() before running out of room. So I took the OOB qual and removed a pile of the superfluous spaces that the Admin tool adds to the qual, such as those around the "=", etc. This got the OOB qual down to 3727 chars. 3. Because I'm adding a half-dozen custom fields to the qual, the addition would still put it over the 4k limit, so I added another "AND EXTERNAL(custom_do_field)" and loaded my addition on Window Open. (thanks Scott and others). The real trick was to remove the extra spaces to make room. It is important to save a copy of the "compressed" qual for later because if you ever modify the table field, like to add a column, the Admin tool will barf again because it will have expanded the qual with the extra spaces again so that it exceeds the 4k limit. Saving a copy avoids having to remove all the spaces again. Thanks again, Chuck Baldi On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi wrote: Thanks for all the suggestions. I will see what I can get to work. FYI my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. I will let you all know the result. Regards, Chuck Baldi On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black wrote: However, you should also be warned that in at least a previous version (v5 or was it v6 era) there was a practical limit to the length of these qualifications. I was never clear if it was a RDBMS limitation or an ARS limitation, but I remember a number like 4000 characters as an upper limit to what actually works. Which was true even if you used the EXTERNAL() operator. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (BRSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari wrote: > ** > > Chuck, > > > > I would follow these steps > > 1) Create a hidden display only character field on the > form. Just be sure the DB size of the field is 0 to hold the qualification > if it ever grows. > > 2) Update the table field so the qualification is > EXTERNAL($Display Only Field$) > > 3) Have an Active Link set the displa
Re: How to save huge qual string in Table / Tree Property? RESOLVED
Howard, As others on the thread have said, the 4k limit appears to be a database one. The 2k limit is a bug. Chuck On Fri, Feb 13, 2009 at 9:53 AM, Howard Richter wrote: > ** Chuck, > > Great news, bowever, is the size limit a bug with that patch or a new > feature going forward? > > Howard > > On Fri, Feb 13, 2009 at 9:45 AM, Charles Baldi wrote: > >> ** >> All, >> I was able to update the table query in question. Here is what I did: >> >> 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows >> creation of qualification strings up to 4k (4096 chars). >> >> 2. Since the OOB qual was already at 4081 chars, I could barely add the >> EXTERNAL() before running out of room. So I took the OOB qual and removed a >> pile of the superfluous spaces that the Admin tool adds to the qual, such as >> those around the "=", etc. This got the OOB qual down to 3727 chars. >> >> 3. Because I'm adding a half-dozen custom fields to the qual, the >> addition would still put it over the 4k limit, so I added another "AND >> EXTERNAL(custom_do_field)" and loaded my addition on Window Open. (thanks >> Scott and others). >> >> The real trick was to remove the extra spaces to make room. It is >> important to save a copy of the "compressed" qual for later because if you >> ever modify the table field, like to add a column, the Admin tool will barf >> again because it will have expanded the qual with the extra spaces again so >> that it exceeds the 4k limit. Saving a copy avoids having to remove all the >> spaces again. >> >> Thanks again, >> Chuck Baldi >> >> >> >> On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi >> wrote: >> >>> Thanks for all the suggestions. I will see what I can get to work. FYI >>> my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. >>> >>> I will let you all know the result. >>> >>> Regards, >>> Chuck Baldi >>> >>> On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black < >>> black@gmail.com> wrote: >>> >>>> However, you should also be warned that in at least a previous version >>>> (v5 or was it v6 era) there was a practical limit to the length of >>>> these qualifications. I was never clear if it was a RDBMS limitation >>>> or an ARS limitation, but I remember a number like 4000 characters as >>>> an upper limit to what actually works. Which was true even if you used >>>> the EXTERNAL() operator. >>>> >>>> -- >>>> Carey Matthew Black >>>> BMC Remedy AR System Skilled Professional (BRSP) >>>> ARS = Action Request System(Remedy) >>>> >>>> Love, then teach >>>> Solution = People + Process + Tools >>>> Fast, Accurate, Cheap Pick two. >>>> >>>> >>>> >>>> On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari >>>> wrote: >>>> > ** >>>> > >>>> > Chuck, >>>> > >>>> > >>>> > >>>> > I would follow these steps >>>> > >>>> > 1) Create a hidden display only character field on >>>> the >>>> > form. Just be sure the DB size of the field is 0 to hold the >>>> qualification >>>> > if it ever grows. >>>> > >>>> > 2) Update the table field so the qualification is >>>> > EXTERNAL($Display Only Field$) >>>> > >>>> > 3) Have an Active Link set the display only field on >>>> Window >>>> > Open or Display or Loaded (Whichever works for you) >>>> > >>>> > 4) Have the next action perform a Change Fields that >>>> > refreshes the table. >>>> > >>>> > >>>> > >>>> > Hope that helps. >>>> > >>>> > >>>> > >>>> > Scott Illari >>>> > >>>> > 908-601-8948 >>>> > >>>> > http://www.linkedin.com/in/scottillari >>>> > >>>> > >>>> > >>>> > From: Action Request System discussion list(ARSList) >>>> > [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi >>>> > Sent: Wednesday, February 11, 2009 5:30 PM >>>> > To: arslist@ARSLIST.ORG >>&g
Re: How to save huge qual string in Table / Tree Property? RESOLVED
Chuck, Great news, bowever, is the size limit a bug with that patch or a new feature going forward? Howard On Fri, Feb 13, 2009 at 9:45 AM, Charles Baldi wrote: > ** All, > I was able to update the table query in question. Here is what I did: > > 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows > creation of qualification strings up to 4k (4096 chars). > > 2. Since the OOB qual was already at 4081 chars, I could barely add the > EXTERNAL() before running out of room. So I took the OOB qual and removed a > pile of the superfluous spaces that the Admin tool adds to the qual, such as > those around the "=", etc. This got the OOB qual down to 3727 chars. > > 3. Because I'm adding a half-dozen custom fields to the qual, the addition > would still put it over the 4k limit, so I added another "AND > EXTERNAL(custom_do_field)" and loaded my addition on Window Open. (thanks > Scott and others). > > The real trick was to remove the extra spaces to make room. It is > important to save a copy of the "compressed" qual for later because if you > ever modify the table field, like to add a column, the Admin tool will barf > again because it will have expanded the qual with the extra spaces again so > that it exceeds the 4k limit. Saving a copy avoids having to remove all the > spaces again. > > Thanks again, > Chuck Baldi > > > > On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi wrote: > >> Thanks for all the suggestions. I will see what I can get to work. FYI >> my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. >> >> I will let you all know the result. >> >> Regards, >> Chuck Baldi >> >> On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black < >> black@gmail.com> wrote: >> >>> However, you should also be warned that in at least a previous version >>> (v5 or was it v6 era) there was a practical limit to the length of >>> these qualifications. I was never clear if it was a RDBMS limitation >>> or an ARS limitation, but I remember a number like 4000 characters as >>> an upper limit to what actually works. Which was true even if you used >>> the EXTERNAL() operator. >>> >>> -- >>> Carey Matthew Black >>> BMC Remedy AR System Skilled Professional (BRSP) >>> ARS = Action Request System(Remedy) >>> >>> Love, then teach >>> Solution = People + Process + Tools >>> Fast, Accurate, Cheap Pick two. >>> >>> >>> >>> On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari >>> wrote: >>> > ** >>> > >>> > Chuck, >>> > >>> > >>> > >>> > I would follow these steps >>> > >>> > 1) Create a hidden display only character field on the >>> > form. Just be sure the DB size of the field is 0 to hold the >>> qualification >>> > if it ever grows. >>> > >>> > 2) Update the table field so the qualification is >>> > EXTERNAL($Display Only Field$) >>> > >>> > 3) Have an Active Link set the display only field on >>> Window >>> > Open or Display or Loaded (Whichever works for you) >>> > >>> > 4) Have the next action perform a Change Fields that >>> > refreshes the table. >>> > >>> > >>> > >>> > Hope that helps. >>> > >>> > >>> > >>> > Scott Illari >>> > >>> > 908-601-8948 >>> > >>> > http://www.linkedin.com/in/scottillari >>> > >>> > >>> > >>> > From: Action Request System discussion list(ARSList) >>> > [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi >>> > Sent: Wednesday, February 11, 2009 5:30 PM >>> > To: arslist@ARSLIST.ORG >>> > Subject: How to save huge qual string in Table / Tree Property? >>> > >>> > >>> > >>> > ** >>> > >>> > Hello all, >>> > >>> > >>> > >>> > I am trying to update the Table / Tree Property on the HPD:Incident >>> Assoc >>> > Search form to let users search for some of their custom fields. >>> However, >>> > the Qualification string is so large that the Admin tool will not let >>> me add >>> > to it. I can't even re-paste the original qualification back into the >>> field >>> > if I remove it. So, BMC must have a trick for pasting a HUGE >>> qualification >>> > string here. >>> > >>> > >>> > >>> > Does anyone know how to do this? >>> > >>> > >>> > >>> > ARS 7.1 p5 >>> > ITSM 7.0.03 p8 >>> > >>> > >>> > >>> > Thanks in advance, >>> > >>> > Chuck Baldi >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >>> >> >> > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How to save huge qual string in Table / Tree Property? RESOLVED
All, I was able to update the table query in question. Here is what I did: 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows creation of qualification strings up to 4k (4096 chars). 2. Since the OOB qual was already at 4081 chars, I could barely add the EXTERNAL() before running out of room. So I took the OOB qual and removed a pile of the superfluous spaces that the Admin tool adds to the qual, such as those around the "=", etc. This got the OOB qual down to 3727 chars. 3. Because I'm adding a half-dozen custom fields to the qual, the addition would still put it over the 4k limit, so I added another "AND EXTERNAL(custom_do_field)" and loaded my addition on Window Open. (thanks Scott and others). The real trick was to remove the extra spaces to make room. It is important to save a copy of the "compressed" qual for later because if you ever modify the table field, like to add a column, the Admin tool will barf again because it will have expanded the qual with the extra spaces again so that it exceeds the 4k limit. Saving a copy avoids having to remove all the spaces again. Thanks again, Chuck Baldi On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi wrote: > Thanks for all the suggestions. I will see what I can get to work. FYI my > Admin tool is at 7.1p4 while the ARServer is at 7.1p5. > > I will let you all know the result. > > Regards, > Chuck Baldi > > On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black < > black@gmail.com> wrote: > >> However, you should also be warned that in at least a previous version >> (v5 or was it v6 era) there was a practical limit to the length of >> these qualifications. I was never clear if it was a RDBMS limitation >> or an ARS limitation, but I remember a number like 4000 characters as >> an upper limit to what actually works. Which was true even if you used >> the EXTERNAL() operator. >> >> -- >> Carey Matthew Black >> BMC Remedy AR System Skilled Professional (BRSP) >> ARS = Action Request System(Remedy) >> >> Love, then teach >> Solution = People + Process + Tools >> Fast, Accurate, Cheap Pick two. >> >> >> >> On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari >> wrote: >> > ** >> > >> > Chuck, >> > >> > >> > >> > I would follow these steps >> > >> > 1) Create a hidden display only character field on the >> > form. Just be sure the DB size of the field is 0 to hold the >> qualification >> > if it ever grows. >> > >> > 2) Update the table field so the qualification is >> > EXTERNAL($Display Only Field$) >> > >> > 3) Have an Active Link set the display only field on >> Window >> > Open or Display or Loaded (Whichever works for you) >> > >> > 4) Have the next action perform a Change Fields that >> > refreshes the table. >> > >> > >> > >> > Hope that helps. >> > >> > >> > >> > Scott Illari >> > >> > 908-601-8948 >> > >> > http://www.linkedin.com/in/scottillari >> > >> > >> > >> > From: Action Request System discussion list(ARSList) >> > [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi >> > Sent: Wednesday, February 11, 2009 5:30 PM >> > To: arslist@ARSLIST.ORG >> > Subject: How to save huge qual string in Table / Tree Property? >> > >> > >> > >> > ** >> > >> > Hello all, >> > >> > >> > >> > I am trying to update the Table / Tree Property on the HPD:Incident >> Assoc >> > Search form to let users search for some of their custom fields. >> However, >> > the Qualification string is so large that the Admin tool will not let me >> add >> > to it. I can't even re-paste the original qualification back into the >> field >> > if I remove it. So, BMC must have a trick for pasting a HUGE >> qualification >> > string here. >> > >> > >> > >> > Does anyone know how to do this? >> > >> > >> > >> > ARS 7.1 p5 >> > ITSM 7.0.03 p8 >> > >> > >> > >> > Thanks in advance, >> > >> > Chuck Baldi >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How to save huge qual string in Table / Tree Property?
Thanks for all the suggestions. I will see what I can get to work. FYI my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. I will let you all know the result. Regards, Chuck Baldi On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black wrote: > However, you should also be warned that in at least a previous version > (v5 or was it v6 era) there was a practical limit to the length of > these qualifications. I was never clear if it was a RDBMS limitation > or an ARS limitation, but I remember a number like 4000 characters as > an upper limit to what actually works. Which was true even if you used > the EXTERNAL() operator. > > -- > Carey Matthew Black > BMC Remedy AR System Skilled Professional (BRSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > > > On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari > wrote: > > ** > > > > Chuck, > > > > > > > > I would follow these steps > > > > 1) Create a hidden display only character field on the > > form. Just be sure the DB size of the field is 0 to hold the > qualification > > if it ever grows. > > > > 2) Update the table field so the qualification is > > EXTERNAL($Display Only Field$) > > > > 3) Have an Active Link set the display only field on > Window > > Open or Display or Loaded (Whichever works for you) > > > > 4) Have the next action perform a Change Fields that > > refreshes the table. > > > > > > > > Hope that helps. > > > > > > > > Scott Illari > > > > 908-601-8948 > > > > http://www.linkedin.com/in/scottillari > > > > > > > > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi > > Sent: Wednesday, February 11, 2009 5:30 PM > > To: arslist@ARSLIST.ORG > > Subject: How to save huge qual string in Table / Tree Property? > > > > > > > > ** > > > > Hello all, > > > > > > > > I am trying to update the Table / Tree Property on the HPD:Incident Assoc > > Search form to let users search for some of their custom fields. > However, > > the Qualification string is so large that the Admin tool will not let me > add > > to it. I can't even re-paste the original qualification back into the > field > > if I remove it. So, BMC must have a trick for pasting a HUGE > qualification > > string here. > > > > > > > > Does anyone know how to do this? > > > > > > > > ARS 7.1 p5 > > ITSM 7.0.03 p8 > > > > > > > > Thanks in advance, > > > > Chuck Baldi > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How to save huge qual string in Table / Tree Property?
However, you should also be warned that in at least a previous version (v5 or was it v6 era) there was a practical limit to the length of these qualifications. I was never clear if it was a RDBMS limitation or an ARS limitation, but I remember a number like 4000 characters as an upper limit to what actually works. Which was true even if you used the EXTERNAL() operator. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (BRSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari wrote: > ** > > Chuck, > > > > I would follow these steps > > 1) Create a hidden display only character field on the > form. Just be sure the DB size of the field is 0 to hold the qualification > if it ever grows. > > 2) Update the table field so the qualification is > EXTERNAL($Display Only Field$) > > 3) Have an Active Link set the display only field on Window > Open or Display or Loaded (Whichever works for you) > > 4) Have the next action perform a Change Fields that > refreshes the table. > > > > Hope that helps. > > > > Scott Illari > > 908-601-8948 > > http://www.linkedin.com/in/scottillari > > > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi > Sent: Wednesday, February 11, 2009 5:30 PM > To: arslist@ARSLIST.ORG > Subject: How to save huge qual string in Table / Tree Property? > > > > ** > > Hello all, > > > > I am trying to update the Table / Tree Property on the HPD:Incident Assoc > Search form to let users search for some of their custom fields. However, > the Qualification string is so large that the Admin tool will not let me add > to it. I can't even re-paste the original qualification back into the field > if I remove it. So, BMC must have a trick for pasting a HUGE qualification > string here. > > > > Does anyone know how to do this? > > > > ARS 7.1 p5 > ITSM 7.0.03 p8 > > > > Thanks in advance, > > Chuck Baldi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How to save huge qual string in Table / Tree Property?
One trick that used to work was to replace the field names in the qualification with field IDs. The shorter qualification saved and when viewed again the field ids were replaced with field names. > Hello all, > > I am trying to update the Table / Tree Property on the HPD:Incident Assoc > Search form to let users search for some of their custom fields. However, > the Qualification string is so large that the Admin tool will not let me > add > to it. I can't even re-paste the original qualification back into the > field > if I remove it. So, BMC must have a trick for pasting a HUGE > qualification > string here. > > Does anyone know how to do this? > > ARS 7.1 p5 > ITSM 7.0.03 p8 > > Thanks in advance, > Chuck Baldi > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
AW: How to save huge qual string in Table / Tree Property?
Hi Chuck, this seems to be a bug in the Admin Tool. We had the same problem, but with Admin Tool 7.1p3 you can put long qualification strings (>2000 bytes) into the field. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Charles Baldi Gesendet: Mittwoch, 11. Februar 2009 23:30 An: arslist@ARSLIST.ORG Betreff: How to save huge qual string in Table / Tree Property? ** Hello all, I am trying to update the Table / Tree Property on the HPD:Incident Assoc Search form to let users search for some of their custom fields. However, the Qualification string is so large that the Admin tool will not let me add to it. I can't even re-paste the original qualification back into the field if I remove it. So, BMC must have a trick for pasting a HUGE qualification string here. Does anyone know how to do this? ARS 7.1 p5 ITSM 7.0.03 p8 Thanks in advance, Chuck Baldi __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How to save huge qual string in Table / Tree Property?
** As a side you may want to have your qual include $do field$ != $NULL$ to prevent an unqualified search on the table since that will not be immediately set. Hth, Eric From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: Wed Feb 11 18:45:18 2009 Subject: Re: How to save huge qual string in Table / Tree Property? Chuck, I would follow these steps 1) Create a hidden display only character field on the form. Just be sure the DB size of the field is 0 to hold the qualification if it ever grows. 2) Update the table field so the qualification is EXTERNAL($Display Only Field$) 3) Have an Active Link set the display only field on Window Open or Display or Loaded (Whichever works for you) 4) Have the next action perform a Change Fields that refreshes the table. Hope that helps. Scott Illari 908-601-8948 http://www.linkedin.com/in/scottillari <http://www.linkedin.com/in/scottillari> From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi Sent: Wednesday, February 11, 2009 5:30 PM To: arslist@ARSLIST.ORG Subject: How to save huge qual string in Table / Tree Property? ** Hello all, I am trying to update the Table / Tree Property on the HPD:Incident Assoc Search form to let users search for some of their custom fields. However, the Qualification string is so large that the Admin tool will not let me add to it. I can't even re-paste the original qualification back into the field if I remove it. So, BMC must have a trick for pasting a HUGE qualification string here. Does anyone know how to do this? ARS 7.1 p5 ITSM 7.0.03 p8 Thanks in advance, Chuck Baldi __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
Re: How to save huge qual string in Table / Tree Property?
Chuck, I'd suggest taking an xml def of that table and edit the qualification in the def file but it might be kind of tedious. And then import that definition file. Just curious but is the version of the Admin tool and the Server the same? If not it might be the logic in the Admin tool that is preventing the update. Joe From: Charles Baldi To: arslist@ARSLIST.ORG Sent: Wednesday, February 11, 2009 5:30:21 PM Subject: How to save huge qual string in Table / Tree Property? ** Hello all, I am trying to update the Table / Tree Property on the HPD:Incident Assoc Search form to let users search for some of their custom fields. However, the Qualification string is so large that the Admin tool will not let me add to it. I can't even re-paste the original qualification back into the field if I remove it. So, BMC must have a trick for pasting a HUGE qualification string here. Does anyone know how to do this? ARS 7.1 p5 ITSM 7.0.03 p8 Thanks in advance, Chuck Baldi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: How to save huge qual string in Table / Tree Property?
Chuck, I would follow these steps 1) Create a hidden display only character field on the form. Just be sure the DB size of the field is 0 to hold the qualification if it ever grows. 2) Update the table field so the qualification is EXTERNAL($Display Only Field$) 3) Have an Active Link set the display only field on Window Open or Display or Loaded (Whichever works for you) 4) Have the next action perform a Change Fields that refreshes the table. Hope that helps. Scott Illari 908-601-8948 <http://www.linkedin.com/in/scottillari> http://www.linkedin.com/in/scottillari From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi Sent: Wednesday, February 11, 2009 5:30 PM To: arslist@ARSLIST.ORG Subject: How to save huge qual string in Table / Tree Property? ** Hello all, I am trying to update the Table / Tree Property on the HPD:Incident Assoc Search form to let users search for some of their custom fields. However, the Qualification string is so large that the Admin tool will not let me add to it. I can't even re-paste the original qualification back into the field if I remove it. So, BMC must have a trick for pasting a HUGE qualification string here. Does anyone know how to do this? ARS 7.1 p5 ITSM 7.0.03 p8 Thanks in advance, Chuck Baldi __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
How to save huge qual string in Table / Tree Property?
Hello all, I am trying to update the Table / Tree Property on the HPD:Incident Assoc Search form to let users search for some of their custom fields. However, the Qualification string is so large that the Admin tool will not let me add to it. I can't even re-paste the original qualification back into the field if I remove it. So, BMC must have a trick for pasting a HUGE qualification string here. Does anyone know how to do this? ARS 7.1 p5 ITSM 7.0.03 p8 Thanks in advance, Chuck Baldi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
