Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Building a filter/group based on Attached AP's
- Thread starter imageres
- Start date
SQL query.
select * from contsupp where rectype='E'
Will return all attached AP's.
select * from contsupp where rectype='E' and address1='Super Special AP'
Will return all records with the 'Super Special AP' attached
select distinct accountno where rectype='E' and address1='Super Special AP'
Will return just the account number of the records who have this AP attached to them. With the results of that query up, you can go to the groups tab, build a group (or add members to an existing one) and use the available SQL query radio button to add those people to a group.
You can add members multiple times, based on multiple SQL queries to get yourself a nice group of people who are otherwise unrelated.
More info on using Goldmine and SQL queries:
Doug Castell
Castell Computers
(310)601-4738
select * from contsupp where rectype='E'
Will return all attached AP's.
select * from contsupp where rectype='E' and address1='Super Special AP'
Will return all records with the 'Super Special AP' attached
select distinct accountno where rectype='E' and address1='Super Special AP'
Will return just the account number of the records who have this AP attached to them. With the results of that query up, you can go to the groups tab, build a group (or add members to an existing one) and use the available SQL query radio button to add those people to a group.
You can add members multiple times, based on multiple SQL queries to get yourself a nice group of people who are otherwise unrelated.
More info on using Goldmine and SQL queries:
Doug Castell
Castell Computers
(310)601-4738
- Status
Similar threads
- Locked
- Question