Add search criteria to inquiry screen

Question

Hi there, 
 I successfully added the "internal reference" field from the purchase order to the "Order lines inquiry" screen. Now we want to add the field to the filter. 
 
 I already added and "linked" the header and cirteria fields in the "CPP" inquiry: 
 
 Unfortunately it seems that this would not add the field to the whole filter criteria? Maybe it requires to add this criteria to a specific script? How could we solve this? Any ideas? 
 Thanks!

Regard Hulsbos · Accepted Answer

You will need to add a SPE onto the Inquiry. You can do so by adding the following in the SPE and then compiling it. 
 $ACTION Case ACTION When "FILTRE" : Gosub FILTRE When Default Endcase 
 Return 
 # ADD ADDITIONAL FILTER CRITERIA ##################################### $FILTRE # IF THE ORDER REFERENCE EXIST ON THE SCREEN AND IS NOT BLANK, ADD AS FILTER If dim([M:CPP1]ORDREF)>0 and [M:CPP1]ORDREF <> [V]AVOID.ACHAR WFIL += "& [F:POH]ORDREF=[M:CPP1]ORDREF" Endif Return

Regard Hulsbos · Answer

Yes it is, update the line to: 
 WFIL += "& pat([F:POH]ORDREF, '*'+[M:CPP1]ORDREF+'*') > 0" 
 The pat functions similar to PATINDEX in SQL. The star indicate any match, regardless of position in the variable will return as true. 
 You can find more help on the function in the online help attached below. 
 online-help.sageerpx3.com/.../4gl_pat.html

Sage X3

Add search criteria to inquiry screen

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING