Query multi value with two o more tables see all results

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

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?

Hi,
i dont know what tables are core,can give some examples or how to identify ? for the query.

Thanks you

CUSTOMER
ACCOUNT
DEPT.ACCT.OFFICER
INDUSTRY
TARGET
CURRENCY
USER
SECURITY.MASTER

thousands of them...

all those that present in Model Bank

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

TARGET is a single field.. try something multi-valued.

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