Filtro utilizando "="
23/03/2016 10:42
[b]def[/b] findQuery = "from BltiLaunch as bl " + "where bl.bltiResourceLink.bltiContext.bltiToolConsumer.customer.customerId='${_customerId}'" [b]if[/b]( _toolConsumerId != [b]null[/b] && _toolConsumerId != '' ) findQuery += " and bl.bltiResourceLink.bltiContext.bltiToolConsumer.toolConsumerInstanceGuid='${_toolConsumerId}'" [b]if[/b]( _contextId != [b]null[/b] && _contextId != '' ) findQuery += " and bl.bltiResourceLink.bltiContext.contextId='${_contextId}'" [b]if[/b]( _resourceLinkId != [b]null[/b] && _resourceLinkId != '' ) findQuery += " and bl.bltiResourceLink.resourceLinkId='${_resourceLinkId}'" findQuery += " and bl.resultSourcedId='${_resultSourcedId}'"Alguém consegue observar alguma falha? Já olho e não enxergo mais nada de errado...a query gerada é a seguinte:
from BltiLaunch as bl where bl.bltiResourceLink.bltiContext.bltiToolConsumer.customer.customerId='902' and bl.bltiResourceLink.bltiContext.bltiToolConsumer.toolConsumerInstanceGuid='a757a9cdd8d4485796c994b66de079b7' and bl.bltiResourceLink.bltiContext.contextId='CW_LTI_TESTING_2016' and bl.bltiResourceLink.resourceLinkId='CW_LTI_TESTING_2016_141049_1' and bl.resultSourcedId='g8HJlc2pnALjI8Gkf+7soBZs46AYGzndcOC77d1PKnM=:_22007_1:_141049_1:chalka:cwrmilla'
Para se registrar, clique aqui.