Skip to main content
Question

Using Quick Report Parameters and Flags

  • December 7, 2021
  • 0 replies
  • 354 views

baris.halici
Hero (Customer)
Forum|alt.badge.img+12

Hello Dear Community Users,

 

I have a question regarding the following topic.

https://community.ifs.com/reporting-117/can-we-make-quick-report-parameters-mandatory-and-set-a-default-value-for-them-3843?postid=59325#post59325

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings