'Table Field' stores a value of the row number which is selected. If none is selected, It will return 0 doesn't matter if there are any rows in table or not So I think, You need to refresh and use Last Count to see if there are any records in the table or not
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, December 19, 2006 3:53 PM To: [email protected] Subject: Re: Table Fields ** 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: [email protected] 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: [email protected] RONICS.COM> cc: Sent by: "Action Subject: Re: Table Fields Request System discussion list(ARSList)" <[email protected]> &nbs p; 12/19/2006 15:19 Please respond to arslist &n bsp; &n bsp; ** 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: [email protected] 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: [email protected] 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 <http://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 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
