parameter value as a filter

Heng Yu shared this question 4 months 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

Replies (3)

photo
1

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

photo
1

Hi Heng,

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

Thanks,

Eric

photo
1

Hi Eric,

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


Thanks

photo
photo
1

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

Leave a Comment
 
Attach a file