• When documents in a view are not categorised - @DbColumn and @Trim

    By Bill Whittakers 2 decades ago

    Hi Jason

    Thank you for your so very useful project. One thing, I have found that if any documents in a view are not categorised then the @DbColumn in the Restrict to Category does not return any values. When I put @Trim around it then it works.

    Thanks again

    Bill



    REM { categories := @DbColumn( ""; ""; "Issues-Actionee"; 1 ); };

    categories := @Trim( @DbColumn( ""; ""; "Issues-Actionee"; 1 ) );

    optionList := @If( categories = "" ; "" ; @Transform( categories ; "n"; "" + n + "" ) );

    @Implode( optionList; "" )