Custom Field - Select statement with two variables

Hi @servetsc,

Could you give me an example of that expression? I've never used that expression before, so I don't know what to do yet.

Kind regards,

Karin

Hi @johnw66,

I don't agree with you on that statement.

The Part_No is available on the Shop_Order_Operation view in the column ‘Outside Op Item’. 

Hi,

 

I want to add a custom field to the Purchase Requisition Lines view, which is based on two criteria to make the search unique.

I've made a Read Only Custom Field with one of the key variables, but make it work for each line I need to add a second variable to my select statement. Problem is: I get an error when I want to finish creating the Custom Field.

This is the field I want to add to Purchase Requisition Lines:

This is what I got so far. 

Select Statement:

SELECT Operation_Description FROM Shop_Order_Operation WHERE Order_No = :Demand_Order_No AND Outside_Op_Item = :Part_No

This is the Error that appears after clicking on ‘Finish’:

 

And these are the results when I only use the Shop Order number as criteria:

Does someone know what I am missing here?

Hi @servetsc,

Purchase Requisition Lines is connected to view PURCHASE_REQ_LINE_ALL which is not the base view for this LU PurchaseReqLine

When you declare an argument as v.XXX, it searches in the base view, in this case PURCHASE_REQ_LINE

It seems like PART_NO is not included in the base view PURCHASE_REQ_LINE which the error is about.

You can get the part no using purchase_req_line_part_api.get_part_no(requisition_no_ => :requisition_no_, line_no_ => :line_no_, release_no_ => :release_no_) 

you can find variables to call the function from the base view.

Hope it helps!

Damith

Hi @servetsc,

Thank you for your example, I tried it and it works perfectly!

Regards,

Karin