how would I do the SQL query? doesn't seem like I can
do it with the creation of the view form. Sorry, kindof dumb when it comes
to the view form. I haven't used it much at all.
Bob Halstead
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Monday, October 23, 2006 1:26 PM
To: [email protected]
Subject: Re: "distinct" search on a table field
On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote:
**__20060125_______________________This posting was submitted with HTML in it___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
** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso
Sent: Monday, October 23, 2006 1:21 PM
To: [email protected]
Subject: Re: "distinct" search on a table field
in the SQL statement. Then use that View form in your table field.
On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote:**__20060125_______________________This posting was submitted with HTML in it___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
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __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___
