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 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" >
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

