Browse formula

James Newman

New Member
Hi forum
Quite new to QAD browser, I created the browse below which works fine but I'm trying add a query which only selects prod_type "86" which starts with a 5A i.e. 5ABCLAN. Can anyone help me with how to amend this query to only show 86 items that start with 5A? Most things I try do work, but but unfortunetly removes the 95 completely

((pt_prod_line = "95") or (pt_prod_line = "86")) and wo_status = "R"

Thanks for your help.
J
 
Hi forum
Quite new to QAD browser, I created the browse below which works fine but I'm trying add a query which only selects prod_type "86" which starts with a 5A i.e. 5ABCLAN. Can anyone help me with how to amend this query to only show 86 items that start with 5A? Most things I try do work, but but unfortunetly removes the 95 completely

((pt_prod_line = "95") or (pt_prod_line = "86")) and wo_status = "R"

Thanks for your help.
J
((pt_prod_line = "95") or (pt_prod_line = "86" AND pt_part BEGINS "5A")) and wo_status = "R"
 

James Newman

New Member
Many thanks, will try this tomorrow.
 

James Newman

New Member
Many thanks Marco, provided exactly what I needed. 5*
 
Top