Zugg Software :: View topic - [3.34]%mapquery() doesn't respect %mapfilter() state

GURU Joined: 23 Dec 2000 Posts: 4834 Location: USA

If there's a %mapfilter() in place, you have to include that filter in the %mapquery() SQL string as well. The two should be working hand in hand, I think.

Posted: Fri Nov 04, 2011 1:46 am

Actually, your suggestion would work quite well since %mapfilter() returns a subset or partition. Applying %mapquery() to that should not be a problem. The only problem I can see is the current implementation of %mapfilter(). It returns records just in time, so that may not sit well with the way %mapquery() works currently. The implementation of this idea is not trivial.
I am guessing that CMUD caches the result of the filter and uses that to process any request affected by the use of the function. However, with %mapquery() CMUD would go against the actual database and not the cache. For this to work the way you want, CMUD would have to maintain the cache in the database (a memory database, most likely) and apply that filter to that database. Certainly doable.