670k
2020-12-02 01:14:56
As far as I can tell, you problem is related with the quotes --> to be more explicit, you have a problem when your IN clause starts because you close your first quote from query string
query_string = 'com.jmr.profitto.los.app.retail.model.L2LLdmLeadinformation entity WHERE entity.status IN ('
I think you need to encapsulate the quotes from the IN clause so that they get ignored by the first query.
UPDATE l2l_lov_master
SET
query_string = 'com.jmr.profitto.los.app.retail.model.L2LLdmLeadinformation entity WHERE entity.status IN (''
new '','' rejected '','' rejected_by_customer '')'
WHERE
lov_id = 'customerLov-leadcode';
热门帖子
热门github
6
glad to help. Just as info, when creating the statement, there might be some differences in the text, so make sure you correct them before using the code in your live project. ( within the IN Clause I used lower case and added some spaces )