I think a simple solution is to check any column in the table for a value. If col1 = $NULL$ or col1 != $NULL$
James On May 30, 2:00 pm, "T. Dee" <[EMAIL PROTECTED]> wrote: > 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 atwww.arslist.org > > > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > > __Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > > html___ > > > __Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > > html___ > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"- Hide > quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
