Item8708: Formatted search example broken

FormattedSearch#Search_with_conditional_output - I don't know if it is SEARCH, SpreadSheetPlugin or $percent that has broken it.

Setting to urgent until proven otherwise.

-- ArthurClemens - 14 Mar 2010

it is urgent - you can see a similar artifact in the age output in the Tasks web - its due to the paging, resultset, sorting extraction i've been doing - so setting to me

thankyou for the report tho - I can do with more tasks for any issues that anyone finds - as they indicate a missing unit test.

-- SvenDowideit - 15 Mar 2010

mmmm, ok, so I'll continue to assume its my search code, until i work out otherwise

| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::commonTagsHandler( TemporarySEARCHTestWebSEARCH.TestTopicSEARCH ) |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::CALC( TemporarySEARCHTestWebSEARCH.TestTopicSEARCH ) |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( $SET1(weekold, $TIMEADD2($TIME3(3), -7, day2)1) ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: SET( weekold, $TIMEADD2($TIME3(3), -7, day2) ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: TIMEADD( $TIME3(3), -7, day ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: TIME(  ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: TIME(  ) returns: 1268613183 |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: TIMEADD( 1268613183, -7, day ) returns: 1268008383 |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: SET( weekold, 1268008383 ) returns:  |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN(  ) returns:  |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( $IF1(00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[OkBTopic]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar;1) ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: IF( 00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[OkBTopic]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar; ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: GET( weekold ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: GET( weekold ) returns: 1268008383 |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: IF( 00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[OkBTopic]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar; ) returns: ERROR: syntax error, near "003303(" |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( ERROR: syntax error, near "003303(" ) returns: ERROR: syntax error, near "003303(" |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( $IF1(00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[OkTopic]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar;1) ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: IF( 00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[OkTopic]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar; ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: GET( weekold ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: GET( weekold ) returns: 1268008383 |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: IF( 00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[OkTopic]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar; ) returns: ERROR: syntax error, near "003303(" |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( ERROR: syntax error, near "003303(" ) returns: ERROR: syntax error, near "003303(" |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( $IF1(00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[WebPreferences]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar;1) ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: IF( 00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[WebPreferences]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar; ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: GET( weekold ) start |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: GET( weekold ) returns: 1268008383 |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: IF( 00:33:032(15 Mar 2010 - 00:332) < $GET2(weekold2), <nop>, &vbar; [[WebPreferences]] &vbar; TemporarySEARCHUsersWeb.WikiGuest &vbar; 15 Mar 2010 - 00:33 &vbar; 1 &vbar; ) returns: ERROR: syntax error, near "003303(" |
| 2010-03-15T00:33:03Z debug | - SpreadSheetPlugin::Calc::doFunc: MAIN( ERROR: syntax error, near "003303(" ) returns: ERROR: syntax error, near "003303(" |

yup, tis me - SSP's $TIME is being evaluated by the changed formatResult()

however_, this turns out to be a bug in 1.0 too - though more hidden.

%!REVINFO{format="$TIME}%

the $TIME should not be evaluated as they are inconsistent, undocumented, and will clash with SSP..

it appears that I commited the code change to the duplicate report Tasks/Item8709 so I will close this one and re-write the other for the 1.0 and 1.1 release notes.

-- SvenDowideit - 15 Mar 2010

Commenting is disabled while not logged in