Question

Using Quick Report Parameters and Flags

  • 7 December 2021
  • 0 replies
  • 306 views

Userlevel 5
Badge +11

Hello Dear Community Users,

 

I have a question regarding the following topic.

I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. 

SELECT *
FROM shop_order_operation o
LEFT JOIN shop_order_operation prev_op
ON prev_op.order_no = o.order_no AND
prev_op.release_no = o.release_no AND
prev_op.sequence_no = o.sequence_no AND
prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no)
WHERE
o.work_center_no = '&[MCS-L]Work_Center_No' AND
o.oper_status_code = '&[MCS-L]shop_order_operation.oper_status_code' AND
prev_op.oper_status_code = '&[MCS-L]operation_history.oper_status_code';

How do we make special prompt when we use view column which is enumeration?

 

Best Regards,

Barış


0 replies

Be the first to reply!

Reply