Currently viewing the tag: "table"

Using Id fields of entities on screens and lists

By On May 4, 2011

Ideally speaking this will not be an out of box feature that everybody needs in CRM, however I came across many such requirements these days where people either wanted to use id fields on the screen as unique reference values. Some just wanted to display them on the screen for viewing purpose. Some wanted to [...]

Continue Reading →

Open up hidden tables for editing in CRM.

By On October 1, 2010

Last weekend I got a chance to visit a holiday resort by the lake side. It was just heavenly with the silence and peace, to be woken up in the morning by the chirping birds rather than the blackberry alarm, trekking, swimming. Ahhh! Just awesome. The hectic life in the city does make you appreciate [...]

Continue Reading →

Identity increment in CRM tables

By On September 23, 2010

Primary keys in SQL tables allow us to uniquely identify the rows. These keys also allow us to establish the relationship between tables based on foreign key-primary key concept.

Though we can have different id field names in CRM tables, the standard primary key feature is well maintained with field names like “_” (e.g. Case_CaseId). [...]

Continue Reading →

Avoid refreshing page after clicking tab for custom entity

By On February 14, 2009

If we make use of the Tab groups in custom pages for the custom entity, sometimes we get unnecessary crashing errors after clicking on tab twice.

Using this script you can restrict user not to click tab again, once the page is submitted.

You can mould this script for any content according [...]

Continue Reading →

Query to Find out Duplicate records in SageCRM Table

By On December 17, 2008

Below is an example of a SQL query which you can use in a scenario where you want to display a list of duplicate records which are stored in a particular table.

Below is the query that has been used to do the needful on the Leads entity (where Client wanted to have the list [...]

Continue Reading →