Re: COLCOUNT Function

2007-01-04 Thread Kemes, Lisa
m: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, January 04, 2007 9:41 AM To: arslist@ARSLIST.ORG Subject: Re: COLCOUNT Function Lisa, Have you tried the COLCOUNT(column_name) in a Set fields action that fires on table refres

Re: COLCOUNT Function

2007-01-04 Thread Reiser, John J
f Of Kemes, Lisa Sent: Wednesday, January 03, 2007 6:40 PM To: arslist@ARSLIST.ORG 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(ARSLis

Re: COLCOUNT Function

2007-01-03 Thread Joe DeSouza
field otherwise... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: "Kemes, Lisa" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 6:40:26 PM Subject: Re: COLCOUNT Function Where would you pla

Re: COLCOUNT Function

2007-01-03 Thread Kemes, Lisa
@ARSLIST.ORG 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, Li

Re: COLCOUNT Function

2007-01-02 Thread Jim Bruce
;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

Re: COLCOUNT Function

2007-01-02 Thread L. J. Head
Well yeathere's always the how...:) _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Saturday, December 30, 2006 3:30 PM To: arslist@ARSLIST.ORG Subject: Re: COLCOUNT Function ** To add to L. J., use EXTERNAL ke

Re: COLCOUNT Function

2006-12-31 Thread Peter Romain
DeSouza Sent: 30 December 2006 22:30 To: arslist@ARSLIST.ORG Subject: Re: COLCOUNT Function To add to L. J., use EXTERNAL keyword to produce the results that L. J. described. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: L. J.

Re: COLCOUNT Function

2006-12-31 Thread Joe DeSouza
PM Subject: Re: COLCOUNT Function ** Either use a table loopor change the qualification of the table to display only the records that you want to count From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, December 29, 2006

Re: COLCOUNT Function

2006-12-29 Thread Reiser, John J
ailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, December 29, 2006 12:12 PM To: arslist@ARSLIST.ORG Subject: COLCOUNT Function ** 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

Re: COLCOUNT Function

2006-12-29 Thread L. J. Head
@ARSLIST.ORG Subject: COLCOUNT Function ** 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 coun

COLCOUNT Function

2006-12-29 Thread Kemes, Lisa
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?