Reading parameters - checkbox (SQL)

Ina Colman

I would like to read the value of a checkbox from the property tab of the businesspartner data. (Optimizer)



Type = SQL



I tried the following, but it throws an error:



select '[%G;136;2;8]'





The only rule I found in the coresuite manual was for a combobox, but no syntax found to read the value of a checkbox



[size=3]To read the currency (e.g. CHF) from a sales document [%G;63;;;K][/size]



Kind regards,

Ina

Anders Olsson

Hello Ina,



Unfortunately this is a limitation in coresuite framework. The parameter replacement function does not support the CheckBox column type in the matrix object. As a workaround you will have to do this in a C#/VB rule.



I have created a development request for this to be supported. Please refer to CSF-210 (coresuite framework) in future changelogs.