Discussion

EF System: Automatically populate the "Talkgroup" field of the Dispatcher application

Comments: 1 - Last Comment by Rob Oesch on Feb 10, 2017  
Posted on Jul 27, 2016
 
 
(5.0)
 

TitleName/Agency Point of ContactVersion of EdgeFrontier

Automatically populate the "Talkgroup" field of the Dispatcher application
Brien Foss - South Sound 911
06.03.0000.04298

We had a business need to automatically populate the "Talkgroup" field of the Dispatcher client application, with the Radio Talkgroup value.

A Radio Talkgroup is defined by 'X units':

An 'X' Unit is code word for:

"This is not a real unit, this is the radio talkgroup you real live units should be using on the call you are currently dispatched to".

The EdgeFrontier system below leverages the IFCADSQLUpdate command, and updates the following database column on the distinct row represented by the agency_event.num_1 value.

To verify:

[] - log in to the dispatcher client for the target environment

[] - create an event

[] - dispatch a unit that begins with 'X'. There is usually at least 1 available

[] - refresh the view on the event you created, by Event\Select, then search for it... or use the other many ways to 're-view' the event. This is required because the UI does not automatically refresh on its own.

[] - ensure the "talkgroup" field is populated with the Unit you dispatched, MINUS the X. Example, dispatching XC2A, would result in C2A being in the Talkgroup field

[] - verify correct value is fdound in target database as well (<Your Database Names>)

use LIVE_930

go

select aecust1 from agency_event

where num_1 = '<yourEventNumber>'

The psuedocode for what the IFCADSQLUpdate Command is doing would be:

UPDATE Live_930.agency_event

SET aecust1 = ReturnValue_from_Action_TrimStartingXs

WHERE num_1 = [EventArgument].IFCADUnitReport.AgencyEventID

SS911_CaptureRadioTalkgroupXUnit.xml
YOUR USE OF DOWNLOADED MATERIALS PROVIDED THROUGH THIS SITE IS ENTIRELY AT YOUR OWN RISK.
See the Disclaimers section in Terms of Use.
Point your RSS reader here for a feed of the latest messages in this topic
RE: Automatically populate the "Talkgroup" field of the Dispatcher application
Posted on Feb 10, 2017 in response to: bfoss
 
   
 

Great info.  Thanks BFOSS!


Add a Comment

Please sign in on the right menu to comment.  If you do not have an account, please Join now.