----- Original Message -----
From: "Dale E. Reed Jr." <firstname.lastname@example.org>
Sent: Tuesday, March 28, 2000 12:34 PM
Subject: Re: [Emerald] Is there a way to add another field to the Calls
Online view ?
> Will LaSala wrote:
> > Ok,
> > So if I add to my calls table
> > NASPortDNIS int 25
> > Will that be enough and should it be an int or varchar
> It needs to be a varchar(12) or so. The size may vary, but the
> type MUST match the dictionary type.
> > Secondly, That will allow me to have that info in my calls database,
> > and if I want it to show in a callsonline view...
> You can add the column to the calls online view, but Emerald still
> will not show it.
> > what would I need to add there?
> > You also mentioned the ServerPorts table, if all I want to do is view
> > incoming number will I need to modify this table?
> The Callsonline view is only a "view" of other data. It contains none
> itself. The real data for the callsonline view is from the Servers and
> ServerPorts (mostly) table. You would have to add the column to the
> Calls AND ServerPorts table, modify the calls trigger to update the
> column and update the CallsOnline view to include the new column.
> However, I must stress that Emerald will NOT show the new column.
> Dale E. Reed Jr. Emerald and RadiusNT
> IEA Software, Inc. www.iea-software.com
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: