What should be the format for sql query with double quote

below throws warning, i guess something wrong at ‘%state":"new%’" , and katalon needs “” to close the statement too.

String dbQuery = "SELECT COUNT(*) as count FROM dis.disA where lower(data) LIKE '%state":"new%'"

@Gan_Jyi_Yng

Try to wrap your string with triple quotes instead and Groovy would probably take care of the content.

yup, found solution using /

String dbQuery = /SELECT COUNT(*) as count FROM dis.disA where lower(data) LIKE '%"state":"new"%'/