Lisa, If you have table chunking enabled to the best of my knowledge $LASTCOUNT$ would return the number of rows in the current chunk up to a max of the limit your chunk is set at. You might be better off using a direct sql to return the count of the query you are running on the table field to get the real count in this case.
And yes to answer your question $LASTCOUNT$ would return the integer that contains the count of table field in your current chunk. Rgds Joe ----- Original Message ---- From: "Kemes, Lisa" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, December 19, 2006 3:19:23 PM Subject: Re: Table Fields ** 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___ __________________________________________________ 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"
