cross is now running Foswiki 2.1.3 Beta 1. Please open a task for any issues. Happy Holidays!

Item8232: Macros within ACTIONSEARCH not possible due to SpreadSheetPlugin processing order.

Priority: Normal
Current State: Closed
Released In: 2.0.0
Target Release: major
Applies To: Extension
Component: SpreadSheetPlugin
Reported By: HolgerHain
Waiting For:
Last Change By: GeorgeClark
I tried to format the output of an actionsearch. I both tried the %IF% and the %CALC% macro to display text in a custom color, like it is possible for the formated output of a normal search.

-- HolgerHain - 07 Aug 2009

I tracked down the real problem. All variables such as $who and $due ... are not accesible to i.e. %CALC%. So a formula such as %CALC{$SET(my_var,$who)$GET(my_var)}% will work properly, but any other operation such as $FIND or $IF does not work. -- Sorry, that was my fault. I forgot to use "$percnt" instead of "%" (to figure out any problems with the %CALC%-syntax).

But anyway there must be some problem with getting the variables with %CALC%. To get actions that are orphaned (there is who="") it is not possible to use a regex that searches for an empty string, so the idea was to use %CALC% to format the output. But the test
 format="$percntCALC{$SET( my_var , $who )}$percnt $percntCALC{$SEARCH( Main , $GET( my_var ) )}$percnt"
it just get ")" as output.

I get basically the same with an $IF searching for a specific $due-value (as reported some days ago) to change the text-color.

-- HolgerHain - 11 Aug 2009

This is an old problem with CALC, because of the way it works out of sequence with everything else. Not an actiontracker problem. Re-assigning to the SpreadSheetPlugin.

-- CrawfordCurrie - 24 Jan 2011

I suspect that this is fixed by addition of the %CALCULATE macro, which is processes as a regular registered tag.

-- GeorgeClark - 04 Jan 2015

ItemTemplate edit

Summary Macros within ACTIONSEARCH not possible due to SpreadSheetPlugin processing order.
ReportedBy HolgerHain
Codebase 1.0.5
SVN Range Foswiki-1.0.0, Thu, 08 Jan 2009, build 1878
AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState Closed
TargetRelease major
ReleasedIn 2.0.0
Topic revision: r8 - 05 Jul 2015, GeorgeClark - This page was cached on 01 Jan 2017 - 11:59.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License