Query multi value with two o more tables see all results

More
1 year 4 months ago #22749 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
Attachments:

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
1 year 4 months ago #22750 by VK
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?

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

More
1 year 4 months ago #22752 by Vegam
Hi,
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
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
1 year 4 months ago #22755 by VK
CUSTOMER
ACCOUNT
DEPT.ACCT.OFFICER
INDUSTRY
TARGET
CURRENCY
USER
SECURITY.MASTER

thousands of them...

all those that present in Model Bank

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

More
1 year 4 months ago - 1 year 4 months ago #22758 by Vegam
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
Last edit: 1 year 4 months ago by Vegam.

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R19/R21
More
1 year 4 months ago #22763 by VK
TARGET is a single field.. try something multi-valued.

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

More
1 year 1 month ago #22855 by DennisBartlett
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

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

Time to create page: 0.134 seconds