Actions
Support #75
closedchange connection live to disconnect
Description
rr no 2513
connection disconnected previously but still showing live ....change to disconnect
complaint logged by pramila moodabidri
Actions
Added by Anju Mathew 17 days ago. Updated 10 days ago.
Description
rr no 2513
connection disconnected previously but still showing live ....change to disconnect
complaint logged by pramila moodabidri
select * from Consumer where consumerid = 2445
-----update Consumer set ConsumerConnectionStatusID = 2 where consumerid = 2445
Update remarks as " Same consumer have running sq no 6717 "
not updated the REMARKS "Same consumer have running sq no 6717 "
select DistributionNodeID,ConsumerConnectionStatusID,* from consumer where RRNO='2513'
select top 10 * from RevenueCorrespondances
-- insert into RevenueCorrespondances values
(NULL,1,10,2445,GetDate(),'2513','2021-05-20',NULL,1,0,0,NULL,NULL,GetDate(),NULL,NULL,0,'Same consumer have running sq no 6717',null )
select * from RevenueCorrespondances where consumerid=2445
-- insert into RevenueCorrespondanceApprovals values
(4266,13,NULL,1,GetDate(),'Same consumer have running sq no 6717')
correction done consumer profile