New Topic

Community Topic Question Report Builder

Eric Hagfors

Yellowfin Support Team

Assigned

Category Report Builder

Product Version 9.0

parameter value as a filter

Heng Yu shared this question ago

Answered

Hello,

I have a function in the Oracle DB that take two parameters, the para2 is a date type, and need to be modified by the user

function(para1, para2)

the sql is like the following.

SELECT
funcationA(f.RSN, argAsOfDate => TO_DATE('2020-01-01','yyyy-mm-dd')) colA,
f.Type
FROM Folder f

Is there a way to achieve that using the parameter of the function as a filter?

Thanks

The same question

Replies (3)

Eric Hagfors ●

Hi Heng,

Thanks for reaching out. In YF You can create views against stored procedures -

fc8537cbc2aca6b331a4171853276449

You can define a parameter in the view builder -

f8e63e18d47808acabfc2c6a568ee05d

I think this is the general functionality you're looking for here?

Thanks,

Eric

Reply URL

Eric Hagfors ●

Hi Heng,

Just wanted to check in to see if you had a chance to review my reply at this time.

Thanks,

Eric

Reply URL

Heng Yu ●

Hi Eric,

I just tried your method this morning and it is what I am looking for.

Thanks

URL

Eric Hagfors ●

Hi Heng,

Glad to hear this solution is working for you , I'll go ahead and mark this question as Answered at this time. Feel welcome to reach out in the future.

Thanks,

Eric

Reply URL