× Discuss about OFS, Temenos Connectors, Various OFS modes, OFS with Versions, OFS performance, Logging, EB.PHANTOM, OFS.SOURCE etc…

OFS query not returning result set

  • dkblay
  • Topic Author
  • Visitor
  • Visitor
12 years 1 month ago #12821 by dkblay
OFS query not returning result set was created by dkblay
Hello, i wrote an ofs query to get the balance of a customer ie (
ENQUIRY.SELECT,,INPUTT/123456,%ACCOUNT,@ID:EQ=2000000208)

But realized that some filed were not being returned. I was looking for the working balance but the result retured ONLINE.ACTUAL.BAL. Should i use this instead of the WORKING.BALANCE.

What is the difference between the two and also how can i return all results set of a jbase file through the ofs script. Please this is the result set returned

===========================================================================================
ENQUIRY.SELECT,,INPUTT/123456,%ACCOUNT,@ID:EQ=2000000208
%ACCOUNT//1,,@ID::@ID/MNEMONIC::MNEMONIC/ACCOUNT.OFFICER::ACCOUNT.OFFICER/CATEGO
RY::CATEGORY/CURRENCY::CURRENCY/ONLINE.ACTUAL.BAL::ONLINE.ACTUAL.BAL/LIMIT.REF::
LIMIT.REF/POSTING.RESTRICT::POSTING.RESTRICT/INT.NO.BOOKING::INT.NO.BOOKING/COND
ITION.GROUP::CONDITION.GROUP/CATEGORY::CATEGORY," 2000000208" "BOEINGE
UR " "Risk Mana|" "Current Account" "EUR" " 2,057,500.00"
" " " " " " " 2" " 1001"

===============================================================================================

Thank you

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago #12824 by jpb
Replied by jpb on topic OFS query not returning result set
To get all fields (that have a value) you can use %ACCOUNT-DEFAULT.

The difference between the 6 balance fields in ACCOUNT is explained in helptext.

Please Log in or Create an account to join the conversation.

  • dkblay
  • Topic Author
  • Visitor
  • Visitor
12 years 1 month ago #12828 by dkblay
Replied by dkblay on topic OFS query not returning result set
Please if i got you right i tried it and had below result


ENQUIRY.SELECT,,INPUTT/123456,%ACCOUNT-DEFAULT
MISSING ENQUIRY -


Am i making a mistake somewhere please.


Thank you

Please Log in or Create an account to join the conversation.

More
12 years 1 month ago #12832 by jpb
Replied by jpb on topic OFS query not returning result set
%ACCOUNT-DEFAULT is used internal when you use the SEE function out of a enquiry, seems that OFS is not able to generate the default view.
To get all field from an application (for one record at a time) you can also use

ACCOUNT,/S/PROCESS//,input/123456,<account.no>

When you need a list of accounts and their balances just define an enquiry for your needs.

Please Log in or Create an account to join the conversation.

Time to create page: 0.080 seconds