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

ENQUIRY DATA DISPLAY

  • ROBIUL73
  • ROBIUL73's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

ROBIUL73 created the topic: ENQUIRY DATA DISPLAY

I display data file enquiry. but data is present live file and nau file(second time commit).so data display enquiry when it is commit.
I want data display only that is present only live file but not nau file
#21077
The following user(s) said Thank You: baskarjay

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 441
  • Karma: 7
  • Thank you received: 58

VK replied the topic: ENQUIRY DATA DISPLAY

Hi
If you have a "regular" enquiry, it will only present the data either from LIVE or NAU file - whichever is set up in ENQUIRY record.

Cheers
VK
#21090

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

  • Posts: 2827
  • Karma: 509
  • Thank you received: 636

jpb replied the topic: ENQUIRY DATA DISPLAY

... unless you have defined FILE.VERSION, then you can input in the selection screen which data you want to be displayed LIV, NAU, HIS or SIM.

Some people feel the rain - others just get wet (Bob Marley)
#21093

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

  • ROBIUL73
  • ROBIUL73's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

ROBIUL73 replied the topic: ENQUIRY DATA DISPLAY

MY PROBLEM WHEN I MADE FILE ENQUIRY IN LIVE FILE SEE ALL DATA ,BUT WHEN GIVE INPUT DATA AND COMMIT DATA GOES TO NAU FILE, BUT HERE DATA IS ALSO LIVE FILE .I WANT TO SHOW ONLY LIVE FILE DATA THAI NOT PRESENT NAU FILE .
IF CHANGE LIVE FILE RECORD DATA .IT IS PRESENT (LIVE+NAU FILE) ,ONLY DISPLAY LIVE DATA THIS NOT NAU STAGE ,HOW
#21094

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 441
  • Karma: 7
  • Thank you received: 58

VK replied the topic: ENQUIRY DATA DISPLAY

Thanks for correction jpb, however this doesn't work under my R13/Desktop :(((

Cheers
VK
#21095

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 441
  • Karma: 7
  • Thank you received: 58

VK replied the topic: ENQUIRY DATA DISPLAY

If you want to display only records that do not have corresponding INAU records, you can achieve that by creating a NOFILE enquiry. You'll have to select LIVE file manually and remove from the list the records you do not want to see. All it can be done in SS routine attached to enquiry using couple of jQL statements.

Cheers
VK
#21096

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

  • Posts: 2827
  • Karma: 509
  • Thank you received: 636

jpb replied the topic: ENQUIRY DATA DISPLAY

That's only possible with NOFILE logic.

--> another way would be a local I-desc that will check the existence of a NAU record and is then used as fixed selection.

But when you define LIV and NAU in FILE.VERSION and do NOT input at selection you will get two lines when the record is present in both.

@VK - as usual, works only in Browser (the selection) since R9

Some people feel the rain - others just get wet (Bob Marley)
#21097
The following user(s) said Thank You: VK

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

  • Posts: 28
  • Karma: -1
  • Thank you received: 0

baskarjay replied the topic: ENQUIRY DATA DISPLAY

Hii JBC
was i tried to logoff the TSA agent like logoff 7 in TAFJ
but its not working and also tried kill but no reults
any ideas????
#21099

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

  • Posts: 2827
  • Karma: 509
  • Thank you received: 636

jpb replied the topic: ENQUIRY DATA DISPLAY

I don't really know but as "logoff" is an executable - have you tried

tRun logoff 7

??

Some people feel the rain - others just get wet (Bob Marley)
#21101

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

  • ROBIUL73
  • ROBIUL73's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

ROBIUL73 replied the topic: ENQUIRY DATA DISPLAY

THANKS JPB.I USE HERE FILE ENQUIRY. AND FILE VERSION USE ONLY LIVE FILE .
PLEASE DESCRIBE another way local I-desc.
HOW USE local I-desc
#21106

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

  • Posts: 2827
  • Karma: 509
  • Thank you received: 636

jpb replied the topic: ENQUIRY DATA DISPLAY

There are many way to achieve this, e.g. via SUBR in CURRENCY:
15.12 USR.FIELD.NAME. CHECK.NAU
16.12 USR.TYPE....... I
17.12. 1 USR.FIELD.NO SUBR("ENQ.TRANS","CURRENCY$NAU",CURRENCY.CODE,"REC
17.12. 2 USR.FIELD.NO ORD.STATUS");IF @1 THEN "YES" ELSE "NO"
20.12 USR.DISPLAY.FMT 3L
24.12 USR.SINGLE.MULT S
25.12 USR.LANG.FIELD. N

Then use CHECK.NAU NE YES as selection for the enquiry.

Some people feel the rain - others just get wet (Bob Marley)
#21108

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

  • Posts: 28
  • Karma: -1
  • Thank you received: 0

baskarjay replied the topic: ENQUIRY DATA DISPLAY

Yes tried but not working @ JPB
#21109

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

  • Posts: 28
  • Karma: -1
  • Thank you received: 0

baskarjay replied the topic: ENQUIRY DATA DISPLAY

if i use like this tRun logoff 7 ,,,then

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256M; support was removed in 8.0
Sorry cannot find logoff
Class : com.temenos.t24.logoff_6_cl


Thanks and Regards,
BaskarJay
#21110

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

  • ROBIUL73
  • ROBIUL73's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

ROBIUL73 replied the topic: ENQUIRY DATA DISPLAY

ENQ.TRANS IS SUBROUTINE OR NOT.
If it is subroutine how i pass @ID
#21111

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

  • Posts: 2827
  • Karma: 509
  • Thank you received: 636

jpb replied the topic: ENQUIRY DATA DISPLAY

???


... just create the field in Standard.Selection as shown

Some people feel the rain - others just get wet (Bob Marley)
#21112

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

  • Posts: 197
  • Karma: 1
  • Thank you received: 27

DUBLIN replied the topic: ENQUIRY DATA DISPLAY

Hi jbp ,

It doesn't work the way you described i.e. if you have LIV & NAU in the enquiry's FILE.VERSION it brings all LIVE and NAU records but doesn't show them twice if any record has presence in both files. Only one line ...

Back to the original question - I have read it a few times and still think I didn't get what is the problem....
Enquiry over the LIVE file will always bring only live records and it doesn't matter do they have their "clones" in NAU or not . Another story if user is trying to View or Amend the record from LIVE list then T24 will use record from NAU file if it exists .
#21124

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 441
  • Karma: 7
  • Thank you received: 58

VK replied the topic: ENQUIRY DATA DISPLAY

Hi
Looks like he doesn't want to show records that are in the process of editing (read: amended but not yet authorised)...

Cheers
VK
#21126

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

  • Posts: 197
  • Karma: 1
  • Thank you received: 27

DUBLIN replied the topic: ENQUIRY DATA DISPLAY

OK, then jbp's solution with I-desc should work perfectly if file is not too big ...
#21127

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

  • Posts: 28
  • Karma: -1
  • Thank you received: 0

baskarjay replied the topic: ENQUIRY DATA DISPLAY

Anybody can tell what data type will used to define a decimal value for the field in .FIELDS routine ?????

quick reply please :)

i need output like this 12345678910111213.12365525522552555
#21361

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

  • Posts: 4
  • Thank you received: 0

Leelaprashant replied the topic: ENQUIRY DATA DISPLAY

In Enquiry fixed selection make REORD.STATUS = "" (null) then u will get only live file data..

-Thank you
Br,
#21364

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

Time to create page: 0.203 seconds