Re: Menu on same field

[Joel D Sender]

After checking the way-back machine; the answer is to set the menu to search 
the field to which it is attached.

Because menus are natively distinct, you’ll get one listing for each name, and 
new records are automatically added to the menu.

HTH,

Joel

Joel Sender  *   jdsen...@earthlink.net



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Thursday, October 5, 2017 12:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: Menu on same field



**

Hi,

Search menus are natively distinct, so there is no need to use Direct SQL.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se




October 4, 2017 11:40 PM, "Brittain, Mark" <mbritt...@navisite.com 
<mailto:%22Brittain,%20mark%22%20%3cmbritt...@navisite.com%3e> > wrote:

**

Hi All

This is one of those case where I did something years ago and can’t remember 
how I did it. Hoping someone can assist.

Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, 
Joe, Bob, Mike, Joe and Bill.

On the same field I want have a menu that searches on the First Name field and 
displays Bill, Bob, Joe, Mike.

If I create a new record I could use the existing names or type in a new one. 
If the new record was for Mary, after submit, the menu would contain Bill, Bob, 
Joe, Mary, Mike

I just know this is simple enough to do, but it was about 10 years last time I 
did it. Any suggestions would be greatly appreciated.

ARS 9.1

Thanks

Mark

Mark Brittain | Senior Systems Engineer | 315.634.9337

125 Elwood Davis Road | Syracuse NY 13212

new_spectrum

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Menu on same field

[Misi Mladoniczky]

Hi,

Search menus are natively distinct, so there is no need to use Direct SQL.

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
October 4, 2017 11:40 PM, "Brittain, Mark"  wrote:
**
Hi All 

This is one of those case where I did something years ago and can’t 
remember how I did it. Hoping someone can assist. 

Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, 
Mike, Joe, Bob, Mike, Joe and Bill. 

On the same field I want have a menu that searches on the First Name 
field and displays Bill, Bob, Joe, Mike. 

If I create a new record I could use the existing names or type in a 
new one. If the new record was for Mary, after submit, the menu would contain 
Bill, Bob, Joe, Mary, Mike 

I just know this is simple enough to do, but it was about 10 years last 
time I did it. Any suggestions would be greatly appreciated. 

ARS 9.1 

Thanks 

Mark 

Mark Brittain  | Senior Systems Engineer | 315.634.9337 

125 Elwood Davis Road | Syracuse NY 13212 

  _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Menu on same field

[Grooms, Frederick W]

Personally I would use an SQL type menu
Select DISTINCT ...

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Wednesday, October 04, 2017 4:39 PM
To: arslist@ARSLIST.ORG
Subject: Menu on same field

**
Hi All

This is one of those case where I did something years ago and can't remember 
how I did it. Hoping someone can assist.

Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, 
Joe, Bob, Mike, Joe and Bill.

On the same field I want have a menu that searches on the First Name field and 
displays Bill, Bob, Joe, Mike.

If I create a new record I could use the existing names or type in a new one. 
If the new record was for Mary, after submit, the menu would contain Bill, Bob, 
Joe, Mary, Mike

I just know this is simple enough to do, but it was about 10 years last time I 
did it. Any suggestions would be greatly appreciated.

ARS 9.1

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]

_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Menu on same field

[Dale Jones]

Can you do a sql menu with distinct

Take Care
Dale Jones
919-523-6034




Take Care
Dale Jones
919-523-6034

> On Oct 4, 2017, at 4:39 PM, Brittain, Mark  wrote:
> 
> **
> Hi All
>  
> This is one of those case where I did something years ago and can’t remember 
> how I did it. Hoping someone can assist.
>  
> Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, 
> Joe, Bob, Mike, Joe and Bill.
>  
> On the same field I want have a menu that searches on the First Name field 
> and displays Bill, Bob, Joe, Mike.
>  
> If I create a new record I could use the existing names or type in a new one. 
> If the new record was for Mary, after submit, the menu would contain Bill, 
> Bob, Joe, Mary, Mike
>  
> I just know this is simple enough to do, but it was about 10 years last time 
> I did it. Any suggestions would be greatly appreciated. 
>  
> ARS 9.1
>  
> Thanks
> Mark
>  
> Mark Brittain  | Senior Systems Engineer | 315.634.9337
> 125 Elwood Davis Road | Syracuse NY 13212
> 
>  
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Menu on same field

[Brittain, Mark]

Hi All

This is one of those case where I did something years ago and can't remember 
how I did it. Hoping someone can assist.

Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, 
Joe, Bob, Mike, Joe and Bill.

On the same field I want have a menu that searches on the First Name field and 
displays Bill, Bob, Joe, Mike.

If I create a new record I could use the existing names or type in a new one. 
If the new record was for Mary, after submit, the menu would contain Bill, Bob, 
Joe, Mary, Mike

I just know this is simple enough to do, but it was about 10 years last time I 
did it. Any suggestions would be greatly appreciated.

ARS 9.1

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"