pattern search results for affectedorderid