How can I use select values already in a topic when expecting them in a select definition for EDITTABLE?

The EditTablePlugin allows select values when directly defined in the format and basically also macros if escaped like:

%<nop>X%

So I tried a search at this point which doesn't work out as I expected although it generally works if put directly into the topic:

%SEARCH{ "--find--" type="literal" web="%USERSWEB%" topic="WorkCountry" scope="text" nonoise="on" multiple="on" format="$pattern(.*?( [^*].*? ).*)," }%

The relevant part of the EDITTABLE definition was:

| select, 1, %<nop>SEARCH{ "--find--" type="literal" web="Main" topic="WorkCountry" scope="text" nonoise="on" multiple="on" format="$pattern(.*?( [^*].*? ).*)," }% |

But resulted in:

• screenshot of the "failing" search:
  

Are there maybe other known ways to do that except of putting all values directly into the select definition? That'll be pretty valuable I guess and could be a good tip too.

-- IngoKappler - 23 Jul 2009

It seems that EDITTABLE is being run before the SEARCH. You can work-around that by using a CALC, since the SpreadsheetPlugin is usually set to run before EDITTABLE.

E.g., this works:

%CALC{$SET(myoptions,%SEARCH{...}%)}%
%EDITTABLE{format="| select,3,,%CALC{$GET(myoptions)}% |"}%

It makes your markup marginally easier to read too, instead having a long EDITTABLE line.

-- SeanMorgan - 29 Jul 2009