Untitled
unknown
plain_text
2 years ago
892 B
4
Indexable
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';
Editor is loading...