Coding Search Select Advanced properties in the ASP COM API

Hints, Tips and Tricks

Technical Hints Tips and Tricks that cover customization and development using Sage CRM. API usage and coding are covered.

Coding Search Select Advanced properties in the ASP COM API

  • Comments 3
  • Likes
I steal from colleagues and now I shamelessly steal from partners. This is a good example of coding the properties of a Search Select Advanced field in an ASP page.

The most important thing to point out is that this shows how to use the search sql property.



EditBlock=eWare.GetBlock("FulfillmentOneNewEntry");
with (EditBlock)
{
GetEntry("fulf_contractidone").Caption = "Contract";
GetEntry("fulf_contractidone").SearchSQL = "cont_companyid = " + compID;
GetEntry("fulf_productofferingidone").Caption = "Product Offering";
GetEntry("fulf_productofferingidone").Restrictor = "fulf_contractidone";
}

Comments