{
  "name" : "APIM Subscriptions",
  "id" : "APIMSubscriptions",
  "thumbnailURL" : "",
  "configs" : {
    "pubsub" : {
      "types" : ["subscriber"]
    },
    "providerConfig" : {
      "configs" : {
        "type" : "RDBMSStreamingDataProvider",
        "config" : {
          "datasourceName": "AM_DB",
          "queryData" : {
            "totalQuery": "select count(sub.SUBSCRIPTION_ID) from AM_SUBSCRIPTION sub where sub.API_ID IN (select api.API_ID from AM_API api where api.CONTEXT {{contextCondition}}) group by sub.SUBSCRIPTION_ID",
            "weekQuery" : "select count(sub.SUBSCRIPTION_ID) from AM_SUBSCRIPTION sub where sub.API_ID IN (select api.API_ID from AM_API api where api.CONTEXT {{contextCondition}}) AND sub.CREATED_TIME between '{{weekStart}}' and '{{weekEnd}}' group by sub.SUBSCRIPTION_ID"
          },
          "tableName": "AM_DB",
          "incrementalColumn": "SUBSCRIPTION_ID",
          "publishingLimit": 2147483647,
          "publishingInterval": 2147483647,
          "isPurgingEnable": false
        }
      }
    },
    "options" : [
      {
        "id" : "header",
        "title" : "Header",
        "type" : {
          "name" : "BOOLEAN",
          "possibleValues" : [
            true,
            false
          ]
        },
        "defaultValue" : true
      }
    ]
  }
}
{
  "name" : "APIM Subscriptions",
  "id" : "APIMSubscriptions",
  "thumbnailURL" : "",
  "configs" : {
    "pubsub" : {
      "types" : ["subscriber"]
    },
    "providerConfig" : {
      "configs" : {
        "type" : "RDBMSStreamingDataProvider",
        "config" : {
          "datasourceName": "AM_DB",
          "queryData" : {
            "totalQuery": "select count(sub.SUBSCRIPTION_ID) from AM_SUBSCRIPTION sub where sub.API_ID IN (select api.API_ID from AM_API api where api.CONTEXT {{contextCondition}}) group by sub.SUBSCRIPTION_ID",
            "weekQuery" : "select count(sub.SUBSCRIPTION_ID) from AM_SUBSCRIPTION sub where sub.API_ID IN (select api.API_ID from AM_API api where api.CONTEXT {{contextCondition}}) AND sub.CREATED_TIME between '{{weekStart}}' and '{{weekEnd}}' group by sub.SUBSCRIPTION_ID"
          },
          "tableName": "AM_DB",
          "incrementalColumn": "SUBSCRIPTION_ID",
          "publishingLimit": 2147483647,
          "publishingInterval": 2147483647,
          "isPurgingEnable": false
        }
      }
    },
    "options" : [
      {
        "id" : "header",
        "title" : "Header",
        "type" : {
          "name" : "BOOLEAN",
          "possibleValues" : [
            true,
            false
          ]
        },
        "defaultValue" : true
      }
    ]
  }
}
Fix APIMSubscriptions widget not working in Postgresql
Fix APIMSubscriptions widget not working in Postgresql
