In FTM UI for various PT and Transactions we are able to filter each record with a state related to it, but we would like to also include a NOT statement where FTM will be able to give details of all the other states than the mentioned one.
Below is a sample query:
SELECT O.APP_ID, A.NAME APP_NAME, O.ID, O.CID, O.UID, O.TYPE AS OBJTYPE, O.MASTER_FLAG,O.SUBTYPE,O.STATUS,O.STATUS_DATE,LENGTH(COALESCE(CAST(T.DATA_S AS BLOB), T.DATA)) DATA_LENGTH,O.CREATED,O.TECH_PRIORITY, T.PARTY_ID,T.CHANNEL_ID, T.FILENAME FROM %DBSchema.OBJ_BASE O, %DBSchema.TRANSMISSION_BASE T, %DBSchema.APPLICATION A WHERE O.ID = T.OBJ_ID AND O.APP_ID = A.ID AND O.MASTER_FLAG='Y' AND O.SUBTYPE='CBPAY_ORDER' AND O.STATUS='S_InPTComplete' AND O.CREATED >= 2017-04-11 00:00:00.0 AND O.CREATED <= 2017-04-12 00:00:00.0
We would like to include a NOT select criteria which will make searching easy during critical issue. (especially when txn have multiple states)