Below is simple Query to get Qualifier associated with Customer Account
SELECT
q.qualifier_id, q.qualifier_context, q.qualifier_attr_value,
q.comparison_operator_code,q.qualifier_precedence,q.qual_attr_value_from_number,
q.qualifier_attribute
from qp_qualifiers q
where qualifier_context = 'CUSTOMER'
and q.qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
and q.comparison_operator_code = '='
and q.qualifier_attr_value = '&Enter_Customer_account_ID'
No comments:
Post a Comment