TWIN MODULE - Dyncraft

eBom vs mBom 

SELECT distinct * FROM [DataStage].[dbo].[CUMEBOM_LOADING] as CL where CL.LineSeqNbr='T0890F0' and CL.ChassisNbr='790040';

select * from EWI_DataWarehouse.dbo.OpenJITs as OJT where OJT.LineSeqNbr ='T0890F0';

select * from EWI_DataWarehouse.dbo.OpenJITs as OJT where OJT.ItemID ='M86-6301-127106';

SignalR

--ALTER DATABASE SignalR SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

SELECT is_broker_enabled FROM sys.databases WHERE name = 'SignalR';

CREATE TABLE [dbo].[ToolInfo](

[ToolID] [int] IDENTITY(1,1) NOT NULL,

[ToolName] [nvarchar](50) NOT NULL,

[Status] [bit] NOT NULL,

[SequenceNo] [nchar](10) NULL,

 CONSTRAINT [PK_ToolInfo] PRIMARY KEY CLUSTERED 

(

[ToolID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[ToolInfo] ON 

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (1, N'tool1', 0, N'1         ')

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (2, N'tool44', 1, N'1         ')

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (3, N'tool3', 1, N'2         ')

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (4, N'tool4', 1, N'2         ')

GO

SET IDENTITY_INSERT [dbo].[ToolInfo] OFF

GO

update ToolInfo set ToolName='tool44'

where ToolID=2

SignalR maintains a persistent, real-time connection between client and server by using WebSockets.

Persistent Connection:
This means that the connection between the client (such as a web browser) and the server stays open and active over a period of time, rather than opening and closing repeatedly for each communication.

SignalR leverages WebSockets or other transport alternatives:
SignalR is a real-time communication library for web applications. It primarily uses WebSockets, which is a modern protocol that allows two-way communication between the client and server over a single, long-lived connection

SignalR ensures that the client and server remain continuously connected and can send messages to each other in real-time. This is useful for applications like chat apps, live notifications, gaming, or any scenario requiring immediate updates without the need to refresh the page

https://assemblytools.na.panasonic.com/assembly-tools/accessories/controllers