Browse By Tags

  • Blog Post: 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...
  • Blog Post: How to filter a pipeline object based on filter screen values

    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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Accessing the SQL of a Filter or Search Page using the COM ASP API

    We may have a need to access the SQL clause of a search page. How can we know the SQL that is issued from a search page? Below is the code for a simple search page. [code language="javascript"] var searchBlock = CRM.GetBlock("opportunitysearchbox"); var gridBlock = CRM.GetBlock...