Solved

Goldmine/Crystal: What is CONTSUPP.RECTYPE='P'

Posted on 2006-06-12
3
909 Views
Last Modified: 2012-06-27
Hi,
We run Crystal Reports against our Goldmine DB. I see in some queries CONTSUPP.RECTYPE='P'
Can some one please explain what this means and are there other values besides 'P'.

We have a report that contains...

WHERE
    CONTSUPP.CONTACT = 'Products' AND
    CONTSUPP.RECTYPE = 'P

...and I'm trying to figure out what kind of report this produces.
0
Comment
Question by:veedar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Expert Comment

by:wykabryan
ID: 16887352
It would be a guess, because I do not know the database architexture as it ties in with the front end, but because it is a single character this would indicate a flag of some sort.  I would suggest that you talk to your GoldMine Administrator as there is a workflow frontend that will tell you exactly what the field is used for.
0
 
LVL 16

Accepted Solution

by:
wykabryan earned 396 total points
ID: 16887383
Based on looking up GoldMine for that table here is the following.
contsupp
rectype
 Description
E
 Automated Process attached event
H
 Extended profile header
L
 Linked document
O
 Organizational chart
P
 Profile record/extended profile record
R
 Referral record
 
The RECTYPE value H can be linked to records with the RECTYPE value P. Assigning extended information settings to a profile (assigned to a tab, or extended fields used) creates an H record type to store the settings. The profile record stores a character string in the Phone field that matches the H record’s AccountNo field.


There are additional information about GoldMine tables and description at this link:
http://www.dcsgroupllc.com/dcscrmsql/tutorials/goldmine_sql_query_tutorial.html

Hope this helps.
0
 
LVL 15

Author Comment

by:veedar
ID: 16888592
Thank you wykabryan....I sort of inherited this from someone who left the company so I am the GM admin. You mentioned a workflow front end.  That sounds interesting can you tell me how I can get into that?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Suggested Courses

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question