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 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"

