John, You could do something similar to this with the Menu:
Create a regular form (DUN:HPD:INC:IncAppStatus) with the following fields in addition to the standard fields: Inc Status App Status Status – Field change attributes to have values of enabled and disabled Input the following data into the form: INC Status APP Status In Progress Approve In Progress Scheduled In Progress BreakFix Pending Awaiting rel Resolved Go Live Create a menu Refresh – On Open Menu Type – Search Form Name – DUN:HPD:INC:IncAppStatus Label Fields – App Status Value Field – App Status Sort On Label – Checked Qualification – ‘Status’ = Enabled And ‘Inc Status’ = $7$ Let me know if this helps. Kelly Gatewood Senior Solutions Architect IT Prophets Cell 615-830-5078 www.itprophets.com<http://www.itprophets.com> From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Wednesday, July 08, 2009 8:51 AM To: arslist@ARSLIST.ORG Subject: Re: Selection Menu Question Hi Yes, search based on selection of the INC status is what I was looking for. The results, I would want to become available in a drop down, kind of like the Operational tiers, when you select first tier the second becomes available. John Joe DeSouza <joe_rem...@yahoo.com> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 07/08/2009 02:10 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Selection Menu Question ** While I think I more or less understand what you want to do, what exactly do you mean by 'filter out attributes of a selection field' ?? Are you looking to perform a search Based on the selection of the INC Status? So if 'In Progress' is selected do you want the system to return results that contain records that have the App Status of 'Approoved', 'Scheduled' and 'BreakFix'?? If so depending on where you want that search result to be returned to, (Results List or Table Field) I do not think it is really hard to build an external qualification that does it? Wouldn't you be looking at creating an external qualificaton that could be used in the table field or results list that would build the qualication against the App Status on selection of the INC Status? I think its as simple as that.. Or have I understood what you want to do wrong? Sorry more questions than answers - so if I have understood you wrong please try and explain what exactly you are aiming for.. Cheers Joe ________________________________ From: John Kelley <john.kel...@dunkinbrands.com> To: arslist@ARSLIST.ORG Sent: Tuesday, July 7, 2009 4:14:41 PM Subject: Selection Menu Question Hi List Is it possible to setup an Active link to filter out attributes of a selection field drop down? Heres the story. I currently have on my Helpdesk form the INC Status field that has the normal status' and an APP Status field which has other Process status' for example. Approve, Scheduled, Awaiting release, Breakfix, Go-live, No-Go etc. I also have another form with APP Status and INC Status. I save entries of APP status with a particular INC status. For Ex. APP Status INC Status Approve In Progress Scheduled In Progress BreakFix In Progress Awaiting rel Pending Go Live Resolved Now I'm trying to get the APP status on the Helpdesk form to filter out what matches to the INC status that is selected. Basically I should be able to select INC Status of "In Progress" and It should show me three items. I think the selection field is the problem, I may need a character field instead and then map a menu to it. Or continue with my AL somehow.... Any ideas. Thanks John ARS 7.1 patch 6 Apps 7.003 patch6 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.