I have some data placed into a UD table that I view\access from multiple clients simultaneously. I would like changes to show on user screens soon after changes without having to run queries every minute or so. What is the best way to do this?
Kind of a SignalR client notification engine?
Does epicor support Signalr?
Only in Social Notifications at the moment.
Is the social notifications utilizing persistent connection or hubs?
I honestly do not remember - this was done a couple of years ago.
All I can officially say at this time is that Client side push notification is something very common in the industry today and a logical feature cough.
All of SignalR was done a couple years ago it seems lol, Really awesome library
Can we implement SIGHUP functionality for calls from sales people and some management types?
An oldie but goodie?
What would be the consequences of adding SQL event notification to a table within Epicor? If there are none, then you could theoretically set up the SQL event notification and SQL service broker to notify a client. The client could scan for the epicor instance grab the title of the screen and compare to a mapper. Then if that title maps to using the UD table you can notify the user, outside of epicor, to hit refresh or hit refresh for them, if epicor exposes the names of the buttons on the main menu. You could use UI Automation to grab both the title and refresh button.