#87 table with tasks/extensions

[Eugene Tsuprun]

It would be helpful to have a table in the halef database that lists basic task/callflow information:

-- task/call flow name
-- the unique identifier (could be the 4-digit extension)
-- the description
-- production status (offline, online, ...)

Or maybe this already exists?

[David Suendermann-Oeft]

Indeed, this would be useful. The information you are seeking is currently scattered around:

-- task/call flow name

The closest to this is the actually used start URL which is available in the events table, e.g.

select * from events where callId = '464564c9126ebe3aadba1d8ca5671fa9@141.31.8.62' and event = 'VXML URL';

-- the unique identifier (could be the 4-digit extension)

This is available in completeCalls.

-- the description

There is no description anywhere. This could be something we require item type designers to do in OpenVXML (assign one or two mandatory variables with name and description of the application) which is then logged by the application

-- production status (offline, online, ...)

Not sure what you mean by this and why this would be relevant for your dashboard

[David Suendermann-Oeft]

I created the view completeCallsUrl featuring the startURL as well accounting for requests A and B.