I dont think Jim meant placing your SQL in the table field. He probably meant to tell you to run a direct sql through an AL to return the count of records using an equivalent condition that the table field uses, to an integer field... There is no way you can embed a sql statement in a table field otherwise... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.
----- Original Message ---- From: "Kemes, Lisa" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, January 3, 2007 6:40:26 PM Subject: Re: COLCOUNT Function Where would you place this SQL code when you are in the Table Field on the form (in Remedy Admin tool)? Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bruce Sent: Tuesday, January 02, 2007 10:15 AM To: [email protected] Subject: Re: COLCOUNT Function Hi Lisa, a direct SQL count should do the trick, unless you are resisting this idea. Example: select count(*) from your-table where particular-column = 'X' Jim Bruce TELUS Mobility 416-279-3455 On Fri, 29 Dec 2006 12:11:54 -0500, Kemes, Lisa <[EMAIL PROTECTED]> wrote: >Listers, > >Would I be able to use the COLCOUNT function to count only the rows >that have a specific value? (I do not want a count of all the rows, >just the rows that have "X" in a particular field). > >Or will I just have to create a temp field and count the rows in a >table loop? > >Thanks in advance! > >Lisa > >_______________________________________________________________________ >____ ____ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >ARSlist:"Where the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
