SID-02092: CALC inside nested search that is inside calc

Status:	Answered	TWiki version:	6.0.1	Perl version:
Category:	CategorySearch	Server OS:	Ubuntu 12.10	Last update:	10 years ago

Hello,

I manage to get this far. But, the CALC inside the nested SEARCH is not giving a proper result.

the query

%CALCULATE{$LISTJOIN($n, $LISTEACH(|$index.|[[Name.$item][$NOP(%)FORMFIELD{"Title" topic="Name.$item"}$NOP(%)]] |   $NOP(%)SEARCH{"Belongsto='$item' AND State='Open' AND Ewotype='Sale'" type="query" web="Activity" sort="formfield(Priority)" reverse="off" nonoise="on" separator="%BR%" format="$percntSEARCH{$quotBelongsto=$aquot$topic$aquot AND Topicclassification=$aquotActivity$aquot AND NOT State=$aquotClosed$aquot$quot type=$quotquery$quot web=$quotActivity$quot nonoise=$quoton$quot  separator=$quot,$quot
format=$quot$dollarpercntCALC{$LISTSIZE($dollartopic)}$dollarpercnt$quot }$percnt"}$NOP(%) |,$LISTSORT($LISTUNIQUE(%ACTIVE_NAME%))))}%

result

expected result

I have "escaped" everything that need to be escaped.

Anybody with an insight is greatly appreciated.

Thanks

-- Michael Severo - 2015-07-22

Discussion and Answer

I have not studied your complex code, but it looks like $LISTSIZE() is not escaped, thus gets handled by the outer CALCULATE. Try $dollarLISTSIZE() if you want to delay it for the innermost CALC.

-- Peter Thoeny - 2015-07-23

Hi Peter,

I 've tried your suggestion but it still giving me unwanted result.

-- Michael Severo - 2015-07-23

solved

The "comma" seems to break the query - notices that through trial and error.

I did 3 queries instead

1. Search and SET hashes. // not in the table. with these I could use/combine other spreadsheet variables.
2. Search and remove duplicates in result. // First col
3. Repeat the first row search with a nested query the resulted to the topics the belong the results in first col. // Second col
4. Repeat the Second col search and a result to get the hashes that matches the result from the second col. // Next col

and so on...

With that search above resulted in the datas being align horizontally and vertically accordingly and easy to manipulate . For now these will work.

e.g.

-- Michael Severo - 2015-07-25

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.