Re: [Emerald] calls table

Dale E. Reed Jr. ( (no email) )
Wed, 20 Oct 1999 10:22:25 -0700

David Edwards wrote:
> At 09:54 AM 10/18/99 -0700, you wrote:
> >Emerald wrote:
> > >
> > > In the calls table, how are the records marked once the call consolidation
> > > has counted them? I notice it doesn't count them twice but I'm not clear on
> > > what tells the program it's been counted already.
> >
> >For 2.5 and later, if status is not NULL, then they have been
> >processed.
> So if I have a bunch of records in the Calls table where status is not
> NULL. But these records had account_id NULL before I ran a consolidation
> because of a snafu in my schedule procedures. Now correct me if I'm wrong,
> but it sounds like I could go into the Calls table and set status equal to
> NULL where account_id is NULL, rerun the update_account_id stored
> procedure, then rerun consolidation to put those missed calls into the Call
> History?

I would be curious how they were processed is AccountID is NULL. I'd
have to double check, but Emerald can't consolidation records if it
doesn't know where to consolidate them to.

Your logic is correct, but it will not "add" to the current Call history
record, it will create another one for that same time frame.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: