AnsweredAssumed Answered

NSQL can  call the function

Question asked by gaetano.diluca.1 on Oct 10, 2012
Latest reply on Oct 12, 2012 by gaetano.diluca.1
Hi,
it's possibile call the DB oracle function in the Clarity query using the NSQL language?
in othe word I had this sql statement:

EXAMPLE
select id, name, code, FUNCTION_GET_TEAM(i.id) from inv_investments where ......

in NSQL

SELECT
@SELECT:DIM:USER_DEF:IMPLIED:IDEA:I.ID:ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:I.NAME:NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:IDEA:I.CODE:CODE@,
-- I would call the function
FROM INV_INVESTMENTS I where i.id= odf.id

thanks in advances

Outcomes