Didn't see Thad's answer before I posted mine. Thad's had the same idea as me,
it should work.
Thad K Esser <[EMAIL PROTECTED]> wrote: **
I think the direct answer is No, not just with table fields alone.
Depending on how goofy (technical term) you wanted to get, you could put a
filter on the table's underlying form, fire it on submit/modify, and push the
field that you want to use as the Distinct value to a new form that only held
the distinct values (update existing on match, create new if no match). Then
build your table on that new form. Not necessarily pretty, but it keeps it all
in Remedy.
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard Bach
"L. J. Head" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]>
05/24/2007 12:14 PM Please respond to
[email protected]
To
[email protected] cc
Subject
Re: Select Distinct in Table Field?
Yea....that's why I stated 'without leaving remedy'...I know how to do the
DB View...I was looking for the ability without doing that
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Thursday, May 24, 2007 12:49 PM
To: [email protected]
Subject: RES: Select Distinct in Table Field?
You could build a SQL view and then a View Form on it. Then you could build
a table field over that view form.
HTH,
Rogerio Bronzoni Aguiar
[EMAIL PROTECTED]
-----Mensagem original-----
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de Kemes, Lisa Enviada em:
quinta-feira, 24 de maio de 2007 15:38
Para: [email protected]
Assunto: Re: Select Distinct in Table Field?
The only way you can do this is by a SQL call within the Active Link or
Filter.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Thursday, May 24, 2007 2:33 PM
To: [email protected]
Subject: Select Distinct in Table Field?
Is it possible to do a Distinct selection within a table field without
leaving remedy?
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
***IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely for
the entity or individual to whom it is addressed. If you are not the intended
recipient, you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message is strictly prohibited.
Nothing in this email, including any attachment, is intended to be a legally
binding signature.***
__20060125_______________________This posting was submitted with HTML in it___
---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
