Friday, September 14, 2012

GoldMine : Convderting a SQL Query to a GoldMine Group

Ah, SQL. The most effective way to ask questions of your database. If you're used to using SQL queries to get information out of GoldMine, you may not know that you can convert those SQL queries (actually, the results) into a GoldMine Group!

1. Run your SQL query as usual in the SQL Query window in GoldMine.

2. Leave the results as they are, click over to the Groups Tab.

3. Right click in the top half and select "New".

4. Give your new Group a descriptive name, click Ok. (Make sure that "Build the Group" is checked)

5. In the first panel of the Group Building Wizard, select "SQL Query Records".

6. You may "Next" your way through the rest of the Wizard.

 You should now see your new Group populated with the Contacts returned by your SQL Query.

This is a great way to leverage the features of GoldMine (which almost always depend on Groups/Filters) and have your cake, too!

Note: In order to convert SQL Query results to a GoldMine Group, the ACCOUNTNO field MUST be part of the selected columns. This is the primary key that joins all GoldMine tables.


1 comment:

wei coco said...

Once I got over the sticker shock I began to attending about for some websites that action Handbags. Although it is appetizing to buy a breitling replica replica because of the cost, I absolutely wouldn't recommend it. A is just that, a acting for the absolute thing. If you anticipate about it why would you buy an apery if the absolute affair is what bent your eye?As I said it is appetizing but you will consistently apperceive it is a fake. I just anticipate the louis vuitton replicaadvised should get the acclaim for what they have done. There is annihilation like an aboriginal artist handbag.If you adulation top superior bags and shoes but can't allow the artist prices, again you should apperceive that a Gucci aperture stores is your best friend. As a appearance house, Gucci is able-bodied accepted for hermes replica perfecting the art of making archetypal momogram handbags that can bear the analysis of time. In the face of changing trends they accept managed to break advanced of the ambit by consistently afterlight thier designs and silhouettes while application the breeding that defines their style. Many of leather accoutrements are still hand-stiched and use the acclaimed GG bolt which we accept all appear to replica watches know and love. Despite their acclaimed history which includes abundant ups and downs, Gucci still remains chichi and able-bodied put calm as ever.