Untitled
unknown
plain_text
a year ago
2.0 kB
5
Indexable
insert into matching_rule (change_time, priority, name, condition, creation_time, close_time) values (now(), 1, 'ROW_NUMB', '(((trans["Authoriz_row"] == "0" or trans["Authoriz_row"] == None) and int(event["rowNumb"]) == int(trans["Transact_row"])) or (trans["Authoriz_row"] != "0" and trans["Authoriz_row"] != None and int(event["rowNumb"]) == int(trans["Authoriz_row"]))) and (((trans["Appr_code"] == None or trans["Appr_code"] == '') and event["fld038"] == '') or (trans["Appr_code"] != None and trans["Appr_code"] != '' and event["fld038"] == trans["Appr_code"])) and (event["fld025"] != 1777 or event["fld025"] == None)', now(), null); insert into matching_rule (change_time, priority, name, condition, creation_time, close_time) values (now(), 2, 'TID', '(event["fld025"] != 1777 or event["fld025"] == None) and (event["fld095"] != None and trans["FLD_095"] != None and tlvParser(event["fld095"], "0003") == tlvParser(trans["FLD_095"], "0003"))', now(), null); insert into matching_rule (change_time, priority, name, condition, creation_time, close_time) values (now(), 3, 'FIELDS', '(((trans["Appr_code"] == None or trans["Appr_code"] == '') and event["fld038"] == '') or (trans["Appr_code"] != None and trans["Appr_code"] != '' and event["fld038"] == trans["Appr_code"])) and ((event["fld037"] == trans["Ref_number"] and trans["Ref_number"] != None and trans["Ref_number"] != "" and event["fld037"] != None and event["fld037"] != "") or ((event["fld037"] == None or event["fld037"] == "") and trans["Ref_number"] != None and trans["Ref_number"] != "") or ((trans["Ref_number"] == None or trans["Ref_number"] == "") and event["fld037"] != None and event["fld037"] != "")) and ((trans["Msg_type"] != None and trans["Msg_type"] != "" and (event["msgType"].startswith(trans["Msg_type"][0:2]))) or ((trans["Msg_type"] == "" or trans["Msg_type"] == None) and event["msgType"] == trans["Msg_type"])) and event["fld026"] == trans["MCC_code"] and differenceBetweenAmounts(trans["Amount"], event["fld004"], 10)', now(), null);
Editor is loading...
Leave a Comment