What's new in Customer Journeys?

Connect and learn more! ×
Default value for Context (context-Sensitive DFF) : how to bind variable in the WHERE clause — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Default value for Context (context-Sensitive DFF) : how to bind variable in the WHERE clause

Received Response
23
Views
1
Comments

Summary:

Hi,

I am trying to configure a context sensitive DFF at Invoice header level (FlexCode=AP_INVOICE)

I want the context to be defaulted by the system from an SQL query on the AP_INVOICES_ALL table.

My question is regarding the SQL syntax.

I tried this at first:

SELECT INVOICE_NUM

 FROM  AP_INVOICES_ALL

 WHERE INVOICE_ID = :{PARAMETER.INVOICE_ID}

and ran into this error:


I want to understand how I can bind variable in the WHERE clause of my query so the current invoice information is fetched.


Thank you for helping,

Annie

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!