Browse by Tags

• SalesLogix
• SalesLogix 7.5.1
• SalesLogix 7.5.2
• SalesLogix 7.5.3
• SalesLogix Web

• Returning the sum of fields using IRepository in SalesLogix

  One of the other things that you can do with the IRepositroy collection in SalesLogix is to perform a summation of a entity field after filtering for a group of records. Lets look at how to do this: Sage.Platform.RepositoryHelper<Sage.Entity.Interfaces... Posted May 23 2011, 11:15 AM by Kris Halsrud with | with 2 comment(s) Tags: SalesLogix Web, IRepository

• Using IRepository and ICriteria when you have 3 Or conditions

  I recently ran into a case where I had to query an Entity in SalesLogix to find records where a user was in any one of three fields. ICriteria has an Or operand but that is for comparing only two fields. So how do you do three? With Disjunction. Here... Posted Oct 14 2010, 02:57 PM by Kris Halsrud with | with no comments Tags: SalesLogix, SalesLogix 7.5.1, SalesLogix 7.5.2, IRepository, SalesLogix 7.5.3

• Retrieving the first instance of an entity record in a SalesLogix entity repository

  I wanted to share a quick little method I found the other day in the Sage.Platform.EntityFactory assembly that allows you to retreive the first instance of a record in a SalesLogix entity repository. Normally if I wanted to find the first record in a... Posted Jun 15 2010, 05:52 AM by Kris Halsrud with | with 3 comment(s) Tags: SalesLogix Web, SalesLogix 7.5.2, IRepository

• Returning a distinct result set using IRepository in SalesLogix

  Using IRepository in the SalesLogix web client can allow querying the SalesLogix entity model directly, similar to how you used to query the database directly using T-SQL queries. Ryan has already created a great post here about this, and I expanded on that here. Today I want to talk about one more functionality of the IRepository, that is how to use Projection to return a distinct list of records from your query. Posted Apr 28 2010, 11:31 AM by Kris Halsrud with | with 1 comment(s) Tags: SalesLogix Web, IRepository

• Using ICriteria and Not to exclude records in SalesLogix

  In SalesLogix you can use the Sage.Platform.Repository.ICriteria class to query the entity model using standard ICriteria. One thing I have been asked in the past is how do you exclude certain conditions? A common example might be show me all of the non... Posted Mar 04 2010, 08:39 AM by Kris Halsrud with | with 2 comment(s) Tags: SalesLogix Web, IRepository