SpagoBI - Uso de caracteres especiais como parâmetros (LOV)

Caso seja necessário o uso de caracteres especiais nos parâmetros dos LOV, como por exemplo um LOV para meses: Janeiro, Fevereiro, MARÇO, etc... e quando o valor MARÇO for selecionado, seu SpagoBI deixa de funcionar, siga as dicas abaixo:



the url string pattern is blocked by the spagobi's validator. You can find the pattern used by spagobi to validate the parameter's value in file SpagoBI/WEBINF/conf/tools/datasources/validation.xml In particular this is the block of configuration that specify the pattern... <field label="URL_CONNECTION" name="URL_CONNECTION"> <validator arg0="^([a-zA-Z0-9.:@\s\-\_\(\)\\\/])*$" validatorname="REGEXP"> <validator arg0="50" validatorname="MAXLENGTH"> </validator></validator></field> as you can see char ';' and '=' are not included in the pattern. For this reason your url parameter value is considered not valid. You can modify this block of configuration in order to include also ';' &amp; '=' chars in the pattern and then restart the server. With this work around you should be able to save your db url.

Contributed by Andrea Gioia (SpagoBI Team)