Just getting started with PI and PI JDBC. Trying to retrieve tags that end in a specific string literal "XX_YY______ZZ" where the location and number of underscores is required.
stmt = con.prepareStatement("SELECT tag, userint1 FROM pisnapshot WHERE tag like '%XX_YY_____ZZ'");
When executed this returns values like
In the dataset above, ONLY the first record is the desired output. I've tried playing with Support PI Wildcards = False without success.