User tool Query

Can following query be done via user tool? I want to check if there are any two same serial numbers in the database. Form name is asset and field name is serial # and database id = 536870917 ___ UNSUBSCRIBE or

Re: User tool Query

: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of sucheta lakhe Sent: Tuesday, September 16, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: User tool Query Can following query be done via user tool? I want to check if there are any two same serial numbers

Re: User tool Query

A way to do this via the User tool could be to do a search on the table w/ no criteria, select all the rows, then Tools--Reporting. Create a report with just the serial number. Sort and group upon Serial number. Then add a Statistic to Count serial number, computed on the serial number field.

Re: Different result from Set Field If and User Tool Query

@ARSLIST.ORG Subject: Re: Different result from Set Field If and User Tool Query Hi Marco, I experienced a similar thing under version 6.3 (multiple patch levels). Under an Active Link, LASTCOUNT always returned the result I'd expect, but under a Filter sometimes I would get the number

Different result from Set Field If and User Tool Query

Good Afternoon Listers, I have an issue that I've never come across before. I am using the following Set Field If Qualification in a Filter: ((( 'Task Status' != Completed) AND ( 'Task Status' != Cancelled) AND ( 'Task Status' != Not Required)) OR ( $zTmp_ForceNewTaskCreation$ = Yes)) AND

Re: Different result from Set Field If and User Tool Query

PROTECTED] Behalf Of Marco Rasile Sent: Wednesday, December 20, 2006 2:12 PM To: arslist@ARSLIST.ORG Subject: Different result from Set Field If and User Tool Query ** Good Afternoon Listers, I have an issue that I've never come across before. I am using the following Set Field If Qualification