Would you be a little more specific as to what you mean by saying 'flip my
Request_ID' ?

I have so far understood you need to change the prefix. That can be done
with a Direct SQL to the database table field_dispprop to change the default
for that schemaid.

Joe
  -----Original Message-----
  From: Action Request System discussion list(ARSList)
[mailto:[email protected]]on Behalf Of Remedy Maniac
  Sent: Tuesday, December 23, 2008 9:20 AM
  To: [email protected]
  Subject: Re: AW: how to use Application-Format-Qual-ID


  ** Joe,

  many thanks for your tips.
  However, I still do not see how to built something to flip my Request_ID
  I created 2 triggers to update my T and H tables on insert.
  I noticed the API was somehow building the ID but nothing got inserted.
  So I am wondering whether now I need to combine my triggers with the
arsignal or do I need something else?
  I don't really see how I should use the arsignal. I am not refering to the
syntax.
  Could you help more please?
  Thank you
  Serouche

  PS: and I am on ARS 6.01



  Joe D'Souza wrote:
    **
    Serouche,

    Use it in an Escalation in a Run Process if the change to the default
prefix is at a definite interval after changing the prefix using a Direct
SQL

    Syntax:
    /install/path/of/your/application/bin/arsignal -g <hostname>:<port
number if applicable>

    If the change in prefix happens on an event rather than a interval, try
creating a form and set an entry to it on that event that triggers the
above..

    Cheers

    Joe
      -----Original Message-----
      From: Action Request System discussion list(ARSList)
[mailto:[email protected]]on Behalf Of Remedy Maniac
      Sent: Tuesday, December 23, 2008 9:02 AM
      To: [email protected]
      Subject: Re: AW: how to use Application-Format-Qual-ID


      ** Thank you Joe,

      This seems to be fine. Tickets in that schema are not created that
often.
      But I don't really see how I could use the arsignal in my flow ...
      could you tell me more please?
      Thank you
      serouche


      Joe D'Souza wrote:
        **
        What exactly do you want your Request Id to be?

        The Run Process you thought might help as Martin pointed out is to
convert internal meta data that represents run if qualification into what
you see in the Admin too and vice versa.

        Dynamically changing prefixes of Request ID's can be done provided
you recache the definition immediately after triggering the change in the
default value of the prefix. You can do this using the arsignal command with
the -g switch.

        Having to recache the definitions obviously mean you cannot do it
too often (like every 5 minutes) because it would hammer your performance..

        Cheers

        Joe
          -----Original Message-----
          From: Action Request System discussion list(ARSList)
[mailto:[email protected]]on Behalf Of Remedy Maniac
          Sent: Tuesday, December 23, 2008 8:15 AM
          To: [email protected]
          Subject: Re: AW: how to use Application-Format-Qual-ID


          ** I just tried your idea. I get the following:
          Next available ID produces an Entry ID that overflows Entry ID
field --
          contact the Administrator (ARERR 305)
          This is probably because we already have 8000 rows in the form.
          The idea is to have every year <some string>YEAR0001, <some
string>YEAR0002,<some string>YEAR0003,<some string>YEAR0004, ...
          So right now what I do is every year after the first ticket is
created I export the row in a arx format. I manually make the change. Then
import with the import tool.
          And this way the next id gets the right format. And we are safe
for the rest of the year.
          But I'd like to have this self-service by Remedy itself.
          I am starting to doubt in the power of this tool. So it has at
least one limitation.



          Conny Martin wrote:
            **
            this special run process wouldn't help you.

            Documentation says: "Converts an internal representation of a
qualifier into a qualification string using ID format. "

            It deals with qualifiers not request_id formats.

            What about setting the Default-Value of the request_id field to
<some string>YEAR ? You have to adjust this every year, but it's simple.

            Kind Regards Conny



--------------------------------------------------------------------
            Von: Action Request System discussion list(ARSList)
[mailto:[email protected]] Im Auftrag von Remedy Maniac
            Gesendet: Dienstag, 23. Dezember 2008 14:00
            An: [email protected]
            Betreff: how to use Application-Format-Qual-ID


            ** Dear listers,

            some of my users would like to have a fancy Request_ID in the
following format:
            <some string>YEAR<Id number in 4 digits>
            After many unsuccesfull attempts, I believe the Process
Application-Format-Qual-ID could help
            The problem is I don't get it work.
            Could somebody give a hint on how to use this Process?
            Or simpler, if anybody has a better idea, please share.
            Thanks
            Serouche
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.552 / Virus Database: 270.10.0/1861 - Release Date: 12/22/2008
11:23 AM

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to