• 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

2 weeks 1 day ago #22749
Attachments:
  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 736
  • Thank you received: 104

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?

Cheers
VK
#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
  • R13|TAFC|jBASE|windoze
  • Posts: 736
  • Thank you received: 104

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

Cheers
VK
#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
  • R13|TAFC|jBASE|windoze
  • Posts: 736
  • Thank you received: 104

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

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

Cheers
VK
#22763

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

Time to create page: 0.748 seconds