Please complete the details below then remove this line:
Volt MX Version: 9.5.55
Operating System: Win11
Database (if appropriate): Microsoft SQL Server
Server: Tomcat
Problem/Query:
Como usar uma Custom Query? Criei o parametro Rodizio e tento usar ele na Custom Query, mas não funciona! Eu estou usando o coringa da seguinte maneira:
select * from Atendentes where Rodizio = ${Rodizio}
Hi @cristech1970, thank you for your question. I have included a link to the custom query documentation below. According to the documentation, the queries must be in the following syntax if you are adding input parameters:
To include any input parameters in statement, mark them with @. For example, @inputparam1. Here is the sample code for it.
{
Select * from VOLTMXUNITTESTDATABASE.products where LASTUPDATETIME > @timestamp and SOFTDELETEFLAG = @boolean limit 100;
}
Are you able to test using this syntax?
Please let us know if you receive any errors in the console after reviewing the documentation and testing with the recommended syntax, and we will be happy to review your issue further. Thank you!
Olá, obrigado por sua ajuda, deu certo sim. Eu não tinha encontrado essa documentação. Já salvei o link para futuras consultas.
@cristech1970 Thank you for your update. I am glad that I was able to assist you! Thank you for participating in our community, and have a great day!