ahh, I get it now. I create a database view then
attach the view form to that database view.
Bob Halstead
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Monday, October 23, 2006 1:51 PM
To: [email protected]
Subject: Re: "distinct" search on a table field
create view test_view as select DISTINCT col1,col2,col3 from view_name
Check out page 174 in the Basic Guide v6.3
On 10/23/06, Halstead, Robert <[EMAIL PROTECTED]> wrote:
**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
** 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.
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___
--
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___
