Thanks, Doug. Can you confirm this is supported in 8.x as well? I suspect it would be but I just want to be sure I'm not developing into a future problem...
Ray ________________________________ From: "Mueller, Doug" <doug_muel...@bmc.com> To: arslist@ARSLIST.ORG Sent: Wednesday, July 31, 2013 1:10 PM Subject: Re: Changing table query details via Active Link Raymond, I suggest you look into the EXTERNAL() clause that you can stick into the qualifier. It allows you to have part or all of the qualification defined dynamically by putting into a field and the EXTERNAL() says to include that into the qualification at runtime. Take a look at https://docs.bmc.com/docs/download/attachments/165478929/ARS_WorkFlowObjectsGuide_7604.pdf?version=1&modificationDate=1348736396000&api=v2 page 217 This is the 7.6.04 documentation and that page is the one that documents this capability. What you are attempting is a straight-forward operation that is fully supported for exactly the type of operation you are attempting. Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Gellenbeck Sent: Wednesday, July 31, 2013 1:00 PM To: arslist@ARSLIST.ORG Subject: Changing table query details via Active Link Hey, for the few of us out there who still custom-develop...remind an old dog of the programmatic way to alter a table query conditions via active link. Do you store the criteria in a hidden character field? (use 7.6.04, we haven't adopted 8.1 for a few more months) Use Case / Example: I display a list of change records in my custom change app and show all open records for a certain team. I provide a pulldown for the form user to change the view criteria to all open records with a change type of "Standard". Very different criteria. Can the query criteria be stored in a character field, then have one Active Link modify the contents of the character field then fire a refresh of the table so it uses the new criteria and, in turn, displays new results list in the table? I don't need to change columns and even if I did, I know how to hide/unhide those via AL (simple). I'm focused on the table's query criteria. My older/clunkier way is just to build 2 tables and hide/reveal the appropriate one, but it would be cleaner and lighter to just modify a single table's search criteria. It's just been so long since I've dealt with such a case that I don't remember if you can do it and prefer not to waste time experimenting if the list can help me avoid it. Thanks in advance to replies. Raymond H. Gellenbeck Manager | Business Service Management Sony Network Entertainment _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"