RE: [Emerald] global billing group

Christian Lawrence ( (no email) )
Thu, 24 Jun 1999 17:17:34 -0500

It got erased somehow when we upgraded from SQL 6.5 to 7.0 and emerald 2.2
to 2.5. I know there is some kind of sql statement to insert it into the
table Groups but I cannot recall wording. If you could just tell me the SQL
command to insert these records.
thaks

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Josh Hillman
Sent: Thursday, June 24, 1999 5:01 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] global billing group

From: Thomas Browner <tbrowner@ddyne.com>
>How do I make a global billing group called "ALL" that will contain all of
>the billing groups using emerald 2.5.

There's already one: (Groups.GroupName='Global' and Groups.GroupID = -1).
You find references to it all over the place in Emerald Admin. Maybe using
that in some way will help you with whatever you're trying to do.

Josh