DimoHG

[Feature Name]

Owner: [Engineer Name] Status: Draft | In Review | Approved | In Progress | Done

Links

Type	Link
PRD

DimoHG

RedisInsight GitHub Issues Triage Report

Generated: 2026-02-02 Total Open Issues: 109 (excluding PRs) Repository: redis/RedisInsight

---

Summary

DimoHG

SELECT 
rc.app_key as app_key, 
rc.returning_customers_value_last_365_days as Repeat_Customers_Rate,
rc.sales_rate_value_last_365_days as Sales_From_Repeat_Customers,
COALESCE(pla.sms_attributed_revenue_last_365_days, 0) > 0 AS is_sms, 
COALESCE(pla.loyalty_attributed_revenue_last_365_days, 0) > 0 AS is_loyalty
FROM public_platform.retention_metrics_returning_customers rc
JOIN public_platform.orders_with_product_lines_attribution pla ON rc.app_key = pla.app_key
WHERE pla.sms_attributed_revenue_last_365_days > 0 OR pla.loyalty_attributed_revenue_last_365_days > 0

DimoHG

SELECT AVG(CASE WHEN is_sms THEN returning_customers_value_last_365_days END) AS sms_returning_customers, AVG(CASE WHEN is_sms_and_loyalty THEN returning_customers_value_last_365_days END) AS sms_and_loyalty_returning_customers 
FROM (SELECT rc.app_key, rc.returning_customers_value_last_365_days, pla.sms_attributed_revenue_last_365_days > 0 AND COALESCE(pla.loyalty_attributed_revenue_last_365_days, 0) = 0 AS is_sms, pla.loyalty_attributed_revenue_last_365_days > 0 AND pla.sms_attributed_revenue_last_365_days > 0 AS is_sms_and_loyalty 
FROM public_platform.retention_metrics_returning_customers rc
JOIN public_platform.orders_with_product_lines_attribution pla ON rc.app_key = pla.app_key
WHERE pla.sms_attributed_revenue_last_365_days > 0 OR pla.loyalty_attributed_revenue_last_365_days > 0)

DimoHG

buildNotInWhereClause: function(propertyName, excludedValues){
        if(excludedValues.length === 0){
            return null;
        } else if (excludedValues.length === 1) {
            return cds.parse.xpr(`${propertyName} != '${excludedValues[0]}'`);
        } else if (excludedValues.length > 1){
            return cds.parse.xpr(`${propertyName} not in (${excludedValues.map(id => `'${id}'`)})`);
        }
    },

DimoHG

{ref: ['*']},
    {
        ref: ['variants'],
        expand: ['*']
    },