To add string parameter in our report : String Parameter $P{P1}
To add list parameter : $X{IN,sql_column_name,P1}
select * from table where name = ${P} select * from table where $X{IN,column_name,list}
To add string parameter in our report : String Parameter $P{P1}
To add list parameter : $X{IN,sql_column_name,P1}
select * from table where name = ${P} select * from table where $X{IN,column_name,list}
Sql query in Odoo model
Use this command bellow to find a pattern in the arborescence. https://stackoverflow.com/questions/16956810/how-do-i-find-all-files-containing-specific-text-on-linux
Odoo 9 community doesn't come with autoban security. Fail2ban is an alternative to secure Odoo authentication. For more information concerning…
Exemple 1 : subtract 2 dates run the command. Exemple 2 : add or subtract days to a date…
This site uses Akismet to reduce spam. Learn how your comment data is processed.
defined parameter “vMnemonic” java.lang.String
SQL code:
WHERE $X{IN,INVDOSE.MNEMONIC,vMnemonic}
Error
Invalid type java.lang.String for parameter “vMnemonic” used in and IN clause;
can you tell me what type should I use for my parameter
Hello,
What’s your complete query ?