Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
892 B
1
Indexable
Never
 hcar_entity          | Subscription
 hcar_clv_attr        | locationCode
 hcar_clv_band_rules  | null
 hcar_clv_filter_rule | clvattrvalue=[v['locationCode'] for k,v in hcad_attr_dtls.items() if 'locationCode' in v and 'subsStatusId' in v and v['subsStatusId'] == '2'];clvattrvalue = str(list(set(clvattrvalue))).replace("'",'"');
 hcar_clv_format      | null
 hcar_clv_txn_attr    | subscriptionDetails
 hcar_duration_indays | null



update hobs_ods_staging.hos_clv_attr_rules set hcar_clv_txn_attr='subscriptionDetails',hcar_clv_filter_rule=$$clvattrvalue=[v['locationCode'] for k,v in hcad_attr_dtls.items() if 'locationCode' in v and 'subsStatusId' in v and v['subsStatusId'] == '2' and v['locationCode'] != ' ' and v['locationCode'] == 'NULL'] ;clvattrvalue = str(list(set(clvattrvalue))).replace("'",'"');$$ where hcar_entity='Subscription' and hcar_clv_attr='locationCode';