-
Forum
-
T24 Technical Discussions
-
T24 Development & Customization
-
finding the max and min value in a enquiry with out nofile
finding the max and min value in a enquiry with out nofile
-
girish
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 11
-
Thank you received: 0
-
-
19 years 4 months ago #546
by girish
hi all,
3 requirements i faced in enquiry
1. how to find the maximum and minimum value from a single field(column) in a grid enquiry.
2. how to append a total field in a gird (to my rememberance not possible in grid).
3. how to find the total credits and debits,opening bal,closing bal for a given past date range.
hope few silent people have answers .....
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 1
-
Thank you received: 0
-
-
-
-
1 year 10 months ago #24245
by EdAguilar
hi, girish
I also faced this type of problem but the only solution I found was to create an enquiry nofile, where for point 1 I could make evaluations of which value is the largest with jbase functions, even carrying out evaluation methods comparing the values to find the maximum and minimum value.
for point 2, adding one more line within the inquiry nofile routine where a specific column can be located to show a total of transactions, amounts, etc.
point 3 I think you mean account statements, in which there are apis generated by temenos where the movements of each transaction are shown from the stmt table, and validating the transaction used in each movement and thus define what the credit is , debit and with this perform a general count, the api to validate the stmt even accepts dates to only show those transactions defined by a date range.
I hope this is what you are looking for
EdAguilar
Please Log in or Create an account to join the conversation.
-
Forum
-
T24 Technical Discussions
-
T24 Development & Customization
-
finding the max and min value in a enquiry with out nofile
Time to create page: 0.034 seconds