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

What is the bind variable that can be used for Maintenance Work Order Id in DFF SQL?

Hi,

While trying to fetch data automatically in the DFF, I'm not able to figure out the parameter segment for work_order_id. I'm trying to use the SQL code:

SELECT ATTRIBUTE_TIMESTAMP2 - ATTRIBUTE_TIMESTAMP1
FROM WIE_WORK_ORDERS_B
WHERE WORK_ORDER_ID = :{PARAMETER.WorkOrderId}

Kindly help.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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