Data Usage posted for networks  : [

Network(id=5938388b-fb0b-434f-b311-6c36f03527e1, networkGroupId=f95db4c6-e641-4c8a-aa42-fe3cd1b78101, name=TZ-Production, productVersion=7.3.95, status=PROVISIONED, deletedAt=null),

Network(id=9f1e1953-5785-4480-a840-84a3c1e4de2a, networkGroupId=f95db4c6-e641-4c8a-aa42-fe3cd1b78101, name=TZ-Staging, productVersion=7.3.93, status=PROVISIONED, deletedAt=null)]


Data Usage posted for networks  : [
Network(id=520b56a5-088d-4658-9bbc-0f1a7e6fd050, networkGroupId=f95db4c6-e641-4c8a-aa42-fe3cd1b78101, name=TZ-SA Network, productVersion=7.4.0, status=PROVISIONED, deletedAt=null),

Network(id=5938388b-fb0b-434f-b311-6c36f03527e1, networkGroupId=f95db4c6-e641-4c8a-aa42-fe3cd1b78101, name=TZ-Production, productVersion=7.3.95, status=PROVISIONED, deletedAt=null),

Network(id=9f1e1953-5785-4480-a840-84a3c1e4de2a, networkGroupId=f95db4c6-e641-4c8a-aa42-fe3cd1b78101, name=TZ-Staging, productVersion=7.3.93, status=PROVISIONED, deletedAt=null)]



---Defect check . Need to verify why overage on 2024-05-31 is not returning using below query. 

 I need to verify code level query, how that sql going to be generated. 


SELECT 
    BIN_TO_UUID(mo.id),
    BIN_TO_UUID(mo.overageSubscriptionId),
    mo.*
FROM
    MeteredOverage mo
WHERE
    mo.overageSubscriptionId = UUID_TO_BIN('845dfb42-d6f8-4ce8-96cf-1418a390acec')
        AND mo.postingDate BETWEEN '2024-05-01' AND '2024-05-31'
ORDER BY mo.postingDate ASC;

----Query generated from code

 
 SELECT 
    meteredQuantity,
    notes,
    overageSubscriptionId,
    id,
    postingDate,
    meteredItemPriceId
FROM
    MeteredOverage
WHERE
    (overageSubscriptionId = '845dfb42-d6f8-4ce8-96cf-1418a390acec'
        AND postingDate >= '2024-05-01 14:00:00.0'
        AND postingDate <= '2024-05-31 14:00:00.0');




-----sql fix 


SELECT 
    BIN_TO_UUID(mo.id),
    BIN_TO_UUID(mo.overageSubscriptionId),
    mo.*
FROM
    MeteredOverage mo
WHERE
    mo.overageSubscriptionId = UUID_TO_BIN('845dfb42-d6f8-4ce8-96cf-1418a390acec')
        AND DATE(mo.postingDate) BETWEEN '2024-05-01' AND '2024-05-31'
ORDER BY mo.postingDate ASC;





























--f95db4c6-e641-4c8a-aa42-fe3cd1b78101
SELECT BIN_TO_UUID(resourceId),BIN_TO_UUID(contractId) FROM BillableResource where contractId=UUID_TO_BIN('38c4ea0c-098b-4c8a-b517-400474dca55f');

select BIN_TO_UUID(c.id),BIN_TO_UUID(c.accountId),c.* from Contract c where c.id=UUID_TO_BIN('38c4ea0c-098b-4c8a-b517-400474dca55f');

select BIN_TO_UUID(c.id),BIN_TO_UUID(c.accountId),c.* from Contract c where c.accountId=UUID_TO_BIN('11559b5c-e555-49a0-96f4-7901026261d0');

select BIN_TO_UUID(os.id),BIN_TO_UUID(os.contractId),os.* from OverageSubscription os where os.contractId=UUID_TO_BIN('38c4ea0c-098b-4c8a-b517-400474dca55f');

SELECT 
    BIN_TO_UUID(mo.id),
    BIN_TO_UUID(mo.overageSubscriptionId),
    mo.*
FROM
    MeteredOverage mo order by mo.postingDate desc;

SELECT 
    BIN_TO_UUID(mo.id),
    BIN_TO_UUID(mo.overageSubscriptionId),
    mo.*
FROM
    MeteredOverage mo
WHERE
    mo.overageSubscriptionId = UUID_TO_BIN('845dfb42-d6f8-4ce8-96cf-1418a390acec')
        AND DATE(mo.postingDate) BETWEEN '2024-05-01' AND '2024-05-31'
ORDER BY mo.postingDate ASC;

select BIN_TO_UUID(os.id),BIN_TO_UUID(os.contractId),os.* from OverageSubscription os where os.id=UUID_TO_BIN('845dfb42-d6f8-4ce8-96cf-1418a390acec');


SELECT BIN_TO_UUID(mo.id),BIN_TO_UUID(mo.overageSubscriptionId),mo.* FROM MeteredOverage mo where mo.overageSubscriptionId in (select os.id from OverageSubscription os where os.contractId in (select c.id
 from Contract c where c.accountId=UUID_TO_BIN('11559b5c-e555-49a0-96f4-7901026261d0')) and os.deletedAt is null and os.status=true)
 and mo.postingDate between '2024-05-01' and '2024-05-31' order by mo.postingDate asc;
 
 --3b152751-41e7-4b99-bbb2-b81cfccab68e
 
 --- testing only
 
 --37678cdd-4a0d-4187-a380-2c4e45a98773
 --d01a6764-a3aa-414b-afb3-f881e3d166e9
select BIN_TO_UUID(c.id),BIN_TO_UUID(c.accountId),c.* from Contract c where c.id=UUID_TO_BIN('37678cdd-4a0d-4187-a380-2c4e45a98773');
select BIN_TO_UUID(os.id),BIN_TO_UUID(os.contractId),os.* from OverageSubscription os where os.contractId=UUID_TO_BIN('37678cdd-4a0d-4187-a380-2c4e45a98773');

SELECT BIN_TO_UUID(mo.id),BIN_TO_UUID(mo.overageSubscriptionId),mo.* FROM MeteredOverage mo where mo.overageSubscriptionId in (select os.id from OverageSubscription os where os.contractId in (select c.id
 from Contract c where c.accountId=UUID_TO_BIN('d01a6764-a3aa-414b-afb3-f881e3d166e9')) and os.deletedAt is null and os.status=true)
 and mo.postingDate between '2024-05-01' and '2024-05-31' order by mo.postingDate asc;
 
 
 
SELECT 
    meteredQuantity,
    notes,
    overageSubscriptionId,
    id,
    postingDate,
    meteredItemPriceId
FROM
    MeteredOverage
WHERE
    (overageSubscriptionId = UUID_TO_BIN('449511b5-b65f-4327-acd4-637836217118')
        AND postingDate >= '2024-05-01T00:00:00Z'
        AND postingDate <= '2024-05-31T23:59:59.999Z');

select BIN_TO_UUID(os.id),BIN_TO_UUID(os.contractId),os.* from OverageSubscription os where os.id=UUID_TO_BIN('449511b5-b65f-4327-acd4-637836217118');