Re: Archive old data

[Shyam Attavar]

Paul,
It depends whether you want the data accessible (searchable) or not. One of 
the things we have seen being done is to export the data into ARX files and 
the associated form definitions also and archived them on tapes for 
posterity. Another thing you can certainly do is to export the underlying DB 
tables (T, H and possibly B) as is (especially if you are on Oracle) and 
archive them on to tape. Not sure if this is exactly what you are looking 
for.

HTH,
--
Shyam
- Original Message - 
From: "ARSsytem" <[EMAIL PROTECTED]>

Newsgroups: gmane.comp.crm.arsystem.general
To: 
Sent: Friday, May 30, 2008 2:31 PM
Subject: Archive old data



Hi Listers,

We are holding more than 7 years of data in our archive data forms (which
are only regular forms, not archive forms). We would like to move part of
them off line. Has anyone done that? Is there any white paper for the best
practice. Thanks!

Regards
Paul 


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

UNSUBSCRIBE

[Syed Basith (sbasith)]

 
Hi,

Can you unsubscribe me from this list.

-Syed Abdul Basith

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

St-Pierre Patrick I625ST/Levis/GVDL est absent(e).

[Patrick St-Pierre]

Je serai absent(e) à partir du  2008-05-30 de retour le 2008-06-09.



___
Le présent message est destiné uniquement aux personnes indiquées dans 
l'en-tête. Il contient des informations confidentielles qui ne peuvent être 
divulguées à des tiers sans que l'expéditeur ait préalablement accordé son 
consentement à cet égard. Si vous n'êtes pas un des destinataires concernés par 
cette communication ou une des personnes autorisées à la recevoir, veuillez en 
aviser l'expéditeur par courriel et détruire toutes les copies qui peuvent 
exister.
This message is intended solely for the individual or entity to whom it is 
addressed. It contains privileged and confidential information which is not to 
be disclosed without the sender's express consent. If you are not the intended 
recipient of this message or an authorized representative thereof, please 
notify the sender by email and then destroy this message as well as all other 
existing copies.

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

Archive old data

[ARSsytem]

Hi Listers,

We are holding more than 7 years of data in our archive data forms (which
are only regular forms, not archive forms). We would like to move part of
them off line. Has anyone done that? Is there any white paper for the best
practice. Thanks!

Regards
Paul

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

Re: Question: Active Link - Checking Table - ITSM 7

[jham36]

I think a simple solution is to check any column in the table for a
value.  If col1 = $NULL$ or col1 != $NULL$

James

On May 30, 2:00 pm, "T. Dee" <[EMAIL PROTECTED]> wrote:
> THANKS!!!
>
> On 5/30/08, Gary Opela (Corporate) <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > Tyrone, I just tested this out.
>
> > The value of a Table Field that has one or more rows is 1 or more, 
> > depending on which row you have selected. If there are rows, but you have 
> > none selected, then the value is still 0. You can ctrl-click on a selected 
> > row to make it un-selected, so a user could potentially un-select all rows 
> > in a table, even if one was already selected, which would cause a 0 to 
> > return. So, make sure that you have the property on the table field set to 
> > automatically select the first row choice when the table is loaded.
>
> > The value of a Table Field that has not yet been refreshed is $NULL$ or "" 
> > one of the two the first time you open the form. If you change the window 
> > mode and then change it back, for instance, from search to create, then the 
> > value of the un-refreshed table field is 0.
>
> > The value of a Table Field that has been refreshed, but has no rows, is 0.
>
> > Basically, make sure you are refreshing the table with WF, and have the 
> > property checked that says select initial row, then you just check to see 
> > if Table Field >= 1, if it does, then the table field has at least 1 row. 
> > If it returns 0 or $NULL$ or "", then it is empty (you can count on 0 
> > meaning empty since you have automatically select first row selection).
>
> > I think this would be the easiest thing to look at.
>
> > Thanks,
>
> > Gary Opela, Jr., RSP
>
> > Remedy Engineer
>
> > Leader Communications, Inc.
>
> >http://www.5pointleader.com
>
> >http://www.lcibest.com
>
> > Best Product, Best People, Best PriceTM
>
> > An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
> > PROTECTED] On Behalf Of T. Dee
> > Sent: Friday, May 30, 2008 8:54 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Question: Active Link - Checking Table - ITSM 7
>
> > THANKS 
>
> > I'll give these suggestions a try.
>
> > Ty
>
> > On 5/30/08, Steven Iocco <[EMAIL PROTECTED]> wrote:
> > > **
> > > What Ben mentioned is a good option.  You could also run a guide looping 
> > > on
> > > the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as
> > > mentioned below, build your workflow on that result.
> > > Steve
>
> > > 
> > > Date: Fri, 30 May 2008 09:13:32 -0400
> > > From: [EMAIL PROTECTED]
> > > Subject: Re: Question: Active Link - Checking Table - ITSM 7
> > > To: [EMAIL PROTECTED]
>
> > > **
> > > Off the top of my head, I think that you do a direct sql that would return
> > > the same results that the table would and then do a set field command 
> > > using
> > > the value of lastcount.  I think that would give you a number and you can
> > > build workflow to check if the value is greater than 0.
>
> > > Ben Cantatore
> > > Remedy Manager
> > > (914) 457-6209
>
> > > Emerging Health IT
> > > 3 Odell Plaza
> > > Yonkers, New York 10701
>
> > > >>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>>
> > > I'm trying to check to see if a table has any rows in it, but i'm not
> > > having much luck.
>
> > > I have tried to check for the table NOT being NULL and I have check
> > > for a column NOT being NULL, both do not work.
>
> > > I'm looking to see if the Relationship table is NOT NULL - so I tried:
>
> > > 'z2TH Associations' != $NULL$
> > > (this is the table name)
>
> > > I also tried:
>
> > > 'z2TF AssociationType' != $NULL$
> > > (this is a column name)
>
> > > Both of these do not work.
>
> > > However, if I remove this qualification my workflow works.
>
> > > Any ideas why I can't check to see if there are any rows in the table?
>
> > > THANKS!
>
> > > ___­
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
> > > __Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
> > > html___
> > > __Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
> > > html___
>
> > ___­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> > ___­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist

Re: Error with libcaieventcmd

[Wirasat Siddiqi]

Why have you disabled this file? This needs to be enabled all the time. Have
you the patch recently? If so, I believe that you need to manully replace
this file with the new file that is provided in the patch.

Wirasat


On 5/30/08, Nazish Bano <[EMAIL PROTECTED]> wrote:
>
> ** Hello all,
>
> Has anyone seen any error with libcaieventcmd.so library, everytime this is
> enabled in the ar.config the plugin server does not start.
>
> The system is ARS 7.1 and ITSM 7 patch 4
>
> TIA,
> Nazish
>
> --
> Meet people who discuss and share your passions. Join them 
> now.__Platinum
>  Sponsor:
> www.rmsportal.com ARSlist: "Where the Answers Are" html___
>
>

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

Re: Very Easy TR. Format Question.....

[Doug Blair]

Lou,

In addition to the points about TR values in filters, you can compare the 
status field with the (hidden) Change Request Prev Status field in an 
active link in Change 7 or with the similar  PreviousStatus field in 
Incident 7.  These fields hold the DB status value and are set by workflow 
when the form displays. That way you can display your message before the 
user hits Save.

Hope this helps!

Doug


.. Original Message ...
On Fri, 30 May 2008 11:46:26 -0400 Louis Cobuccio 
<[EMAIL PROTECTED]> wrote:
>Happy Friday List!
>
>I've got what should be a very, very simple question for the list.  I'm 
>trying to get an active Link to fire when the Status field is being
>moved 
>from its current value to Closed.   I've tried adding the statement
>below 
>in the Run If on the Basic tab but keep getting an error, also listed
>below:
>
>Statement:  'TR.Change Request Status' = "Closed"
>Error: Unexpected character (ARERR 2291)
>   [Qualification line error at position 26]
>
>Position 26 seems to be the ' after status.  I then try to remove both 
>single quotes and I get the same error except this time it is at
>position 9 
>which seams to be the space between Change and Request.
>
>We run AR applications v 7.0.1 patch 006 in a Windows environment with
>SQL 
>2005 database.
>
>Thanks,
>Lou
>
>___
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_
Doug Blair
Remedy Skilled Professional
doug  blairing com
+1 224-558-5462
Sent from my Treo, usual caveats apply

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

Re: SOLVED: Tables not refreshing "On Open"

[Rick Cook]

That explains why "Display" wouldn't work, as it would on a regular form.
You're right - Window Loaded is your only option.

Rick

On Fri, May 30, 2008 at 11:32 AM, Morrison, David A. <[EMAIL PROTECTED]>
wrote:

> **
>
> Yes, it is a display only form.  Thanks.
>
>
>
> David M
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Thad K Esser
> *Sent:* Friday, May 30, 2008 1:14 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: SOLVED: Tables not refreshing "On Open"
>
>
>
> **
> Display should do it, unless you are working with a Display-Only form?
>
> Is there any workflow that fires after your refresh that could be clearing
> the table?
>
> *Thad Esser*
> Remedy Developer
> "*Argue for your limitations, and sure enough, they're yours."*-- Richard
> Bach
>
>   *"Morrison, David A." <[EMAIL PROTECTED]>*
> Sent by: "Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
>
> 05/30/2008 10:03 AM
>
> Please respond to
> arslist@ARSLIST.ORG
>
> To
>
> arslist@ARSLIST.ORG
>
> cc
>
> Subject
>
> Re: SOLVED: Tables not refreshing "On Open"
>
>
>
>
>
>
> **
> Thanks for the reply.  I tried different combinations and options, and the
> only one that seems to work is when one of the options is "Window Loaded".
>  That is the only one that refreshes the table when the form opens.
>
> David M.
> ETSU
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Rick Cook*
> Sent:* Friday, May 30, 2008 12:55 PM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: SOLVED: Tables not refreshing "On Open"
>
> ** I would also use Display vs. Window Loaded.  Display only fires when an
> existing record loads.  Window Loaded fires after the default values are
> loaded on a form (which could realistically be the best choice only in
> Search or New mode), but before the data is loaded.  Using Display also
> removes the need for the $OPERATION$ keyword.
>
> Rick
> On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]> wrote:
>
> **
> Make sure you take off the "Window Open" condition, otherwise your table
> will refresh twice every time the form opens (you can see it in the logs)
> *
> Thad Esser*
> Remedy Developer
> "*Argue for your limitations, and sure enough, they're yours."*-- Richard
> Bach
>
> *"Morrison, David A." <[EMAIL PROTECTED] <[EMAIL PROTECTED]>*
> >*
> Sent by: "Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
>
> 05/30/2008 09:26 AM
>
>
>
> Please respond to*
> [EMAIL PROTECTED]
>
>
>
> To
>
> arslist@ARSLIST.ORG
>
> cc
>
> Subject
>
> SOLVED: Tables not refreshing "On Open"
>
>
>
>
>
>
>
>
>
>
> **
> It says "click to refresh.I added the condition "Window Loaded" and it
> is now refreshing when the form opens.
> Thanks to all who helped!  Have a great day!!
>
> David Morrison East Tennessee State Univ
>  *
> From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Hall Chad - chahal*
> Sent:* Friday, May 30, 2008 12:19 PM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: Tables not refreshing "On Open"
>
> **
> When you say the table doesn't refresh, does it still display "Click to
> refresh" within the table field? Or is it just an empty table? If it doesn't
> have that wording and its just empty, then it refreshed but didn't find any
> matches. In which case you should check your qualification. Since you say it
> only fires on Window Open, that is before any values have been loaded into
> any fields. So if the qualification references any other fields on the
> current form then its search qualification will probably find no matches.
> You would need to change it to Window Loaded (or maybe just Display) if that
> is the case.
>  *
> Chad Hall*
> (501) 342-2650
>
>
>
>  --
>
>
> *
> From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Morrison, David A.*
> Sent:* Friday, May 30, 2008 11:13 AM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: Tables not refreshing "On Open"
>
> Only condition is Window Open.  Thanks for replying.
>  *
> From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Rick Cook*
> Sent:* Friday, May 30, 2008 12:04 PM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: Tables not refreshing "On Open"
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <
> [EMAIL PROTECTED]> wrote:
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morri

Help: Remedy Java API 7.0

[Tadeu Augusto Dutra Pinto]

Hi everyone,
 
I'm trying to use the Java API arapi70.jar...
 
I'm implementing a code that read records of a file and enter this records in a 
form/table.
 
I would like to know if there is a way to subtitute this code:
 
EntryItem[] entryItems = new EntryItem[15];
   entryItems[0] = new EntryItem(new FieldID((new 
Long("536870925")).longValue()), new Value(unidade.getData1()));
   entryItems[1] = new EntryItem(new FieldID((new 
Long("536870918")).longValue()), new Value(unidade.getData2()));
   entryItems[2] = new EntryItem(new FieldID((new 
Long("536870919")).longValue()), new Value(unidade.getData3()));
   entryItems[3] = new EntryItem(new FieldID((new Long("4")).longValue()), new 
Value(unidade.getData4()));
   entryItems[4] = new EntryItem(new FieldID((new 
Long("536870915")).longValue()), new Value(unidade.Data5()));

   // set the entry items...
   entry.setEntryItems(entryItems);
   entry.create();
 
 
In this case above, we have only 5 fields to be inserted in a form. But If 
there is more than one or two hundred of fields... Do I have to write 100 or 
200 lines of code only insert it??? Considering that we have all values to all 
fields in destiny form.
 
 
Thanks for any tips and/or suggestions...
 
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
 
 
[EMAIL PROTECTED]  
Fone: 41 3018-2833 - Cinq
-
Confiabilidade, Inovação e Qualidade em T.I.

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

Re: Application-Delete-Query-Entry gives errors

[Gary Opela (Corporate)]

Rick,

On this new form you created, add a field called Escalation Name, and have a 
Status values of Active and Inactive.

This way, on your escalation, you can run it against this form where 
'Escalation Name' = "Name of the current escalation" AND 'Status' = "Active"

This allows you to use the form for multiple escalations in the future, and it 
also allows you to easily turn the escalation on and off without having to 
modify the escalation itself.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Delete-Query-Entry gives errors

** RESOLVED.  Thanks to all who contributed to my now-enhanced knowledge level.

OK, here is what I've done to resolve this.

I created a small form with just the core fields, and created one record in 
that form.

I then restructured my escalation to go against that one-record form, running 
the Application-Query-Delete-Entry "SHR:NotificationMessages" ('Status' = 
"Sent") from there.

The escalation ran one time, and took 2.5 minutes to delete 62k records.  No 
302 errors.  Yay!

Rick
On Fri, May 30, 2008 at 10:17 AM, Misi Mladoniczky <[EMAIL 
PROTECTED]> wrote:
Hi,

Does your escalation run on SHR:TmpMessages?

I would run it on some "scheduler" form, and it should trigger once (one
record).

The normal way to find out what the problem is would be to turn on logging.

What happens when you try to delete one record from the user tool?

   Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

> We are running an escalation nightly that runs this command:
> *Application-Query-Delete-Entry
> "SHR:TmpMessages" (( 'Status' = "Sent") AND ( 'Send Time' !=  $NULL$ ))*.
> The effect is to clear a form that contains records accumulated during the
> day, but which are no longer needed.
>
> Running this creates thousands of entries in the arerror.log file
> (roughly,
> but not exactly, equivalent to the number of records in the form) that say
> this:  *Thu May 29 10:31:45 2008  390603 : Entry does not exist in
> database
> (ARERR 302)*.
>
> There are no errors that show up in the api or sql logs, and the records
> DO
> get deleted.  Any idea why these errors appear?  I'm kinda stumped as to
> where else to look for a cause.
>
> Rick
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at 
> www.arslist.org
> Platinum Sponsor: www.rmsportal.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
Platinum Sponsor: www.rmsportal.com ARSlist: "Where 
the Answers Are"

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Re: Application-Delete-Query-Entry gives errors

[Rick Cook]

RESOLVED.  Thanks to all who contributed to my now-enhanced knowledge level.

OK, here is what I've done to resolve this.

I created a small form with just the core fields, and created one record in
that form.

I then restructured my escalation to go against that one-record form,
running the Application-Query-Delete-Entry "SHR:NotificationMessages"
('Status' = "Sent") from there.

The escalation ran one time, and took 2.5 minutes to delete 62k records.  No
302 errors.  Yay!

Rick

On Fri, May 30, 2008 at 10:17 AM, Misi Mladoniczky <[EMAIL PROTECTED]> wrote:

> Hi,
>
> Does your escalation run on SHR:TmpMessages?
>
> I would run it on some "scheduler" form, and it should trigger once (one
> record).
>
> The normal way to find out what the problem is would be to turn on logging.
>
> What happens when you try to delete one record from the user tool?
>
>Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> * RRR|Translator - Manage and automate your language translations.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
> > We are running an escalation nightly that runs this command:
> > *Application-Query-Delete-Entry
> > "SHR:TmpMessages" (( 'Status' = "Sent") AND ( 'Send Time' !=  $NULL$ ))*.
> > The effect is to clear a form that contains records accumulated during
> the
> > day, but which are no longer needed.
> >
> > Running this creates thousands of entries in the arerror.log file
> > (roughly,
> > but not exactly, equivalent to the number of records in the form) that
> say
> > this:  *Thu May 29 10:31:45 2008  390603 : Entry does not exist in
> > database
> > (ARERR 302)*.
> >
> > There are no errors that show up in the api or sql logs, and the records
> > DO
> > get deleted.  Any idea why these errors appear?  I'm kinda stumped as to
> > where else to look for a cause.
> >
> > Rick
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > Platinum Sponsor: www.rmsportal.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
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: SOLVED: Tables not refreshing "On Open"

[Thad K Esser]

Ah, okay.  Then you gotta go with Window Loaded.

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

05/30/2008 11:32 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: SOLVED: Tables not refreshing "On Open"






** 
Yes, it is a display only form.  Thanks.
 
David M
 
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser
Sent: Friday, May 30, 2008 1:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: SOLVED: Tables not refreshing "On Open"
 
** 
Display should do it, unless you are working with a Display-Only form? 

Is there any workflow that fires after your refresh that could be clearing 
the table? 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach 


"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 
 
05/30/2008 10:03 AM 


Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG 
cc

Subject
Re: SOLVED: Tables not refreshing "On Open"
 








** 
Thanks for the reply.  I tried different combinations and options, and the 
only one that seems to work is when one of the options is ?Window Loaded?. 
 That is the only one that refreshes the table when the form opens. 
  
David M. 
ETSU 
  
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: SOLVED: Tables not refreshing "On Open" 
 
** I would also use Display vs. Window Loaded.  Display only fires when an 
existing record loads.  Window Loaded fires after the default values are 
loaded on a form (which could realistically be the best choice only in 
Search or New mode), but before the data is loaded.  Using Display also 
removes the need for the $OPERATION$ keyword.

Rick 
On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]> wrote: 

** 
Make sure you take off the "Window Open" condition, otherwise your table 
will refresh twice every time the form opens (you can see it in the logs) 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach 

"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" <
arslist@ARSLIST.ORG> 
05/30/2008 09:26 AM 
 


Please respond to
arslist@ARSLIST.ORG

 


To
arslist@ARSLIST.ORG 
cc

Subject
SOLVED: Tables not refreshing "On Open"

 
 









** 
It says "click to refresh.I added the condition "Window Loaded" and it 
is now refreshing when the form opens. 
Thanks to all who helped!  Have a great day!! 
 
David Morrison East Tennessee State Univ 
 
From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
 
** 
When you say the table doesn't refresh, does it still display "Click to 
refresh" within the table field? Or is it just an empty table? If it 
doesn't have that wording and its just empty, then it refreshed but didn't 
find any matches. In which case you should check your qualification. Since 
you say it only fires on Window Open, that is before any values have been 
loaded into any fields. So if the qualification references any other 
fields on the current form then its search qualification will probably 
find no matches. You would need to change it to Window Loaded (or maybe 
just Display) if that is the case. 
 
Chad Hall  
(501) 342-2650 

 



From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
 
Only condition is Window Open.  Thanks for replying. 
 
From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
 
** David, what are the firing conditions on this Active Link?

Rick 
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <
[EMAIL PROTECTED]> wrote: 
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

___
UNSUBSCRIBE or access ARSlist Archives at www.arsli

Initial Load of Records - ARCHIVE

[Tadeu Augusto Dutra Pinto]

Hi people,
 
Firstly, I'd like to say that we are facing many performance troubles because 
of that...
 
I'd like to know if there is a better way to implement ARCHIVE feature in an 
Application/Form that contains a high number of records - more than 2 million.
 
We are searching for alternatives to do a initial load of data in our Archive 
Forms. Considering that if there is more than 2 million records saved in that 
form we wouldn't simply enable Archive feature (this would take much time)
 
Here are our attempts about this:
 
1) 
- Enable Archive feature in a Form "X" (i.e. Create "X_ARCHIVE" Form)
- Insert data in an Archive Form using Java API (arapi70.jar)
 
Result: Unfortunatly, this tip didn't work fine. Archives form doesn't support 
create or modify entries.
ERROR MESSAGE: "Cannot modify or create entries in an Archive or Audit form." 
[8998]
 
2)
- Enable Archive feature in a Form "Y" (i.e. Create "Y_ARCHIVE" Form)
- Create a Filter / Escalation that executes 'Push Fields' action periodically
 
Result: Unfortunatly, this tip didn't work fine too. Considering that Archives 
form does not support create entries.
 
3)
- Use SQL Commands and/or Oracle Database functions??? Maybe! I'd like to hear 
some suggestions of all of you...
 
 
Thanks a lot!!!
 
 
Tadeu Augusto Dutra Pinto
-
IT Web Services ATM 
Cinq Technologies
http://www.cinq.com.br 
 
 
[EMAIL PROTECTED]  
Fone: 41 3018-2833 - Cinq
-
Confiabilidade, Inovação e Qualidade em T.I.

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

Re: Tables not refreshing "On Open"

[Morrison, David A.]

It is set for "Select First, Fire Workflow".  Thanks.

David M

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Rocky Rockwell
Sent: Friday, May 30, 2008 2:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

Check the Advanced Display tab for the table. For the Refresh Table 
Options, check if it is set to "Select First, No Workflow"

*Rocky*

Rocky Rockwell
Remedy/BMC Application Designer
[EMAIL PROTECTED] 
Ph#1: 214-567-8874
Ph#2: 325-450-5076



Morrison, David A. wrote:
> **
>
> Only condition is Window Open.  Thanks for replying.
>
>  
>
> *From:* Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] *On Behalf Of *Rick Cook
> *Sent:* Friday, May 30, 2008 12:04 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Tables not refreshing "On Open"
>
>  
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
>
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. 
> <[EMAIL PROTECTED] > wrote:
>
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> 
> Platinum Sponsor: www.rmsportal.com  
> ARSlist: "Where the Answers Are"
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
> html___
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
> html___ 

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

Re: SOLVED: Tables not refreshing "On Open"

[Morrison, David A.]

Yes, it is a display only form.  Thanks.

 

David M

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser
Sent: Friday, May 30, 2008 1:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: SOLVED: Tables not refreshing "On Open"

 

** 
Display should do it, unless you are working with a Display-Only form? 

Is there any workflow that fires after your refresh that could be
clearing the table? 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach 



"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

05/30/2008 10:03 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc


Subject

Re: SOLVED: Tables not refreshing "On Open"

 






** 
Thanks for the reply.  I tried different combinations and options, and
the only one that seems to work is when one of the options is "Window
Loaded".  That is the only one that refreshes the table when the form
opens. 
  
David M. 
ETSU 
  
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: SOLVED: Tables not refreshing "On Open" 
  
** I would also use Display vs. Window Loaded.  Display only fires when
an existing record loads.  Window Loaded fires after the default values
are loaded on a form (which could realistically be the best choice only
in Search or New mode), but before the data is loaded.  Using Display
also removes the need for the $OPERATION$ keyword.

Rick 
On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]>
wrote: 
** 
Make sure you take off the "Window Open" condition, otherwise your table
will refresh twice every time the form opens (you can see it in the
logs) 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach 

"Morrison, David A." <[EMAIL PROTECTED]
 > 
Sent by: "Action Request System discussion list(ARSList)"
mailto:arslist@ARSLIST.ORG> > 

05/30/2008 09:26 AM 

 

Please respond to
arslist@ARSLIST.ORG  

 

To

arslist@ARSLIST.ORG   

cc


Subject

SOLVED: Tables not refreshing "On Open"


  

 







** 
It says "click to refresh.I added the condition "Window Loaded" and
it is now refreshing when the form opens. 
Thanks to all who helped!  Have a great day!! 
 
David Morrison East Tennessee State Univ 
 
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG  ] On Behalf Of
Hall Chad - chahal
Sent: Friday, May 30, 2008 12:19 PM
To: arslist@ARSLIST.ORG  
Subject: Re: Tables not refreshing "On Open" 
 
** 
When you say the table doesn't refresh, does it still display "Click to
refresh" within the table field? Or is it just an empty table? If it
doesn't have that wording and its just empty, then it refreshed but
didn't find any matches. In which case you should check your
qualification. Since you say it only fires on Window Open, that is
before any values have been loaded into any fields. So if the
qualification references any other fields on the current form then its
search qualification will probably find no matches. You would need to
change it to Window Loaded (or maybe just Display) if that is the case. 
 
Chad Hall  
(501) 342-2650 


  





From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG  ] On Behalf Of
Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG  
Subject: Re: Tables not refreshing "On Open" 
 
Only condition is Window Open.  Thanks for replying. 
 
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG  ] On Behalf Of
Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG  
Subject: Re: Tables not refreshing "On Open" 
 
** David, what are the firing conditions on this Active Link?

Rick 
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]> wrote: 
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 
Platinum Sponsor: ww

Re: Tables not refreshing "On Open"

[Rocky Rockwell]

Check the Advanced Display tab for the table. For the Refresh Table 
Options, check if it is set to "Select First, No Workflow"


*Rocky*

Rocky Rockwell
Remedy/BMC Application Designer
[EMAIL PROTECTED] 
Ph#1: 214-567-8874
Ph#2: 325-450-5076



Morrison, David A. wrote:

**

Only condition is Window Open.  Thanks for replying.

 

*From:* Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] *On Behalf Of *Rick Cook

*Sent:* Friday, May 30, 2008 12:04 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Tables not refreshing "On Open"

 


** David, what are the firing conditions on this Active Link?

Rick

On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. 
<[EMAIL PROTECTED] > wrote:


Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 

Platinum Sponsor: www.rmsportal.com  
ARSlist: "Where the Answers Are"



__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 


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

Re: Question: Active Link - Checking Table - ITSM 7

[T. Dee]

THANKS!!!

On 5/30/08, Gary Opela (Corporate) <[EMAIL PROTECTED]> wrote:
> Tyrone, I just tested this out.
>
> The value of a Table Field that has one or more rows is 1 or more, depending 
> on which row you have selected. If there are rows, but you have none 
> selected, then the value is still 0. You can ctrl-click on a selected row to 
> make it un-selected, so a user could potentially un-select all rows in a 
> table, even if one was already selected, which would cause a 0 to return. So, 
> make sure that you have the property on the table field set to automatically 
> select the first row choice when the table is loaded.
>
> The value of a Table Field that has not yet been refreshed is $NULL$ or "" 
> one of the two the first time you open the form. If you change the window 
> mode and then change it back, for instance, from search to create, then the 
> value of the un-refreshed table field is 0.
>
>
> The value of a Table Field that has been refreshed, but has no rows, is 0.
>
>
>
> Basically, make sure you are refreshing the table with WF, and have the 
> property checked that says select initial row, then you just check to see if 
> Table Field >= 1, if it does, then the table field has at least 1 row. If it 
> returns 0 or $NULL$ or "", then it is empty (you can count on 0 meaning empty 
> since you have automatically select first row selection).
>
> I think this would be the easiest thing to look at.
>
> Thanks,
>
>
>
> Gary Opela, Jr., RSP
>
> Remedy Engineer
>
> Leader Communications, Inc.
>
> http://www.5pointleader.com
>
> http://www.lcibest.com
>
> Best Product, Best People, Best PriceTM
>
> An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
> PROTECTED] On Behalf Of T. Dee
> Sent: Friday, May 30, 2008 8:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Question: Active Link - Checking Table - ITSM 7
>
> THANKS 
>
> I'll give these suggestions a try.
>
> Ty
>
>
> On 5/30/08, Steven Iocco <[EMAIL PROTECTED]> wrote:
> > **
> > What Ben mentioned is a good option.  You could also run a guide looping on
> > the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as
> > mentioned below, build your workflow on that result.
> > Steve
> >
> >
> >
> > 
> > Date: Fri, 30 May 2008 09:13:32 -0400
> > From: [EMAIL PROTECTED]
> > Subject: Re: Question: Active Link - Checking Table - ITSM 7
> > To: arslist@ARSLIST.ORG
> >
> >
> > **
> > Off the top of my head, I think that you do a direct sql that would return
> > the same results that the table would and then do a set field command using
> > the value of lastcount.  I think that would give you a number and you can
> > build workflow to check if the value is greater than 0.
> >
> > Ben Cantatore
> > Remedy Manager
> > (914) 457-6209
> >
> > Emerging Health IT
> > 3 Odell Plaza
> > Yonkers, New York 10701
> >
> >
> > >>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>>
> > I'm trying to check to see if a table has any rows in it, but i'm not
> > having much luck.
> >
> > I have tried to check for the table NOT being NULL and I have check
> > for a column NOT being NULL, both do not work.
> >
> > I'm looking to see if the Relationship table is NOT NULL - so I tried:
> >
> > 'z2TH Associations' != $NULL$
> > (this is the table name)
> >
> > I also tried:
> >
> > 'z2TF AssociationType' != $NULL$
> > (this is a column name)
> >
> > Both of these do not work.
> >
> > However, if I remove this qualification my workflow works.
> >
> > Any ideas why I can't check to see if there are any rows in the table?
> >
> > THANKS!
> >
> > ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: Application-Delete-Query-Entry gives errors

[Misi Mladoniczky]

Hi,

Does your escalation run on SHR:TmpMessages?

I would run it on some "scheduler" form, and it should trigger once (one
record).

The normal way to find out what the problem is would be to turn on logging.

What happens when you try to delete one record from the user tool?

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

> We are running an escalation nightly that runs this command:
> *Application-Query-Delete-Entry
> "SHR:TmpMessages" (( 'Status' = "Sent") AND ( 'Send Time' !=  $NULL$ ))*.
> The effect is to clear a form that contains records accumulated during the
> day, but which are no longer needed.
>
> Running this creates thousands of entries in the arerror.log file
> (roughly,
> but not exactly, equivalent to the number of records in the form) that say
> this:  *Thu May 29 10:31:45 2008  390603 : Entry does not exist in
> database
> (ARERR 302)*.
>
> There are no errors that show up in the api or sql logs, and the records
> DO
> get deleted.  Any idea why these errors appear?  I'm kinda stumped as to
> where else to look for a cause.
>
> Rick
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.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
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: SOLVED: Tables not refreshing "On Open"

[Thad K Esser]

Display should do it, unless you are working with a Display-Only form?

Is there any workflow that fires after your refresh that could be clearing 
the table?

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

05/30/2008 10:03 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: SOLVED: Tables not refreshing "On Open"






** 
Thanks for the reply.  I tried different combinations and options, and the 
only one that seems to work is when one of the options is ?Window Loaded?. 
 That is the only one that refreshes the table when the form opens.
 
David M.
ETSU
 
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: SOLVED: Tables not refreshing "On Open"
 
** I would also use Display vs. Window Loaded.  Display only fires when an 
existing record loads.  Window Loaded fires after the default values are 
loaded on a form (which could realistically be the best choice only in 
Search or New mode), but before the data is loaded.  Using Display also 
removes the need for the $OPERATION$ keyword.

Rick
On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]> wrote:
** 
Make sure you take off the "Window Open" condition, otherwise your table 
will refresh twice every time the form opens (you can see it in the logs) 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach 


"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" <
arslist@ARSLIST.ORG> 
05/30/2008 09:26 AM 


Please respond to
arslist@ARSLIST.ORG



To
arslist@ARSLIST.ORG 
cc

Subject
SOLVED: Tables not refreshing "On Open"
 








** 
It says "click to refresh.I added the condition "Window Loaded" and it 
is now refreshing when the form opens. 
Thanks to all who helped!  Have a great day!! 
  
David Morrison East Tennessee State Univ 
  
From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
 
** 
When you say the table doesn't refresh, does it still display "Click to 
refresh" within the table field? Or is it just an empty table? If it 
doesn't have that wording and its just empty, then it refreshed but didn't 
find any matches. In which case you should check your qualification. Since 
you say it only fires on Window Open, that is before any values have been 
loaded into any fields. So if the qualification references any other 
fields on the current form then its search qualification will probably 
find no matches. You would need to change it to Window Loaded (or maybe 
just Display) if that is the case. 
  
Chad Hall  
(501) 342-2650 
 


From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
  
Only condition is Window Open.  Thanks for replying. 
  
From: Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
 
** David, what are the firing conditions on this Active Link?

Rick 
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <
[EMAIL PROTECTED]> wrote: 
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

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

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
* 
The information contained in this communication is confidential, is 
intended only for the use of the recipient named above, and may be 
legally privileged. 
  
If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. 
  
If you have received this communication in error, please resend this 
communication to the sender and delete the original message or

Re: SOLVED: Tables not refreshing "On Open"

[Morrison, David A.]

Thanks for the reply.  I tried different combinations and options, and
the only one that seems to work is when one of the options is "Window
Loaded".  That is the only one that refreshes the table when the form
opens.

 

David M.

ETSU

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: SOLVED: Tables not refreshing "On Open"

 

** I would also use Display vs. Window Loaded.  Display only fires when
an existing record loads.  Window Loaded fires after the default values
are loaded on a form (which could realistically be the best choice only
in Search or New mode), but before the data is loaded.  Using Display
also removes the need for the $OPERATION$ keyword.

Rick

On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]>
wrote:

** 
Make sure you take off the "Window Open" condition, otherwise your table
will refresh twice every time the form opens (you can see it in the
logs) 

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach 



"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

05/30/2008 09:26 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc


Subject

SOLVED: Tables not refreshing "On Open"

 






** 
It says "click to refresh.I added the condition "Window Loaded" and
it is now refreshing when the form opens. 
Thanks to all who helped!  Have a great day!! 
  
David Morrison East Tennessee State Univ 
  
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
  
** 
When you say the table doesn't refresh, does it still display "Click to
refresh" within the table field? Or is it just an empty table? If it
doesn't have that wording and its just empty, then it refreshed but
didn't find any matches. In which case you should check your
qualification. Since you say it only fires on Window Open, that is
before any values have been loaded into any fields. So if the
qualification references any other fields on the current form then its
search qualification will probably find no matches. You would need to
change it to Window Loaded (or maybe just Display) if that is the case. 
  
Chad Hall  
(501) 342-2650 

 




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
  
Only condition is Window Open.  Thanks for replying. 
  
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open" 
  
** David, what are the firing conditions on this Active Link?

Rick 
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]> wrote: 
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

* 
The information contained in this communication is confidential, is 
intended only for the use of the recipient named above, and may be 
legally privileged. 
  
If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. 
  
If you have received this communication in error, please resend this 
communication to the sender and delete the original message or any copy 
of it from your computer system. 
  
Thank you. 

* 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

***IMPORTANT NOTICE: This communication, including any atta

Re: Tables not refreshing "On Open"

[Morrison, David A.]

Thanks for the advise!  

David M.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser
Sent: Friday, May 30, 2008 12:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** 
If the AL is only running on Display, won't the $OPERATION$ value always
be "SET"? 

By the way, if your table is on a tab, I'd recommend turning OFF the
"Refresh On Entry Change" setting.  A lot of the performance issues with
forms displaying stem from tables that no one is looking at being
refreshed when the form opens.  To make sure the table gets refreshed as
needed: 
 1.  Set the AL to run on "Display" AND "Gain Focus" of the tab its
on.  No need to have it refresh on Window Open or Window Loaded. 
 2.  Give it a Run If of 'Page holder' = "Tab Name" 
 3.  Action: Refresh the table. 

That structure makes sure you only refresh the table when needed.  It
used to take our Help Desk form up to 30 seconds just to display a
record because of all the hidden table refreshes that were happening.
Now its less than 1 second. 

Hopefully that helps some.
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach 



Carey Matthew Black <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

05/30/2008 09:21 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc


Subject

Re: Tables not refreshing "On Open"

 






David,

I suggest that you change the execute on condition to "Display" and
you might want to add $OPERATION$= "SET" (to only refresh the tables
when your looking at a data row) to the Run If. (If it is not already
there.)

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Fri, May 30, 2008 at 12:13 PM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:
> **
>
> Only condition is Window Open.  Thanks for replying.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
> Sent: Friday, May 30, 2008 12:04 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Tables not refreshing "On Open"
>
>
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
>
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]>
> wrote:
>
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that
has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University


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

***IMPORTANT NOTICE: This communication, including any attachment,
contains information that may be confidential or privileged, and is
intended solely for the entity or individual to whom it is addressed. If
you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of
this message is strictly prohibited. Nothing in this email, including
any attachment, is intended to be a legally binding signature.***

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___


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

Re: SOLVED: Tables not refreshing "On Open"

[Rick Cook]

I would also use Display vs. Window Loaded.  Display only fires when an
existing record loads.  Window Loaded fires after the default values are
loaded on a form (which could realistically be the best choice only in
Search or New mode), but before the data is loaded.  Using Display also
removes the need for the $OPERATION$ keyword.

Rick

On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]> wrote:

> **
> Make sure you take off the "Window Open" condition, otherwise your table
> will refresh twice every time the form opens (you can see it in the logs)
>
> *Thad Esser*
> Remedy Developer
> "*Argue for your limitations, and sure enough, they're yours."*-- Richard
> Bach
>
>
>  *"Morrison, David A." <[EMAIL PROTECTED]>*
> Sent by: "Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
>
> 05/30/2008 09:26 AM
>  Please respond to
> arslist@ARSLIST.ORG
>
>   To
> arslist@ARSLIST.ORG  cc
>   Subject
> SOLVED: Tables not refreshing "On Open"
>
>
>
>
> **
> It says "click to refresh.I added the condition "Window Loaded" and it
> is now refreshing when the form opens.
> Thanks to all who helped!  Have a great day!!
>
> David Morrison East Tennessee State Univ
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Hall Chad - chahal*
> Sent:* Friday, May 30, 2008 12:19 PM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: Tables not refreshing "On Open"
>
> **
> When you say the table doesn't refresh, does it still display "Click to
> refresh" within the table field? Or is it just an empty table? If it doesn't
> have that wording and its just empty, then it refreshed but didn't find any
> matches. In which case you should check your qualification. Since you say it
> only fires on Window Open, that is before any values have been loaded into
> any fields. So if the qualification references any other fields on the
> current form then its search qualification will probably find no matches.
> You would need to change it to Window Loaded (or maybe just Display) if that
> is the case.
>
> *Chad Hall*
> (501) 342-2650
> --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Morrison, David A.*
> Sent:* Friday, May 30, 2008 11:13 AM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: Tables not refreshing "On Open"
>
> Only condition is Window Open.  Thanks for replying.
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Rick Cook*
> Sent:* Friday, May 30, 2008 12:04 PM*
> To:* [EMAIL PROTECTED]
> Subject:* Re: Tables not refreshing "On Open"
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <*
> [EMAIL PROTECTED] <[EMAIL PROTECTED]>> wrote:
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at 
> *www.arslist.org*
> Platinum Sponsor: *www.rmsportal.com*  ARSlist:
> "Where the Answers Are"
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> *
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be
> legally privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank you.
> *
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
> Are" html___
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
> ***IMPORTANT NOTICE: This communication, including any attachment, contains
> information that may be confidential or privileged, and is intended solely
> for the entity or individual to whom it is addressed. If you are not the
> intended recipient, you should delete this message and are hereby notified
> that any disclosur

Re: SOLVED: Tables not refreshing "On Open"

[Thad K Esser]

Make sure you take off the "Window Open" condition, otherwise your table 
will refresh twice every time the form opens (you can see it in the logs)

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Morrison, David A." <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

05/30/2008 09:26 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
SOLVED: Tables not refreshing "On Open"






** 
It says ?click to refresh.I added the condition ?Window Loaded? and it 
is now refreshing when the form opens.
Thanks to all who helped!  Have a great day!!
 
David Morrison East Tennessee State Univ
 
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"
 
** 
When you say the table doesn?t refresh, does it still display ?Click to 
refresh? within the table field? Or is it just an empty table? If it 
doesn?t have that wording and its just empty, then it refreshed but didn?t 
find any matches. In which case you should check your qualification. Since 
you say it only fires on Window Open, that is before any values have been 
loaded into any fields. So if the qualification references any other 
fields on the current form then its search qualification will probably 
find no matches. You would need to change it to Window Loaded (or maybe 
just Display) if that is the case.
 
Chad Hall  
(501) 342-2650

From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"
 
Only condition is Window Open.  Thanks for replying.
 
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"
 
** David, what are the firing conditions on this Active Link?

Rick
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <
[EMAIL PROTECTED]> wrote:
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

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

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
 
If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
 
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
 
Thank you.
*
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers 
Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 
html___ 

***IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed.  If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited.  
Nothing in this email, including any attachment, is intended to be a legally 
binding signature.***

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

Re: Tables not refreshing "On Open"

[Thad K Esser]

If the AL is only running on Display, won't the $OPERATION$ value always 
be "SET"?

By the way, if your table is on a tab, I'd recommend turning OFF the 
"Refresh On Entry Change" setting.  A lot of the performance issues with 
forms displaying stem from tables that no one is looking at being 
refreshed when the form opens.  To make sure the table gets refreshed as 
needed:
 1.  Set the AL to run on "Display" AND "Gain Focus" of the tab its 
on.  No need to have it refresh on Window Open or Window Loaded.
 2.  Give it a Run If of 'Page holder' = "Tab Name" 
 3.  Action: Refresh the table.

That structure makes sure you only refresh the table when needed.  It used 
to take our Help Desk form up to 30 seconds just to display a record 
because of all the hidden table refreshes that were happening.  Now its 
less than 1 second.

Hopefully that helps some.
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



Carey Matthew Black <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

05/30/2008 09:21 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: Tables not refreshing "On Open"






David,

I suggest that you change the execute on condition to "Display" and
you might want to add $OPERATION$= "SET" (to only refresh the tables
when your looking at a data row) to the Run If. (If it is not already
there.)

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Fri, May 30, 2008 at 12:13 PM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:
> **
>
> Only condition is Window Open.  Thanks for replying.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
> Sent: Friday, May 30, 2008 12:04 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Tables not refreshing "On Open"
>
>
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
>
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. 
<[EMAIL PROTECTED]>
> wrote:
>
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University

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


***IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed.  If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited.  
Nothing in this email, including any attachment, is intended to be a legally 
binding signature.***

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

SOLVED: Tables not refreshing "On Open"

[Morrison, David A.]

It says "click to refresh.I added the condition "Window Loaded" and
it is now refreshing when the form opens.

Thanks to all who helped!  Have a great day!!

 

David Morrison East Tennessee State Univ

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** 

When you say the table doesn't refresh, does it still display "Click to
refresh" within the table field? Or is it just an empty table? If it
doesn't have that wording and its just empty, then it refreshed but
didn't find any matches. In which case you should check your
qualification. Since you say it only fires on Window Open, that is
before any values have been loaded into any fields. So if the
qualification references any other fields on the current form then its
search qualification will probably find no matches. You would need to
change it to Window Loaded (or maybe just Display) if that is the case.

 

Chad Hall  
(501) 342-2650



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

Only condition is Window Open.  Thanks for replying.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** David, what are the firing conditions on this Active Link?

Rick

On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
 
If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
 
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
 
Thank you.

*

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___


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

Re: Tables not refreshing "On Open"

[Morrison, David A.]

I put in another  qualification.  Thanks for the reply.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Friday, May 30, 2008 12:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

You took the external operator out and...replaced it with a test
qualification?

If you had an external() operator as the table's qualification and then
removed it, if you didn't plug in another qualification to replace it,
you have no qualification on the table.

If you DID have an external() operator, then I think Gary's suspicion is
right on--the external qualification was not being built correctly
before the table was being refreshed.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

No external operator.  I did have and took it out to try.  The AL is
running on Window Open.  Thanks for the reply.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

David, are you using External() operator in the qualification of the
table field?

Is your Active Link refreshing the table running on Window Open, Window
Loaded, or Display?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Tables not refreshing "On Open"

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


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


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


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

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

Re: Tables not refreshing "On Open"

[Morrison, David A.]

No, fields from another form.  Thanks for the reply.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 12:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** 

Is your table field using a field on the current form in the
qualification?

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

Only condition is Window Open.  Thanks for replying.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** David, what are the firing conditions on this Active Link?

Rick

On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html_Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___ 


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

Re: Tables not refreshing "On Open"

[Rick Cook]

Why don't you try "Display"?  That happens a bit farther down the chain than
Window Open, which fires before the data is loaded on the form, and will
also fire on a Search window.  Display will only fire on a Modify window
after the record is fully loaded.

Rick

On Fri, May 30, 2008 at 9:13 AM, Morrison, David A. <[EMAIL PROTECTED]>
wrote:

> **
>
> Only condition is Window Open.  Thanks for replying.
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Rick Cook
> *Sent:* Friday, May 30, 2008 12:04 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Tables not refreshing "On Open"
>
>
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
>
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <
> [EMAIL PROTECTED]> wrote:
>
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>  __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___

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

Re: Tables not refreshing "On Open"

[Carey Matthew Black]

David,

I suggest that you change the execute on condition to "Display" and
you might want to add $OPERATION$= "SET" (to only refresh the tables
when your looking at a data row) to the Run If. (If it is not already
there.)

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Fri, May 30, 2008 at 12:13 PM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:
> **
>
> Only condition is Window Open.  Thanks for replying.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
> Sent: Friday, May 30, 2008 12:04 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Tables not refreshing "On Open"
>
>
>
> ** David, what are the firing conditions on this Active Link?
>
> Rick
>
> On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL PROTECTED]>
> wrote:
>
> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University

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

Re: Tables not refreshing "On Open"

[Gary Opela (Corporate)]

Chad, I agree with you, that's where I was headed with my questions. I guess I 
should have just spit out my point in the beginning.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 11:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

When you say the table doesn't refresh, does it still display "Click to 
refresh" within the table field? Or is it just an empty table? If it doesn't 
have that wording and its just empty, then it refreshed but didn't find any 
matches. In which case you should check your qualification. Since you say it 
only fires on Window Open, that is before any values have been loaded into any 
fields. So if the qualification references any other fields on the current form 
then its search qualification will probably find no matches. You would need to 
change it to Window Loaded (or maybe just Display) if that is the case.


Chad Hall
(501) 342-2650


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

Only condition is Window Open.  Thanks for replying.

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

** David, what are the firing conditions on this Active Link?

Rick
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL 
PROTECTED]> wrote:
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

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

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

*

The information contained in this communication is confidential, is

intended only for the use of the recipient named above, and may be

legally privileged.



If the reader of this message is not the intended recipient, you are

hereby notified that any dissemination, distribution or copying of this

communication is strictly prohibited.



If you have received this communication in error, please resend this

communication to the sender and delete the original message or any copy

of it from your computer system.



Thank you.

*

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Running Sync Search DB from command line

[Nowak, James]

I am trying to sync the search DB from the command line (looking to
eventually schedule this during off-hours).

Using the following command

aradmin -u Demo -x  -s

Nothing happens

I have also tried add -p   and -portnum <>  but nothing.  

Using aradmin 6.3 patch 24 from a Windows system to 
AR 6.3 patch 16 on Solaris w/ Oracle DB.

Any advice?


Thanks,
Jim Nowak
Infrastructure Tools
OfficeMax Inc.
630-438-7365 w
630-414-0193 c
 

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

Re: Tables not refreshing "On Open"

[Hall Chad - chahal]

When you say the table doesn't refresh, does it still display "Click to
refresh" within the table field? Or is it just an empty table? If it
doesn't have that wording and its just empty, then it refreshed but
didn't find any matches. In which case you should check your
qualification. Since you say it only fires on Window Open, that is
before any values have been loaded into any fields. So if the
qualification references any other fields on the current form then its
search qualification will probably find no matches. You would need to
change it to Window Loaded (or maybe just Display) if that is the case.

 

Chad Hall  
(501) 342-2650



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

Only condition is Window Open.  Thanks for replying.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** David, what are the firing conditions on this Active Link?

Rick

On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.
*

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

Re: Tables not refreshing "On Open"

[Gary Opela (Corporate)]

Is your table field using a field on the current form in the qualification?

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

Only condition is Window Open.  Thanks for replying.

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

** David, what are the firing conditions on this Active Link?

Rick
On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL 
PROTECTED]> wrote:
Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

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

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Re: Tables not refreshing "On Open"

[Kaiser Norm E CIV USAF 96 CS/SCCE]

You took the external operator out and...replaced it with a test
qualification?

If you had an external() operator as the table's qualification and then
removed it, if you didn't plug in another qualification to replace it,
you have no qualification on the table.

If you DID have an external() operator, then I think Gary's suspicion is
right on--the external qualification was not being built correctly
before the table was being refreshed.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

No external operator.  I did have and took it out to try.  The AL is
running on Window Open.  Thanks for the reply.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

David, are you using External() operator in the qualification of the
table field?

Is your Active Link refreshing the table running on Window Open, Window
Loaded, or Display?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Tables not refreshing "On Open"

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


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


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

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

Re: Tables not refreshing "On Open"

[Morrison, David A.]

Only condition is Window Open.  Thanks for replying.

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

 

** David, what are the firing conditions on this Active Link?

Rick

On Fri, May 30, 2008 at 8:56 AM, Morrison, David A.
<[EMAIL PROTECTED]> wrote:

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


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

Re: Tables not refreshing "On Open"

[Morrison, David A.]

No external operator.  I did have and took it out to try.  The AL is
running on Window Open.  Thanks for the reply.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

David, are you using External() operator in the qualification of the
table field?

Is your Active Link refreshing the table running on Window Open, Window
Loaded, or Display?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Tables not refreshing "On Open"

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


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

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

Re: Tables not refreshing "On Open"

[Morrison, David A.]

Thanks for the reply.  I had not checked this, but did and it still does
not work.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal
Sent: Friday, May 30, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

Make sure your table field has the Refresh On Entry Change option
selected. That will cause it to refresh as soon as you display the
entry, and you won't need an active link to force the refresh.

Chad Hall  
(501) 342-2650


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 11:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

David, are you using External() operator in the qualification of the
table field?

Is your Active Link refreshing the table running on Window Open, Window
Loaded, or Display?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Tables not refreshing "On Open"

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


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

***
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.




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

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

Re: Tables not refreshing "On Open"

[Hall Chad - chahal]

Make sure your table field has the Refresh On Entry Change option
selected. That will cause it to refresh as soon as you display the
entry, and you won't need an active link to force the refresh.

Chad Hall  
(501) 342-2650


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 11:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tables not refreshing "On Open"

David, are you using External() operator in the qualification of the
table field?

Is your Active Link refreshing the table running on Window Open, Window
Loaded, or Display?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Tables not refreshing "On Open"

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University


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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
***
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.


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

Re: Very Easy TR. Format Question.....

[Louis Cobuccio]

Thank you Matt, Rick and Elia filter will work fine for this.

Have a great weekend all,
Lou

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt
Sent: Friday, May 30, 2008 11:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Very Easy TR. Format Question.

Louis, 

TR and DB values do not work in Active Links, only server side
processing.
Sorry!  To achieve the same affect, you would need to store the 'orig'
value
in a temp field and compare it to the value at the time of processing.

Good luck!

Matt R.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Friday, May 30, 2008 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Very Easy TR. Format Question.

Happy Friday List!

I've got what should be a very, very simple question for the list.  I'm 
trying to get an active Link to fire when the Status field is being
moved 
from its current value to Closed.   I've tried adding the statement
below 
in the Run If on the Basic tab but keep getting an error, also listed
below:

Statement:  'TR.Change Request Status' = "Closed"
Error: Unexpected character (ARERR 2291)
   [Qualification line error at position 26]

Position 26 seems to be the ' after status.  I then try to remove both 
single quotes and I get the same error except this time it is at
position 9 
which seams to be the space between Change and Request.

We run AR applications v 7.0.1 patch 006 in a Windows environment with
SQL 
2005 database.

Thanks,
Lou



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


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

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

Re: Tables not refreshing "On Open"

[Rick Cook]

David, what are the firing conditions on this Active Link?

Rick

On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL PROTECTED]>
wrote:

> Good day everybody,
>
> Strange problem that is driving me nuts.  I have an Active Link that has
> as one of its actions a Change Field on a table with the option being
> "Refresh Table".  The worklog says the qualification passes and lists
> the action, but the table does not refresh when the form opens.  Only
> one view and all permissions have been checked.  Any ideas would be
> greatly appreciated.
>
> AR 7.1  patch 2
> Windows Server 2003
> SQL 2005
>
>
> David Morrison
> East Tennessee State University
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: Tables not refreshing "On Open"

[Gary Opela (Corporate)]

David, are you using External() operator in the qualification of the table 
field?

Is your Active Link refreshing the table running on Window Open, Window Loaded, 
or Display?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Morrison, David A.
Sent: Friday, May 30, 2008 10:57 AM
To: arslist@ARSLIST.ORG
Subject: Tables not refreshing "On Open"

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

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

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

Tables not refreshing "On Open"

[Morrison, David A.]

Good day everybody,

Strange problem that is driving me nuts.  I have an Active Link that has
as one of its actions a Change Field on a table with the option being
"Refresh Table".  The worklog says the qualification passes and lists
the action, but the table does not refresh when the form opens.  Only
one view and all permissions have been checked.  Any ideas would be
greatly appreciated.

AR 7.1  patch 2
Windows Server 2003
SQL 2005


David Morrison
East Tennessee State University

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

Re: Very Easy TR. Format Question.....

[Matt Reinfeldt]

Louis, 

TR and DB values do not work in Active Links, only server side processing.
Sorry!  To achieve the same affect, you would need to store the 'orig' value
in a temp field and compare it to the value at the time of processing.

Good luck!

Matt R.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Friday, May 30, 2008 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Very Easy TR. Format Question.

Happy Friday List!

I've got what should be a very, very simple question for the list.  I'm 
trying to get an active Link to fire when the Status field is being
moved 
from its current value to Closed.   I've tried adding the statement
below 
in the Run If on the Basic tab but keep getting an error, also listed
below:

Statement:  'TR.Change Request Status' = "Closed"
Error: Unexpected character (ARERR 2291)
   [Qualification line error at position 26]

Position 26 seems to be the ' after status.  I then try to remove both 
single quotes and I get the same error except this time it is at
position 9 
which seams to be the space between Change and Request.

We run AR applications v 7.0.1 patch 006 in a Windows environment with
SQL 
2005 database.

Thanks,
Lou


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

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

Re: Very Easy TR. Format Question.....

[Rick Cook]

Lou, TR/DB values can only be used on Filters.  If you want to track the
transition between status values, either do it via a Filter or have a field
that stores the "old status" value, and compare that to Status.

Rick

On Fri, May 30, 2008 at 8:46 AM, Louis Cobuccio <[EMAIL PROTECTED]>
wrote:

> Happy Friday List!
>
> I've got what should be a very, very simple question for the list.  I'm
> trying to get an active Link to fire when the Status field is being
> moved
> from its current value to Closed.   I've tried adding the statement
> below
> in the Run If on the Basic tab but keep getting an error, also listed
> below:
>
> Statement:  'TR.Change Request Status' = "Closed"
> Error: Unexpected character (ARERR 2291)
>   [Qualification line error at position 26]
>
> Position 26 seems to be the ' after status.  I then try to remove both
> single quotes and I get the same error except this time it is at
> position 9
> which seams to be the space between Change and Request.
>
> We run AR applications v 7.0.1 patch 006 in a Windows environment with
> SQL
> 2005 database.
>
> Thanks,
> Lou
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: Very Easy TR. Format Question.....

[Eli Schilling]

Hi Lou,

Active Links do not support TR and DB status values.  Since they run
client side you only have transaction value.

If you only want to fire the AL when the status changes I would suggest
you use the Previous Status Value field or the status history to obtain
the desired outcome.

Cheers!

Eli 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio
Sent: Friday, May 30, 2008 8:46 AM
To: arslist@ARSLIST.ORG
Subject: Very Easy TR. Format Question.

Happy Friday List!

I've got what should be a very, very simple question for the list.  I'm
trying to get an active Link to fire when the Status field is being
moved 
from its current value to Closed.   I've tried adding the statement
below
in the Run If on the Basic tab but keep getting an error, also listed
below:

Statement:  'TR.Change Request Status' = "Closed"
Error: Unexpected character (ARERR 2291)
   [Qualification line error at position 26]

Position 26 seems to be the ' after status.  I then try to remove both
single quotes and I get the same error except this time it is at
position 9 which seams to be the space between Change and Request.

We run AR applications v 7.0.1 patch 006 in a Windows environment with
SQL
2005 database.

Thanks,
Lou


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

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

Very Easy TR. Format Question.....

[Louis Cobuccio]

Happy Friday List!

I've got what should be a very, very simple question for the list.  I'm 
trying to get an active Link to fire when the Status field is being
moved 
from its current value to Closed.   I've tried adding the statement
below 
in the Run If on the Basic tab but keep getting an error, also listed
below:

Statement:  'TR.Change Request Status' = "Closed"
Error: Unexpected character (ARERR 2291)
   [Qualification line error at position 26]

Position 26 seems to be the ' after status.  I then try to remove both 
single quotes and I get the same error except this time it is at
position 9 
which seams to be the space between Change and Request.

We run AR applications v 7.0.1 patch 006 in a Windows environment with
SQL 
2005 database.

Thanks,
Lou

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

Error Updating Problem Ticket

[Jomonm]

I am creating custom workflow by using email update to Problem ticket. During
the OOB workflow is checking the user belong to Group "Problem Master". The
email user "Remedy Application Service" does not belong to this group and it
is throwing error 

" You do not currently have permission to modify a problem investigation
request. Notify your administrator.".

Any workaround to overcome this? 
-- 
View this message in context: 
http://www.nabble.com/Error-Updating-Problem-Ticket-tp17561779p17561779.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: Midtier Timezone

[Gary Opela (Corporate)]

Frank, I think (I might be wrong though) that Mid-Tier gets its TZ info from 
Java. You might check out on Sun's website on how to see what time zone java 
thinks it is dealing with, and how to update it if it is wrong.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Frank Caruso
Sent: Friday, May 30, 2008 9:38 AM
To: arslist@ARSLIST.ORG
Subject: Midtier Timezone

** Have two Midtier 7.0.1p7 servers. Both are Tomcat and Apache on Linux RHEL 
64. Both were installed the same way and both show date time in EDT.
However, one server is displaying times on tickets one hour different from the 
other and if I look in the Midtier config tool on the Cache settings page, one 
server shows as EDT and the other shows as GMT-5.

Any idea why this might and where I might look to correct it?

Thank you
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Midtier Timezone

[Frank Caruso]

Have two Midtier 7.0.1p7 servers. Both are Tomcat and Apache on Linux RHEL
64. Both were installed the same way and both show date time in EDT.
However, one server is displaying times on tickets one hour different from
the other and if I look in the Midtier config tool on the Cache settings
page, one server shows as EDT and the other shows as GMT-5.

Any idea why this might and where I might look to correct it?

Thank you

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

Error with libcaieventcmd

[Nazish Bano]

Hello all,
   
  Has anyone seen any error with libcaieventcmd.so library, everytime this is 
enabled in the ar.config the plugin server does not start.
   
  The system is ARS 7.1 and ITSM 7 patch 4
   
  TIA,
  Nazish

   
-
 Meet people who discuss and share your passions.  Join them now.

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

Re: Question: Active Link - Checking Table - ITSM 7

[Gary Opela (Corporate)]

Tyrone, I just tested this out.

The value of a Table Field that has one or more rows is 1 or more, depending on 
which row you have selected. If there are rows, but you have none selected, 
then the value is still 0. You can ctrl-click on a selected row to make it 
un-selected, so a user could potentially un-select all rows in a table, even if 
one was already selected, which would cause a 0 to return. So, make sure that 
you have the property on the table field set to automatically select the first 
row choice when the table is loaded.

The value of a Table Field that has not yet been refreshed is $NULL$ or "" one 
of the two the first time you open the form. If you change the window mode and 
then change it back, for instance, from search to create, then the value of the 
un-refreshed table field is 0.


The value of a Table Field that has been refreshed, but has no rows, is 0.



Basically, make sure you are refreshing the table with WF, and have the 
property checked that says select initial row, then you just check to see if 
Table Field >= 1, if it does, then the table field has at least 1 row. If it 
returns 0 or $NULL$ or "", then it is empty (you can count on 0 meaning empty 
since you have automatically select first row selection).

I think this would be the easiest thing to look at.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of T. Dee
Sent: Friday, May 30, 2008 8:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Question: Active Link - Checking Table - ITSM 7

THANKS 

I'll give these suggestions a try.

Ty


On 5/30/08, Steven Iocco <[EMAIL PROTECTED]> wrote:
> **
> What Ben mentioned is a good option.  You could also run a guide looping on
> the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as
> mentioned below, build your workflow on that result.
> Steve
>
>
>
> 
> Date: Fri, 30 May 2008 09:13:32 -0400
> From: [EMAIL PROTECTED]
> Subject: Re: Question: Active Link - Checking Table - ITSM 7
> To: arslist@ARSLIST.ORG
>
>
> **
> Off the top of my head, I think that you do a direct sql that would return
> the same results that the table would and then do a set field command using
> the value of lastcount.  I think that would give you a number and you can
> build workflow to check if the value is greater than 0.
>
> Ben Cantatore
> Remedy Manager
> (914) 457-6209
>
> Emerging Health IT
> 3 Odell Plaza
> Yonkers, New York 10701
>
>
> >>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>>
> I'm trying to check to see if a table has any rows in it, but i'm not
> having much luck.
>
> I have tried to check for the table NOT being NULL and I have check
> for a column NOT being NULL, both do not work.
>
> I'm looking to see if the Relationship table is NOT NULL - so I tried:
>
> 'z2TH Associations' != $NULL$
> (this is the table name)
>
> I also tried:
>
> 'z2TF AssociationType' != $NULL$
> (this is a column name)
>
> Both of these do not work.
>
> However, if I remove this qualification my workflow works.
>
> Any ideas why I can't check to see if there are any rows in the table?
>
> THANKS!
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___

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

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

Re: Question: Active Link - Checking Table - ITSM 7

[T. Dee]

THANKS 

I'll give these suggestions a try.

Ty


On 5/30/08, Steven Iocco <[EMAIL PROTECTED]> wrote:
> **
> What Ben mentioned is a good option.  You could also run a guide looping on
> the 'z2TH Associations' table to give you a $LASTCOUNT$ number and as
> mentioned below, build your workflow on that result.
> Steve
>
>
>
> 
> Date: Fri, 30 May 2008 09:13:32 -0400
> From: [EMAIL PROTECTED]
> Subject: Re: Question: Active Link - Checking Table - ITSM 7
> To: arslist@ARSLIST.ORG
>
>
> **
> Off the top of my head, I think that you do a direct sql that would return
> the same results that the table would and then do a set field command using
> the value of lastcount.  I think that would give you a number and you can
> build workflow to check if the value is greater than 0.
>
> Ben Cantatore
> Remedy Manager
> (914) 457-6209
>
> Emerging Health IT
> 3 Odell Plaza
> Yonkers, New York 10701
>
>
> >>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>>
> I'm trying to check to see if a table has any rows in it, but i'm not
> having much luck.
>
> I have tried to check for the table NOT being NULL and I have check
> for a column NOT being NULL, both do not work.
>
> I'm looking to see if the Relationship table is NOT NULL - so I tried:
>
> 'z2TH Associations' != $NULL$
> (this is the table name)
>
> I also tried:
>
> 'z2TF AssociationType' != $NULL$
> (this is a column name)
>
> Both of these do not work.
>
> However, if I remove this qualification my workflow works.
>
> Any ideas why I can't check to see if there are any rows in the table?
>
> THANKS!
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___

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

Re: Stoopid Parenthesis

[Nall, Roger]

Lisa,

 

In this case both statements are the same. Because you are using the AND
operator each section must be true for the qualification to be true. If
you were using the OR operator then the parenthesis in your first
statement would remain instead of being deleted.

 

HTH,

 

Roger A. Nall

Manager, OSSNMS Remedy

T-Mobile USA

Desk: 813-348-2556

Cell: 973-652-6723

FAX: 813-348-2565

sf49fanv AIM IM

RogerNall   Yahoo IM

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Friday, May 30, 2008 9:36 AM
To: arslist@ARSLIST.ORG
Subject: Stoopid Parenthesis

 

I forget how to force extra Parenthesis when I need them in the
Qualification area on a table field... 

I would like it to look like this: 

( 'Survey Type' = $Survey Type$) AND (( 'Create Date' >= $Result From
Date$) AND ( 'Create Date' < $Result To Date$)) 

But when I save the form, Remedy changes it to: 

( 'Survey Type' = $Survey Type$) AND ( 'Create Date' >= $Result From
Date$) AND ( 'Create Date' < $Result To Date$) 

ARS 7.0.1 Patch 007 (admin) 
Server 7.0.1 Patch 003 
Windows 2003 

Lisa Kemes 
AR System Developer 
Tyco Electronics 
717-810-2408 tel 
717-810-2124 fax 
[EMAIL PROTECTED] 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

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

Re: Stoopid Parenthesis

[Kemes, Lisa]

You are correct.  I don't need the extra parens.  Duh  I thought I
did
 

Lisa 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Friday, May 30, 2008 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Stoopid Parenthesis


** 

Why do you need the extra parenthesis? Remedy is removing them because
they are not necessary, since you are using all AND statements. If it is
just for readability, then I'm not sure how you would keep them.

 

However, if you are setting a field to that, and trying to use
EXTERNAL($FIELD$), then that's a different story (although I'm still not
sure you need the extra parens).

 

Thanks,

 

Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Friday, May 30, 2008 8:36 AM
To: arslist@ARSLIST.ORG
Subject: Stoopid Parenthesis

 

I forget how to force extra Parenthesis when I need them in the
Qualification area on a table field... 

I would like it to look like this: 

( 'Survey Type' = $Survey Type$) AND (( 'Create Date' >= $Result From
Date$) AND ( 'Create Date' < $Result To Date$)) 

But when I save the form, Remedy changes it to: 

( 'Survey Type' = $Survey Type$) AND ( 'Create Date' >= $Result From
Date$) AND ( 'Create Date' < $Result To Date$) 

ARS 7.0.1 Patch 007 (admin) 
Server 7.0.1 Patch 003 
Windows 2003 

Lisa Kemes 
AR System Developer 
Tyco Electronics 
717-810-2408 tel 
717-810-2124 fax 
[EMAIL PROTECTED] 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html_Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___ 

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

Re: Stoopid Parenthesis

[Russell, James C]

** 'sokay, Lisa, those two statements are logically equivalent.

~james


> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
> Sent: Friday, May 30, 2008 8:36 AM
> To: arslist@ARSLIST.ORG
> Subject: Stoopid Parenthesis
>
> **
>
> I forget how to force extra Parenthesis when I need them in the
> Qualification area on a table field...
>
> I would like it to look like this:
>
> ( 'Survey Type' = $Survey Type$) AND (( 'Create Date' >= $Result From
> Date$) AND ( 'Create Date' < $Result To Date$))
>
> But when I save the form, Remedy changes it to:
>
> ( 'Survey Type' = $Survey Type$) AND ( 'Create Date' >= $Result From
> Date$) AND ( 'Create Date' < $Result To Date$)
>
> ARS 7.0.1 Patch 007 (admin)
> Server 7.0.1 Patch 003
> Windows 2003
>
> Lisa Kemes
> AR System Developer
> Tyco Electronics
> 717-810-2408 tel
> 717-810-2124 fax
> [EMAIL PROTECTED]
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___

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

Re: Stoopid Parenthesis

[Gary Opela (Corporate)]

Why do you need the extra parenthesis? Remedy is removing them because they are 
not necessary, since you are using all AND statements. If it is just for 
readability, then I'm not sure how you would keep them.

However, if you are setting a field to that, and trying to use 
EXTERNAL($FIELD$), then that's a different story (although I'm still not sure 
you need the extra parens).

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kemes, Lisa
Sent: Friday, May 30, 2008 8:36 AM
To: arslist@ARSLIST.ORG
Subject: Stoopid Parenthesis


I forget how to force extra Parenthesis when I need them in the Qualification 
area on a table field...

I would like it to look like this:

( 'Survey Type' = $Survey Type$) AND (( 'Create Date' >= $Result From Date$) 
AND ( 'Create Date' < $Result To Date$))

But when I save the form, Remedy changes it to:

( 'Survey Type' = $Survey Type$) AND ( 'Create Date' >= $Result From Date$) AND 
( 'Create Date' < $Result To Date$)

ARS 7.0.1 Patch 007 (admin)
Server 7.0.1 Patch 003
Windows 2003

Lisa Kemes
AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[EMAIL PROTECTED]

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

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

Stoopid Parenthesis

[Kemes, Lisa]

I forget how to force extra Parenthesis when I need them in the
Qualification area on a table field...

I would like it to look like this:

( 'Survey Type' = $Survey Type$) AND (( 'Create Date' >= $Result From
Date$) AND ( 'Create Date' < $Result To Date$))

But when I save the form, Remedy changes it to:

( 'Survey Type' = $Survey Type$) AND ( 'Create Date' >= $Result From
Date$) AND ( 'Create Date' < $Result To Date$)

ARS 7.0.1 Patch 007 (admin)
Server 7.0.1 Patch 003
Windows 2003

Lisa Kemes 
AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[EMAIL PROTECTED]



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

Re: Question: Active Link - Checking Table - ITSM 7

[Steven Iocco]

What Ben mentioned is a good option.  You could also run a guide looping on the 
'z2TH Associations' table to give you a $LASTCOUNT$ number and as mentioned 
below, build your workflow on that result.
Steve
 


Date: Fri, 30 May 2008 09:13:32 -0400From: [EMAIL PROTECTED]: Re: Question: 
Active Link - Checking Table - ITSM 7To: [EMAIL PROTECTED] 

Off the top of my head, I think that you do a direct sql that would return the 
same results that the table would and then do a set field command using the 
value of lastcount.  I think that would give you a number and you can build 
workflow to check if the value is greater than 0.
 
Ben CantatoreRemedy Manager(914) 457-6209
 
Emerging Health IT3 Odell PlazaYonkers, New York 10701>>> [EMAIL PROTECTED] 
05/30/08 8:44 AM >>>
I'm trying to check to see if a table has any rows in it, but i'm nothaving 
much luck.I have tried to check for the table NOT being NULL and I have 
checkfor a column NOT being NULL, both do not work.I'm looking to see if the 
Relationship table is NOT NULL - so I tried:'z2TH Associations' != $NULL$(this 
is the table name)I also tried:'z2TF AssociationType' != $NULL$(this is a 
column name)Both of these do not work.However, if I remove this qualification 
my workflow works.Any ideas why I can't check to see if there are any rows in 
the 
table?THANKS!___UNSUBSCRIBE
 or access ARSlist Archives at www.arslist.orgPlatinum Sponsor: 
www.rmsportal.com ARSlist: "Where the Answers Are"__Platinum Sponsor: 
www.rmsportal.com ARSlist: "Where the Answers Are" html___ 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Question: Active Link - Checking Table - ITSM 7

[Carey Matthew Black]

T. Dee,

Is the 'z2TH Associations' field a required field? ( Or could it
happen to be NULL for the currently selected row in the table?) In a
Run If a column name value will only evaluate the currently selected
record in the table field and not the array of values that are in all
rows in the table field for that column.

You might also consider using the COLCOUNT() function to set a temp
Integer field using  the column field, or the table field. You can see
more details on this function in the docs. Then in a later Active Link
check the Integer fields value.

HTH

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Fri, May 30, 2008 at 8:44 AM, T. Dee <[EMAIL PROTECTED]> wrote:
> I'm trying to check to see if a table has any rows in it, but i'm not
> having much luck.
>
> I have tried to check for the table NOT being NULL and I have check
> for a column NOT being NULL, both do not work.
>
> I'm looking to see if the Relationship table is NOT NULL - so I tried:
>
> 'z2TH Associations' != $NULL$
> (this is the table name)
>
> I also tried:
>
> 'z2TF AssociationType' != $NULL$
> (this is a column name)
>
> Both of these do not work.
>
> However, if I remove this qualification my workflow works.
>
> Any ideas why I can't check to see if there are any rows in the table?
>
> THANKS!
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

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

Re: Question: Active Link - Checking Table - ITSM 7

[Benedetto Cantatore]

Off the top of my head, I think that you do a direct sql that would
return the same results that the table would and then do a set field
command using the value of lastcount.  I think that would give you a
number and you can build workflow to check if the value is greater than
0.
 
Ben Cantatore
Remedy Manager
(914) 457-6209
 
Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701


>>> [EMAIL PROTECTED] 05/30/08 8:44 AM >>>

I'm trying to check to see if a table has any rows in it, but i'm not
having much luck.

I have tried to check for the table NOT being NULL and I have check
for a column NOT being NULL, both do not work.

I'm looking to see if the Relationship table is NOT NULL - so I tried:

'z2TH Associations' != $NULL$
(this is the table name)

I also tried:

'z2TF AssociationType' != $NULL$
(this is a column name)

Both of these do not work.

However, if I remove this qualification my workflow works.

Any ideas why I can't check to see if there are any rows in the table?

THANKS!

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


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

Question: Active Link - Checking Table - ITSM 7

[T. Dee]

I'm trying to check to see if a table has any rows in it, but i'm not
having much luck.

I have tried to check for the table NOT being NULL and I have check
for a column NOT being NULL, both do not work.

I'm looking to see if the Relationship table is NOT NULL - so I tried:

'z2TH Associations' != $NULL$
(this is the table name)

I also tried:

'z2TF AssociationType' != $NULL$
(this is a column name)

Both of these do not work.

However, if I remove this qualification my workflow works.

Any ideas why I can't check to see if there are any rows in the table?

THANKS!

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