Select all failed OFS transactions

-



You can select all the failed OFS transactions using this query
SELECT F.OFS.RESPONSE.QUEUE WITH F1 LIKE -...

This will select all the records from the file F.OFS.RESPONSE.QUEUE which are failed due to any reason.

If you want to select only the failures due to error then use this query

SELECT F.OFS.RESPONSE.QUEUE WITH F1 LIKE -1...

If you want to select only the failures due to overrides then use this query

SELECT F.OFS.RESPONSE.QUEUE WITH F1 LIKE -2...


Comments

Post a Comment

Popular posts from this blog

Current Variables in T24

-
CURRENT VARIABLE Introduction In addition to the system common variables that can be used in ENQUIRY and VERSION there is a feature where the user can populate a variable of their own and use it later. There are now a series of new system variables and a much wider option for users to create and use their own which are: CURRENT.CUSTOMER CURRENT.ARRANGEMENT CURRENT.EXTERNAL.USER These may be set on login by an external user and cleared when they logout. This means that ENQUIRY & VERSION can be tailored to accept the content of the variable instead of forcing a user to enter their own customer number or arrangement etc. Similarly in VERSION you can now default a field content by using the !CURRENT.CUSTOMER to populate a customer field with the current content of the variable. So the variable could be set in one Enquiry and used in either another Enquiry linked to it; or via VERSION to populate fields in an application triggered from the Enquiry. Note: ...
Read more

All accounting entries of an T24 account

-
There is a core routine that will return all the accounting entries for an account it is EB.ACCT.ENTRY.LIST Syntax: EB.ACCT.ENTRY.LIST(ACCOUNT.NUMBER,FROM.DATE,END.DATE,YID.LIST,OPENING.BAL,ER) Passed Parameters. ACCOUNT.NUMBER :- Account for which balance & entries is to be returned. FROM.DATE :- Start date for opening balance and entries. END.DATE :- The last date to be considered. Outgoing : YID.LIST :- List of statement entry ids. OPENING.BAL :- Opening balance on the startt date. ER :- Any errors found
Read more

Drop down enquiry based on condition.

-
Description: We need to generate different drop downs on a version field based on another version field. We tried to populate the T array of the target field by making it as a Hot field Validation field, but it did not help. So to resolve this we created a Nofile enquiry and attached it to the target field. As this is a Nofile enquiry we can manage what to display in the field. Below are the details: There are 2 associated multi value fields and are, 1) THIRD.PARTY - YES or NO Field 2) APPL.TRANS - Normal Field Version Validation: IF THIRD.PARTY = NO THEN ONLY 8 TRANSACTION TYPES SHOULD COME IN DROP DOWN IN THE TRANSACTION.TYPE FIELD END ELSE ONLY 3 TRANSACTION TYPES SHOULD COME IN DROP DOWN IN THE TRANSACTION.TYPE FIELD END To achieve the code is written as below and attached with the field THIRD.PARTY: THIRD.PARTY = COMI IF THIRD.PARTY EQ 'YES' THEN T (QTC.CBD.APPL.TRANS) <2> = "Withdrawal_Earning _Distribution_Loan Advances...
Read more