Forum Stats

  • 3,875,987 Users
  • 2,267,015 Discussions


[Jdev 12C] Groovy expression is not working in SQL query defined in View link accessor( child VO)

User_XGAL8 Posts: 10 Employee
edited Jun 26, 2022 5:33PM in JDeveloper and ADF

Hi ,

I have two VO's . Let's suppose ParentVO and ChildVO and I created a view link accessor using them.

In Child VO query , only current logged In user results should be returned.. so In query where clause I have added a condition -

where USERNAME=:loggedInUser

and loggedInUser = adf.context.securityContext.getUserName() -- Groovy expression.

but this is not working . API is not giving any results .

Note -

If I pass , any literal value instead of groovy , it works.

If I use ChildVO(like Parent/Main VO) directly (not as child of any VO) . this is working (just for testing purpose I did)