Re: "distinct" search on a table field

[Frank Caruso]

** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved.

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

**

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:arslist@ARSLIST.ORG] 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___

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