This functionality works in 7.5 perfectly. But in 7.6 its not working.
1 of 1 people found this helpful
I know there was issue when i moved from 7.5 to 7.6 and later BMC had a hotfix for that. Issue was related to quotes.
Try the same search on the form where table queries the data. Adjust the query first there then adjust your workflow to set the query same in external qualification.
I will suggest to turn on the SQL log and see what it is getting translated and run the select statement on SQL command to see whats missing as well.
I took SQL log and run the query in the log in SQL developer. This query gives correct results there. But same when I include in workflow it doesn't give proper results.I tried to search from form(Advance Search option). It also gives message "No matching requests found". One more observation is If I query with single line or word it returns the results.
Ok, couple of questions?
is your database case sensitive?
is Customer Address field 0 length?
Try this "('Customer Address' LIKE " + """%" + $Customer Address$ + "%""" + ")" I am using the similar in my table as EXTERNAL() qualification and working fine.