SELECT SINGLE VALUE FROM MULTIVALUE FIELDS

[jbase_newbie]

Dear all friends,

How to select value with condition in multivalue field?
My query is:
>LIST FBNK.LC.ACCOUNT.BALANCES @ID CHRG.AMT.DUE CHRG.DATE.DUE CHRG.CODE CHRG.CCY PARTY.CHRG CHRG.STATUS WITH CHRG.STATUS EQ 2
and result is:

TF0836500742 -20 20081230 LCIOPEN USD O 2
-20 20081230 SWIFTOVN USD O 2
-50 20090107 LCIPAY USD O 8
-100 20090107 CABLEFEEBEN USD B 9
TF0900300877 -34650 20090103 COECHEQUE VND B 2
-20 20090106 CABLEFEEBEN EUR
O 9
.......
but I want the out put should be data group if chrg.status=2, as:
TF0836500742 -20 20081230 LCIOPEN USD O 2
-20 20081230 SWIFTOVN USD O 2
TF0900300877 -34650 20090103 COECHEQUE VND B 2

How can I repair it? Plz help me!
Thanks so much

[Kevin Powick]

This looks like a T24 question, so you will soon hear from Jim I with
regard to posting rules.

I can't really read the output very well, but you probably are looking
for the BY-EXP clause of the SORT statement.

Check the KB or documentation for details under the jQL topic.

--
Kevin Powick

[Daniel Klein]

If I understand the question correctly, replace:

WITH CHRG.STATUS EQ 2

with:

BY-EXP CHRG.STATUS EQ "2"

to the statement. The BY-EXP acts like a WITH in this case but only selects the appropriate value(s).

Note: always, always, always put quotes around values.

Dan

[Adnan Bin Wasim]

These are two known ways of accessing particular value of a multivalue fields......

 

LIST FBNK.SECURITY.TRANS EVAL 'PRICE(@VM,2)'

LIST FBNK.SECURITY.TRANS EVAL 'PRICE<1,2>'

[Daniel Klein]

The problem is NOT that the OP wants to target a particular value based on its position, it's that the OP wants to 'list' a particular value regardless of its position. At least that's what the original post implied.

Dan

[jbase_newbie]

Thanks to Daniel Klein, that solve the problem!
To Kevin Powick, I think it is jbase problem not T24 (exactly jQL).
May be the output is out of order b/c forum's features; I tried to
layout it best...
Best regard