Skip to main content

“sale_freetextsearch” MDO List

Provider for selecting a Sale. Does keyword matching and scoring across multiple string fields. Checks name, description, soundex fields as well as contact, person and project tables linked to sale. Supports cross-table matching: “Guttorm Teacup” will find sales from person “Guttorm” with title containing “Teacup”, as well as from person “Guttorm” in project “Teacup”. User’s own sales, recently added + modified sales, sales modified or created by user. Matches on word boundaries or at start of field are scored extra highly. Returns sale items only: Id = sale-id, Name = sale name, Type = “Sale”, IconHint=“deleted_item”, ExtraInfo= sale-id Completed/Done sales are marked with stylehint = “deleted_item” (but item.deleted = false) Implemented by the <see cref=“T:SuperOffice.CRM.Lists.SaleListFreetextSearchProvider”>SaleListFreetextSearchProvider</see> class. The name of the MDO list is ‘sale_freetextsearch’.

Sample Request

Sample Code

Sample Output

  • “sale_freetextsearchheadings”
  • “sale_freetextsearchheadingswithallitem”
  • “sale_freetextsearchheadingswithallitemwithnoselection”
  • “sale_freetextsearchheadingswithnoselection”
  • “sale_freetextsearchwithallitem”
  • “sale_freetextsearchwithallitemwithnoselection”
  • “sale_freetextsearchwithnoselection”