Search criteria:

Automatically generated select clause:

Automatically generated from clause:

Automatically generated where clause:

( C_Product~ISACTIVEENTITY = ' ' OR nav_SIBLINGENTITYC_Pr_41~ISACTIVEENTITY IS NULL ) AND %_native_pred( hdb = `%_native( 'CONTAINS(' ), %_native( '(' ), C_Product~ACTIVEPRODUCT, %_native( ',' ), C_Product~BASEUNIT, %_native( ',' ), C_Product~CREATEDBYUSER, %_native( ',' ), C_Product~CREATIONDATE, %_native( ',' ), C_Product~CROSSPLANTSTATUS, %_native( ',' ), BSA_E25X1~CUSTOMERNAME, %_native( ',' ), BSA_E80X2~MATERIALABCCLASSIFICATIONDESC, %_native( ',' ), BSA_E7X2~MATERIALUSABILITYPROFILENAME, %_native( ',' ), BSA_E29X2~DIVISIONNAME, %_native( ',' ), C_Product~LASTCHANGEDATE, %_native( ',' ), C_Product~LASTCHANGEDBYUSER, %_native( ',' ), C_Product~PRODUCT, %_native( ',' ), C_Product~PRODUCTDESCRIPTION, %_native( ',' ), C_Product~PRODUCTGROUP, %_native( ')' ), %_native( ',' ), CAST( 'java' AS CHAR ), %_native( ',' ), %_native( 'FUZZY(' ), %_native( '(' ), '1.0', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ',' ), %_native( '(' ), '0.8', %_native( ',' ), '''similarCalculationMode=search''', %_native( ')' ), %_native( ')' ), %_native( ')' )` )
LV_GROUP_BY:
C_Product~DRAFTKEY ASCENDING, C_Product~ACTIVEPRODUCT ASCENDING

Fuzzy Search

要获取更多Jerry的原创文章，请关注公众号"汪子熙":