- Forum
- T24 Technical Discussions
- jBASE / TAFC
- Query multi value with two o more tables see all results
Query multi value with two o more tables see all results
- Vegam
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
4 years 6 months ago #22749
by Vegam
Query multi value with two o more tables see all results was created by Vegam
Hello i new in jbase
my question is how can get all informations of a multivalue Field in other table
i try
LIST FBNK.BCCL.PERSONA WITH PER.ID.PRDES LIKE 2... AND (PER.ID.PRDES LIKE 1... OR PER.ID.PRDES LIKE 0...) AND EVAL "PER.ID.PRDES;TRANS ('FBNK.BCCL.SETTLEMENT.ACCT.BALANCE',@1,'ESTADO',1)" AS ESTADOCUENTA AND ESTADOCUENTA 'ACT' AND EVAL "PER.ID.PRDES;TRANS ('FBNK.ACCOUNT',@1,'WORKING.BALANCE',1)" AS SALDO ESTADOCUENTA SALDO PER.ID.PRDES
But some fields are empty like this
Thanks you
my question is how can get all informations of a multivalue Field in other table
i try
LIST FBNK.BCCL.PERSONA WITH PER.ID.PRDES LIKE 2... AND (PER.ID.PRDES LIKE 1... OR PER.ID.PRDES LIKE 0...) AND EVAL "PER.ID.PRDES;TRANS ('FBNK.BCCL.SETTLEMENT.ACCT.BALANCE',@1,'ESTADO',1)" AS ESTADOCUENTA AND ESTADOCUENTA 'ACT' AND EVAL "PER.ID.PRDES;TRANS ('FBNK.ACCOUNT',@1,'WORKING.BALANCE',1)" AS SALDO ESTADOCUENTA SALDO PER.ID.PRDES
But some fields are empty like this
Thanks you
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
4 years 6 months ago #22750
by VK
Cheers
VK
Replied by VK on topic Query multi value with two o more tables see all results
Hi
it's nothing I can see except the query itself...
Also, it looks like a local application you try to use; maybe you can apply your query to some similar core tables for others to be able to reproduce it?
it's nothing I can see except the query itself...
Also, it looks like a local application you try to use; maybe you can apply your query to some similar core tables for others to be able to reproduce it?
Cheers
VK
Please Log in or Create an account to join the conversation.
- Vegam
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
4 years 6 months ago #22752
by Vegam
Replied by Vegam on topic Query multi value with two o more tables see all results
Hi,
i dont know what tables are core,can give some examples or how to identify ? for the query.
Thanks you
i dont know what tables are core,can give some examples or how to identify ? for the query.
Thanks you
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
4 years 6 months ago #22755
by VK
Cheers
VK
Replied by VK on topic Query multi value with two o more tables see all results
CUSTOMER
ACCOUNT
DEPT.ACCT.OFFICER
INDUSTRY
TARGET
CURRENCY
USER
SECURITY.MASTER
thousands of them...
all those that present in Model Bank
ACCOUNT
DEPT.ACCT.OFFICER
INDUSTRY
TARGET
CURRENCY
USER
SECURITY.MASTER
thousands of them...
all those that present in Model Bank
Cheers
VK
Please Log in or Create an account to join the conversation.
- Vegam
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
4 years 6 months ago - 4 years 6 months ago #22758
by Vegam
Replied by Vegam on topic Query multi value with two o more tables see all results
i try with table Customer
LIST FBNK.CUSTOMER WITH EVAL "REL.CUSTOMER;TRANS(FBNK.CUSTOMER,@1,TARGET,1)" AS TARGETREL TARGETREL SHORT.NAME REL.CUSTOMER
But it seem work very well, i dont know why in the other dont show me all result
LIST FBNK.CUSTOMER WITH EVAL "REL.CUSTOMER;TRANS(FBNK.CUSTOMER,@1,TARGET,1)" AS TARGETREL TARGETREL SHORT.NAME REL.CUSTOMER
But it seem work very well, i dont know why in the other dont show me all result
Last edit: 4 years 6 months ago by Vegam.
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
4 years 6 months ago #22763
by VK
Cheers
VK
Replied by VK on topic Query multi value with two o more tables see all results
TARGET is a single field.. try something multi-valued.
Cheers
VK
Please Log in or Create an account to join the conversation.
- DennisBartlett
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 1
4 years 4 months ago #22855
by DennisBartlett
Replied by DennisBartlett on topic Query multi value with two o more tables see all results
The problem with this statement is that you have created the link to the other file inside an AND but you haven't done anything with it in the AND...
For example
AND EVAL "PER.ID.PRDES;TRANS ('FBNK.BCCL.SETTLEMENT.ACCT.BALANCE',@1,'ESTADO',1)"
and named it
AS ESTADOCUENTA
then you have another AND
AND ESTADOCUENTA 'ACT'
When you assign the EVAL to a name, you need to also do the comparison there before the AND
LIST FBNK.BCCL.PERSONA WITH PER.ID.PRDES LIKE 2... AND (PER.ID.PRDES LIKE 1... OR PER.ID.PRDES LIKE 0...) AND EVAL "PER.ID.PRDES;TRANS ('FBNK.BCCL.SETTLEMENT.ACCT.BALANCE',@1,'ESTADO',1)" AS ESTADOCUENTA = 'ACT' AND EVAL "PER.ID.PRDES;TRANS ('FBNK.ACCOUNT',@1,'WORKING.BALANCE',1)" AS SALDO ESTADOCUENTA SALDO PER.ID.PRDES
For example
AND EVAL "PER.ID.PRDES;TRANS ('FBNK.BCCL.SETTLEMENT.ACCT.BALANCE',@1,'ESTADO',1)"
and named it
AS ESTADOCUENTA
then you have another AND
AND ESTADOCUENTA 'ACT'
When you assign the EVAL to a name, you need to also do the comparison there before the AND
LIST FBNK.BCCL.PERSONA WITH PER.ID.PRDES LIKE 2... AND (PER.ID.PRDES LIKE 1... OR PER.ID.PRDES LIKE 0...) AND EVAL "PER.ID.PRDES;TRANS ('FBNK.BCCL.SETTLEMENT.ACCT.BALANCE',@1,'ESTADO',1)" AS ESTADOCUENTA = 'ACT' AND EVAL "PER.ID.PRDES;TRANS ('FBNK.ACCOUNT',@1,'WORKING.BALANCE',1)" AS SALDO ESTADOCUENTA SALDO PER.ID.PRDES
Please Log in or Create an account to join the conversation.
- Forum
- T24 Technical Discussions
- jBASE / TAFC
- Query multi value with two o more tables see all results
Time to create page: 0.081 seconds