Query multi value with two o more tables see all results

  • Posts: 3
  • Thank you received: 0

Vegam created the topic: 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
#22749
Attachments:

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the 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?
#22750

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

  • Posts: 3
  • Thank you received: 0

Vegam replied the 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
#22752

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the 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
#22755

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

  • Posts: 3
  • Thank you received: 0

Vegam replied the 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
#22758

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • TAFC|R13|R19|R20
  • Posts: 785
  • Thank you received: 110

VK replied the topic: Query multi value with two o more tables see all results

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

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

  • Posts: 1
  • Thank you received: 0

DennisBartlett replied the 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
#22855

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

Time to create page: 0.333 seconds