Re: "distinct" search on a table field

[Halstead, Robert]

**

would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name?

 

Bob Halstead

 

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Monday, October 23, 2006 1:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: "distinct" search on a table field

** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT
in the SQL statement. Then use that View form in your table field.

On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote:

**

I was wondering if it's possible to do a "distinct" search on a table qualification.  Distinct meaning SQL's "distinct" keyword.  I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results.  Is there a search keyword I can use to do this?

 

Robert Halstead

__20060125_______________________This posting was submitted with HTML in it___

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___