Kyle, Well...
BasicGuide-630.pdf Page: 539 and 540 covers the 'Entry IDs' value for a Open Window action. It might only work on the web. (The doc say that, however that would be most disappointing to find to be true.) It can be a comma separated list of values. On the other hand... You could stack up a string in a char field that is used as part of an EXTERNAL() operator as part of the Open Window qualification too. So your Guide would build a string like: '1'="000000000000001" OR '1'="000000000000002" OR '1'="000000000000006" .. (etc) Then the Open window would reference the field that you stacked that string into. I think that should work reasonably well. However I do know that the EXTERNAL() operator does have a limit of 2 or 4k characters. ( I think it was 2k. ) So if your users pick that many 15 digit Request ID values then you might need to switch to the "join" idea to overcome that limit. What I mean by the "Join idea" is to create a GUID for this "report run". Loop over the table field and PUSH each Request ID to a new record with that GUID as a flag for the report to use. Then build a join between the new record and the source form for the table field and do the report against the join where the selection condition is based on the single GUID value. Sure it is a long way around the barn, but it would scale farther than the 2k (or 4k) character limit in the EXTERNAL() operator. (and you would likely need/want something to delete those GUID flagged records at some point too.) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 3/28/07, Kyle Whitley <[EMAIL PROTECTED]> wrote:
Ok...I got AL guide working and it is opening up reports for each record I select in the table. That however is not exactly what I was looking for. I would like all of the records I select to open in the same report not different reports. Can you append values to a character field during a set fields action? Thanks Kyle Carey Matthew Black wrote: > Kyle, > > The only way to know what row the user has selected, or changed, or > .... would be via walking the table. Either the "old way" or as part > of an Active Link guide. (Depending on what your after.) I suspect > that you would want to get the list of "Entry ID's" (field 1 values) > from a hidden column in the table for the rows of interest and then > pass that list to the Window Open action in the 'Entry IDs' value ( or > "parameter" to the action. What should we call those "sub parts" of an > action that takes field references? :) in the Open Window action. > > However, if the list was to long, (and I have no idea what that length > would be, but I am sure it exists) then you might even do a Join > between a "junk form" and your form of interest. Have the Active Link > Guide do a Push for each Entry ID and then do the report from the join > with a GUID value you use to "mark" the set of records in the Join > with. > > And I think it could be even more complicated than that too. But I > hope that gets you a good start on your efforts. > > :) > > HTH< -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
