×
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
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
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.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
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.
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
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
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.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
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.
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