Project

General

Profile

Actions
Copy link

Support #75

closed

change connection live to disconnect

Added by Anju Mathew 17 days ago. Updated 10 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Anju Mathew
Start date:
26/11/2025
Due date:
03/12/2025
% Done:

0%

Estimated time:
Spent time:
0:33 h

Description

rr no 2513
connection disconnected previously but still showing live ....change to disconnect

complaint logged by pramila moodabidri

Actions
Copy link
 #1

Updated by Anju Mathew 17 days ago

  • Subject changed from chjange connection live to disconnected to change connection live to disconnect
  • Description updated (diff)
  • Assignee set to Santhosh M
Actions
Copy link
 #2

Updated by Anju Mathew 17 days ago

  • Description updated (diff)
Actions
Copy link
 #3

Updated by Santhosh Mallela 17 days ago

select * from Consumer where consumerid = 2445

-----update Consumer set ConsumerConnectionStatusID = 2 where consumerid = 2445

Actions
Copy link
 #4

Updated by Rohini Sudhir 16 days ago

Update remarks as " Same consumer have running sq no 6717 "

Actions
Copy link
 #5

Updated by Santhosh Mallela 15 days ago

  • Status changed from New to In Progress
  • Assignee changed from Santhosh M to Anju Mathew
Actions
Copy link
 #6

Updated by Anju Mathew 10 days ago

  • Assignee changed from Anju Mathew to Santhosh M
Actions
Copy link
 #7

Updated by Anju Mathew 10 days ago

  • Due date set to 03/12/2025

not updated the REMARKS "Same consumer have running sq no 6717 "

Actions
Copy link
 #8

Updated by Santhosh Mallela 10 days ago

  • Status changed from In Progress to Resolved
  • Assignee changed from Santhosh M to Anju Mathew

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')

Actions
Copy link
 #9

Updated by Anju Mathew 10 days ago

  • Status changed from Resolved to Closed

correction done consumer profile

Actions
Copy link

Also available in: Atom PDF