Mike, for that to work you have to make sure that your table field is refreshed
and the table field has the right options in its advanced display such as
retain selection or select first request etc.. with no selection you would get
a null return.
When you have retain your selection on refresh, if the selection that was
previously chosen has been deleted or removed due to change on that entry, then
there will be no selection causing a null return again..
Joe
----- Original Message ----
From: Mike White <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Tuesday, December 19, 2006 3:35:45 PM
Subject: Re: Table Fields
I missed something. What's wrong with 'Table Field' = $NULL$? I'm not
sure how you're using it, though. I just added a table field and button to
a test form, and a new AL, triggered by the button, with a Run If 'Table
Field' = $NULL$. If action displays a message
It's null
and Else action displays a message
It's not null, instead it's value is $Table Field$
I tested both scenarios and it worked fine. I'm running ARS 6.0.1, patch
1497.
The "value" of 'Table Field" (the name of your table field) is the current
row number. It's null if there are no rows in the table field. It's 0 if
there are rows, but none has been selected. It's > 0 if a row is selected.
You'll want to make sure that you refreshed the table field before testing
it, and that no other workflow or user action cleared the table field.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Kemes, Lisa"
<[EMAIL PROTECTED] To: arslist@ARSLIST.ORG
RONICS.COM> cc:
Sent by: "Action Subject: Re: Table Fields
Request System
discussion
list(ARSList)"
<arslist@ARSLIST.ORG>
12/19/2006 15:19
Please respond to
arslist
**
Can you use $LASTCOUNT$ on a table field? Or is it just to see how many
rows were returned when doing a search on a form.
I have ARS 6.3 and Remedy user 6.3.
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Aaron Keller
Sent: Tuesday, December 19, 2006 3:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Table Fields
**
first refresh the table, and then look to see if $LASTCOUNT$ = 0
-Aaron
* Email: [EMAIL PROTECTED]
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, December 19, 2006 2:59 PM
To: arslist@ARSLIST.ORG
Subject: Table Fields
Hello Listers!
How can you test to see if there is nothing in a Table Field?
I tried 'Table Field' = $NULL$, but nothing happens.
I want to create workflow if a Table Field is NULL (no rows)
Let me know if anyone has the answer!
Thanks!
Lisa
SunCom is the wireless company that's committed to doing things
differently.
Things we want you to know.
This e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication may contain material protected by the
attorney-client privilege. If you are not the intended recipient or the
person responsible for delivering the e-mail to the intended recipient, be
advised that you have received this e-mail in error and that any use,
dissemination, forwarding, printing or copying of this e-mail is strictly
prohibited.
__20060125_______________________This posting was submitted with HTML in
it___ __20060125_______________________This posting was submitted with HTML
in it___
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
