× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

finding the max and min value in a enquiry with out nofile

  • girish
  • Topic Author
  • Offline
  • New Member
  • New Member
More
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.

More
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.

Time to create page: 0.034 seconds