I am facing one issue in My webMethods Server 7.1.2. we have dev, QA and Prod environment. MWS has TN configuration so we are able to see and resubmit the transaction from MWS. The issue is, in dev MWS, when we do transaction search in Integration - B2B-transactions, we are able to see 4-5 columns. while in QA we are seeing 10 columns. Now there is a SQL query that returns this columns in search.
In dev MWS, I can see the query when I hit on the Show SQL tab but I am not able to add more columns as we have in QA. Can any body help me to change this query or if I need to make other configurations.