is it possible to fetch matrix column through formatted search in UDF?

[Former Member]

HI,

Is it possible to fetch the value of first row of quantity column in user defined field through formatted search?

SELECT $[$38.11.number]

does work but in user defined column of matrix only. I have requirement that when there will be only one row in matrix, the quantity should be accessible in user defined field. and for this, the above query gives internal error.

thanks and regards,

Binita

[Nussi · Accepted solution]

Binita,

lets say you want to fetch from Order Line

use

SELECT $[RDR1.Quantity]

regards

David

[Former Member · Accepted solution]

David,

That's precisely what I tried but, My problem is, this query works if it is assigned through formatted search to a user defined matrix column on that matrix. if I assign it to user defined field in 'User defined field' area (i.e form (-139)), it gives internal error. and I doubt that's not possible.

lg,

Binita

[Nussi · Accepted solution]

well Binita,

i assigned this query to a userfield in header and it worked.

thats why i posted it - iam getting the value

i forgot to mention that you have to select the line with the orange selection bar !

than it works - try it

lg David

[Former Member · Accepted solution]

Thanks David, It worked..

but, that means, it would not be completely automated. some coding has to be there to select it.

thanks anyway..

lg

Binita

[Former Member · Accepted solution]

David,

I used the query sent by you and further facing following problem. may be my filtering is on wrong parameter.

SELECT $[rdr1.quantity] * $[ordr.u_qty1.number] from ordr o, rdr1 r where o.cardcode= $[ordr.cardcode] and r.itemcode = $[rdr1.itemcode]

this query gives correct result when assigning to matrix column.

when I applied the same query to user defined field, then after selecting the row as suggested by you, it does give value but, in this case, it takes it from rdr1 instead of from matrix.

for example, I have selected item A001 in matrix. if that item is already there in rdr1, then it fetches its quantity from table instead of that provided by me in matrix's quantity column

Please guide further,

thanks in advance,

Binita

Edited by: Binita Joshi on Jun 5, 2008 2:45 PM

even

SELECT $[$38.11.number] * $[ordr.u_qty1.number] from ordr o, rdr1 r where o.cardcode= $[ordr.cardcode] and r.itemcode = $[$38.1.0]

is not working. no clues.

[Nussi · Accepted solution]

ok Binita,

EDIT:

Binita, i was asking to our best consultant and i have to tell you:

it's not possible

lg

Edited by: David Nussböck on Jun 5, 2008 3:59 PM