Browse By Tags

  • Using SearchSQL to limit data returned by selection lists

    In the screen shot below we can see the demo user "Susan Maye" is limited to assigned the new opportunity to only people in the "Direct Sales" team. This has been accomplished by using the property of the field (a.k.a entryblock) called SearchSQL. The…
  • Coding Search Select Advanced properties in the ASP COM API

    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…
  • Using Values in workflow createscript

    Hi Have a searchselectadvanced field that has a createscript in the Case Details screen to prepare the SearchSQL statement to filter the allowable values. (EquipRec = Values("case_equipment"); FC = Values("case_faultcode"); SearchSQL="ProductGroupID…