field default value

[gianfranco.pietraforte]

DaDaBIK version 8.1-Lerici enterprise
PHP Version: 5.6.3
mysql version: 5.6.36-82.1-log
Web server: Microsoft-IIS/8.5
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36

---

Hi,
I need to specify a default value through a db query using the SQL:SELECT syntax.
The select has a where condition that depend on the value stored into the "master_table_where_value".

Something like:
"SQL:SELECT the_default_value FROM any_table WHERE id=dadabik_var master_table_where_value dadabik_var"
The above query doesn't work.

Any help?

 

[eugenio]

Hello Gianfranco,
the syntax you are using is for the HTML templates, the default value doesn't support variables.

We are thinking to add in the next version of DaDaBIK a custom php function that you can use to fill the default value; this would probably solve your problem.


Best,