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

List FT history file

  • Menhlong
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #21891 by Menhlong
List FT history file was created by Menhlong
Hi all, I want to list FT history file but it takes so long time. so is there any fast way to list FT history file by knowing account number?

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

More
5 years 5 months ago #21947 by MarkTaylor
Replied by MarkTaylor on topic List FT history file
It should be faster if you start from ACCT.STMT.PRINT, STMT.PRINTED (or directly from STMT.PRINTED) and STMT.ENTRY.
Based on the field TRANS.REFERENCE in STMT.ENTRY, you can filter the FT references
The following user(s) said Thank You: VK

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
5 years 5 months ago #21965 by jpb
Replied by jpb on topic List FT history file
Have you tried defining/using an INDEX, e.g.

CREATE-INDEX -n FBNK.FUNDS.TRANSFER$HIS DEB.ACCT.DATE BY DEBIT.ACCT.NO BY PROCESSING.DATE
CREATE-INDEX -n FBNK.FUNDS.TRANSFER$HIS CRE.ACCT.DATE BY CREDIT.ACCT.NO BY PROCESSING.DATE



This might have impact on performance.

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

  • Menhlong
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 1 week ago #22064 by Menhlong
Replied by Menhlong on topic List FT history file
Can you explain me more detail how to use CREATE-INDEX ?

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

Time to create page: 0.098 seconds