Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Discovering Data Relationships in Code
You may have a business requirement to cascade a change through the child records of a company. I have discussed previously how a table level script can be used to update all opportunities if the company is reassigned to a new account manager. See the article " A Table Level Script to update Opportunities...
13 Sep 2010
How to filter a pipeline object based on filter screen values
Sage CRM Team
We know that a LIST block can be filtered based on a standard filter screen block via var filter = eWare.GetBlock("MyFilterBoxName"); var list = eWare.GetBlock("MyListName"); list.ArgObj = filter; Can we filter a pipeline object in a similar fashion? Unfortunately you cannot...
24 Apr 2009
Creating a Dynamic Group in Sage CRM using the COM object TargetLists
The COM API has an object within it called TargetLists. This object can be used within internal script (Validate, Table Level Script etc) to create both Dynamic and Static Groups. Below is a simple example of the object being used in an ASP page to create a Dynamic Group. You will see that I had...
20 Jan 2010
More Adventures with the Library
I have been investigating the list of documents that appears under the Company tab group. This is actually part of a set of investigations into the library entity that I am working on. So there will be a few more blogs about documents and the library in the near future. I wanted to find out how to ensure...
31 Jan 2008
MSSQL Index analysis and creation from Sage CRM (Part 1 of 2)
This article has come from a very experienced colleague in Australia. Introduction Microsoft SQL Server 2005 added new system tables to assist in the system reporting. Three of these tables in particular are written to every time a query is run. Microsoft SQL Server 2005 processes each query, determines...
5 Mar 2009
Accessing the SQL of a Filter or Search Page using the COM ASP API
13 Mar 2009
© The Sage Group plc 2019
All Rights Reserved