IBM WFSS Ideas Portal

 Welcome!

 

Our team welcomes any feedback and suggestions you have for improving our offerings. This forum allows us to connect your product improvement ideas with IBM product and engineering teams.

 

For product documentation, see Knowledge Center.
Create and View Support Cases and Use the Discussion Forum here

 

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

 

The shorter URL for this site is:   http://ibm.biz/WFS-Ideas

IBMers, please visit the WFSS Internal Ideas portal https://ibm.biz/WFS-Internal-Ideas

FTM OAC to include a NOT statement for status selection to select payments

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)
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Apr 9 2019
  • Future Consideration
Component Administration & Configuration
Priority High - Critical
  • Attach files