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'
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
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
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
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
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$),
** '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
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:
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
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
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
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
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,
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.
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
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
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!
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
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
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.
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
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
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
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
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:
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
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
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
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()
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
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 server_name -s
Nothing happens
I have also tried add -p password and -portnum but nothing.
Using aradmin 6.3 patch 24 from a
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
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
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,
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
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
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
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
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
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
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)
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
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
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
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] mailto:[EMAIL PROTECTED]
Ph#1: 214-567-8874
Ph#2: 325-450-5076
Morrison, David A. 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 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
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
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)
arslist@ARSLIST.ORG
05/30/2008 11:32 AM
Please
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
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
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
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
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
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
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.
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
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
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
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
60 matches
Mail list logo
