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 <[email protected]>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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
