forums.frontrange.com Forum Index
Contact | Site Map | Global Sites
forums.frontrange.com
FrontRange Solutions Community Forum
 
FAQFAQ
SearchSearch
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesLog in to check your private messages
Log inLog in

Attention Forum Members

Forums.frontrange.com has been set to “Read Only” status.  You can no longer start new discussions or add/edit existing threads.  Instead, please access FrontRange Connect at www.frontrange.com/community and create your account for the FrontRange virtual community, FrontRange Connect. 

Sign up for an account today.  Participate in this interactive community forum and leverage the new features and functionality by going to www.frontrange.com/community.

FrontRange Connect provides users with a dependable, secure and feature-rich experience. 

Benefits of FrontRange Connect include:

·       Post discussions and provide comments just as you did in the Forum

·       The ability to create interactive Wikis, a shared workspace where you can build a knowledgebase, develop documentation, share ideas and experiences, and more

·       Additional features not found on the Forum including Event Calendaring, ability to schedule Meetings, Private Messaging and more

·       Improved stability and security over FrontRange Forum

·       Get support and resources for all FrontRange products in one location

·       A network of FrontRange experts and fellow FrontRange product users providing thousands of combined years of experience in one place

 

Filter off conthist not working

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    forums.frontrange.com Forum Index -> GoldMine - Unsupported Versions and Add-ons
View previous topic :: View next topic  
Author Message
mlplus



Joined: 26 Oct 2007
Posts: 45
PostPosted: Wed Dec 17, 2008 2:45 pm    Post subject: Filter off conthist not working Reply with quote
this filter

conthist->createon=date()-1

works in the db expression tester but not when running in a filter. any suggestions on how to get this to work?
Back to top
View user's profile Send private message
RonanC



Joined: 13 Sep 2007
Posts: 1559
Location: Naas, Ireland
PostPosted: Wed Dec 17, 2008 3:06 pm    Post subject: Reply with quote
Whats your version of GoldMine, and what backend is it using? That expression may or may not work, depending on your version.
_________________
Ronan Cruise

Certified GoldMine Corporate and Premium Edition Technician
Back to top
View user's profile Send private message
bgannett



Joined: 14 Sep 2007
Posts: 2828
Location: USA
PostPosted: Wed Dec 17, 2008 3:46 pm    Post subject: Reply with quote
Where are you trying to run this filter?  In GM's filter system?
_________________
Bob Gannett
Affordable GoldMine Support
*** Free Monthly Newsletter ***
253-627-2244
goldsupport@harbornet.com
Back to top
View user's profile Send private message
mlplus



Joined: 26 Oct 2007
Posts: 45
PostPosted: Wed Dec 17, 2008 4:17 pm    Post subject: Reply with quote
ver 6.7

running in a filter.
Back to top
View user's profile Send private message
RonanC



Joined: 13 Sep 2007
Posts: 1559
Location: Naas, Ireland
PostPosted: Wed Dec 17, 2008 4:30 pm    Post subject: Reply with quote
6.7 dBase or 6.7 SQL?
_________________
Ronan Cruise

Certified GoldMine Corporate and Premium Edition Technician
Back to top
View user's profile Send private message
mlplus



Joined: 26 Oct 2007
Posts: 45
PostPosted: Wed Dec 17, 2008 4:43 pm    Post subject: Reply with quote
6.7 DB
Back to top
View user's profile Send private message
Doug_Castell



Joined: 01 Jan 1970
Posts: 1948
Location: Los Angeles, CA
PostPosted: Wed Dec 17, 2008 5:58 pm    Post subject: Re: Filter off conthist not working Reply with quote
mlplus wrote:
this filter

conthist->createon=date()-1

works in the db expression tester but not when running in a filter. any suggestions on how to get this to work?


Filters only filter contact1 and contact2 data (and can be made to look at ampersand-macros like &emailaddress that return a one-to-one related data-piece if you really work at it)

They do NOT provide any ability to look at one-to-many items like history.  The reason the conthist value was working for you in the expression tester is probably that you were on a conthist record on the history tab at the time.

What data are you after?  All history created in the last day?  Go to View|Activity list and then to the REAL TIME tab.  You can right-click to wrangle the date range (ALL DATES wouldn't be a good idea since that would then attempt to load up ALL history in one list and could become a performance nightmare for you.)
_________________
Doug Castell

Now in the Contact Review Forums

Visit my GoldMine tips & tricks blog
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
mlplus



Joined: 26 Oct 2007
Posts: 45
PostPosted: Wed Dec 17, 2008 8:23 pm    Post subject: Reply with quote
Doug

thks for the reply,

I am trying to do an AP that will trigger on any completed sale made yesterday

can you tell me anyway to get this done?

Marty
Back to top
View user's profile Send private message
Doug_Castell



Joined: 01 Jan 1970
Posts: 1948
Location: Los Angeles, CA
PostPosted: Wed Dec 17, 2008 9:17 pm    Post subject: Reply with quote
sure, trigger on a history history activity of type SALE of age 1 day ?
_________________
Doug Castell

Now in the Contact Review Forums

Visit my GoldMine tips & tricks blog
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Chad Smith



Joined: 13 Sep 2007
Posts: 526
Location: Southeast Michigan
PostPosted: Thu Dec 18, 2008 1:11 am    Post subject: Reply with quote
Doug_Castell wrote:
sure, trigger on a history history activity of type SALE of age 1 day ?


Yep.  

... per his previous thread. http://forums.frontrange.com/viewtopic.php?t=57807
_________________
Chad Smith, Lead Consultant
Plain English CRM Solutions

The GoldMine Blog -
http://www.TheGoldMineBlog.com

The GoldMine Guide To SQL Queries -
http://www.GoldMineGuideToSQLQueries.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    forums.frontrange.com Forum Index -> GoldMine - Unsupported Versions and Add-ons All times are GMT
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group