I would like to modify the dynamic part number in a Product Quote to not include, Deleted Items, and our custom “Discontinued_c” field. This way sales people don’t get a choice to choose discontunued products in the system. I see I need to modify this SQS_Objects but not sure how to correctly add another condition. Any help would be great.
sqs_objects["product_part_number[" + prodln + "]"] = {
"form": "EditView",
"method": "query",
"modules": ["AOS_Products"],
"group": "or",
"field_list": ["part_number", "name", "id","cost", "price","description","currency_id"],
"populate_list": ["product_part_number[" + prodln + "]", "product_name[" + prodln + "]", "product_product_id[" + prodln + "]", "product_product_cost_price[" + prodln + "]", "product_product_list_price[" + prodln + "]", "product_item_description[" + prodln + "]", "product_currency[" + prodln + "]"],
"required_list": ["product_id[" + prodln + "]"],
"conditions": [{
"name": "part_number",
"op": "like_custom",
"end": "%",
"value": ""
}],
"order": "name",
"limit": "30",
"post_onblur_function": "formatListPrice(" + prodln + ");",
"no_match_text": "No Match"
};