× 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
Topic Author
Offline
Junior Member

6 years 11 months ago #21077 by ROBIUL73

ENQUIRY DATA DISPLAY was created by ROBIUL73

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

The following user(s) said Thank You: baskarjay

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

VK
Offline
Platinum Member
Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test

6 years 11 months ago #21090 by VK

Replied by VK on 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

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

jpb
Offline
Moderator
TAFj-R20 - 'unix'

6 years 11 months ago #21093 by jpb

Replied by jpb on 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.

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

ROBIUL73
Topic Author
Offline
Junior Member

6 years 11 months ago - 6 years 11 months ago #21094 by ROBIUL73

Replied by ROBIUL73 on 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

Last edit: 6 years 11 months ago by ROBIUL73.

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

VK
Offline
Platinum Member
Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test

6 years 11 months ago #21095 by VK

Replied by VK on topic ENQUIRY DATA DISPLAY

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

Cheers
VK

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

VK
Offline
Platinum Member
Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test

6 years 11 months ago #21096 by VK

Replied by VK on 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

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

jpb
Offline
Moderator
TAFj-R20 - 'unix'

6 years 11 months ago - 6 years 11 months ago #21097 by jpb

Replied by jpb on 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

Last edit: 6 years 11 months ago by jpb.

The following user(s) said Thank You: VK

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

baskarjay
Offline
Senior Member

6 years 11 months ago #21099 by baskarjay

Replied by baskarjay on 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????

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

jpb
Offline
Moderator
TAFj-R20 - 'unix'

6 years 11 months ago #21101 by jpb

Replied by jpb on topic ENQUIRY DATA DISPLAY

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

tRun logoff 7

??

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

ROBIUL73
Topic Author
Offline
Junior Member

6 years 11 months ago #21106 by ROBIUL73

Replied by ROBIUL73 on 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

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

jpb
Offline
Moderator
TAFj-R20 - 'unix'

6 years 11 months ago #21108 by jpb

Replied by jpb on 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.

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

baskarjay
Offline
Senior Member

6 years 11 months ago #21109 by baskarjay

Replied by baskarjay on topic ENQUIRY DATA DISPLAY

Yes tried but not working @ JPB

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

baskarjay
Offline
Senior Member

6 years 11 months ago #21110 by baskarjay

Replied by baskarjay on 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

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

ROBIUL73
Topic Author
Offline
Junior Member

6 years 11 months ago - 6 years 11 months ago #21111 by ROBIUL73

Replied by ROBIUL73 on topic ENQUIRY DATA DISPLAY

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

Last edit: 6 years 11 months ago by ROBIUL73.

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

jpb
Offline
Moderator
TAFj-R20 - 'unix'

6 years 11 months ago #21112 by jpb

Replied by jpb on topic ENQUIRY DATA DISPLAY

???

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

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

DUBLIN
Offline
Elite Member

6 years 11 months ago - 6 years 11 months ago #21124 by DUBLIN

Replied by DUBLIN on 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 .

Last edit: 6 years 11 months ago by DUBLIN.

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

VK
Offline
Platinum Member
Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test

6 years 11 months ago - 6 years 11 months ago #21126 by VK

Replied by VK on 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

Last edit: 6 years 11 months ago by VK.

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

DUBLIN
Offline
Elite Member

6 years 11 months ago #21127 by DUBLIN

Replied by DUBLIN on topic ENQUIRY DATA DISPLAY

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

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

baskarjay
Offline
Senior Member

6 years 7 months ago #21361 by baskarjay

Replied by baskarjay on 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

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

Leelaprashant
Offline
New Member

6 years 6 months ago #21364 by Leelaprashant

Replied by Leelaprashant on topic ENQUIRY DATA DISPLAY

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

-Thank you
Br,

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

Time to create page: 0.165 seconds