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

本文来自云栖社区合作伙伴“汪子熙”，了解相关信息可以关注微信公众号"汪子熙"。