Many thanks. Will try shortly.
________________________________ From: "Longwing, Lj" <llongw...@usgs.gov> To: arslist@ARSLIST.ORG Sent: Wednesday, July 31, 2013 1:04 PM Subject: Re: Changing table query details via Active Link ** Ray, Build the Table Qual with EXTERNAL($FieldName$), then setup the char field with the qual you want via al, then refresh the table...it'll do what you need :) On Wed, Jul 31, 2013 at 2:00 PM, Ray Gellenbeck <raygellenb...@yahoo.com> wrote: 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" > _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"