| GM 5.7 SQL - SQL query queston | |
Posted: Thu Jun 09, 2011 12:12 pm |
Points: 0 |
|
norbus77 |
n00b |
|
|
Joined: 12 May 2009 |
Posts: 8 |
|
|
|
|
|
|
|
|
When we "Complete a Forecasted Sale", the only place we can put the order number is in the text box. Anyone know how we can pull the contents of that box into an SQL query? I'm not even sure where that is in the data structure. TIA!
Dave |
|
|
|
|
Posted: Fri Jun 10, 2011 1:23 am |
Points: 0 |
|
ronanc |
GoldMine Veteran |
|
|
Joined: 10 Sep 2007 |
Posts: 723 |
|
|
|
|
|
|
|
|
I presume you mean into the notes box? That field is conthist.notes. Its not always possible to read the contents of that field as part of a SQL query (it is just a block of text so it doesnt read too well in the results of a query, and also if you have HTML notes turned on it will not come out in a readable format). Best thing I can say is try to add conthist.notes to the query and see what it comes out like. You can then try to tweak it as necessary. |
|
|
|
|
| | |
Posted: Fri Jun 10, 2011 10:42 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
Similarly, I stick some info in the notes field of my own completed sales. I use the following query to review sales between a specific date range:
Code: |
select conthist.ondate, conthist.duration, conthist.ref, conthist.notes, contact1.company, contact1.city from conthist, contact1 where contact1.accountno=conthist.accountno and conthist.srectype='S' and conthist.accountno in (select accountno from contact1 where state='CA') and actvcode='SFW' and resultcode='PAY' and (ondate>='01/01/2010' and ondate <='12/31/2010') order by conthist.ondate asc |
Note that I'm also filtering for the activity code, result code and state in the query. Adjust as needed. |
|
|
|
|
ContactReview Forum Index » GoldMine Legacy
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|