Browse by Tags

• Database
• Development
• Entity Model
• IRepository
• Reporting
• SalesLogix
• SalesLogix Web
• SQL
• Views

• A Look at Querying Data in SalesLogix using IRepository and the SQL Equivalents

  For some who have been working in the SalesLogix LAN client for years, the transition from using SQL queries to retrieving data using a repository with the entity model can be a difficult change. This post will look at some common data retrieval methods and the SQL equivalents to help you get your head around how to get work done using the entity model. Posted Mar 05 2010, 10:17 AM by Ryan Farley with | with 12 comment(s) Tags: Development, SalesLogix Web, SalesLogix, Entity Model, Query, IRepository

• Flattening Out SalesLogix Data To Combine Multiple Rows into a Single String using SQL

  A question came up from a person attending our current Report Writing class about how to flatten out data that exists as multiple rows in the database to a single string in a report. There is a really cool trick you can do in SQL to accomplish this which I previously outlined in a post on my personal blog where I outline a technique that can be used to make a query append each value from the rows in the query to a variable. Without using cursors, you will end up with a variable that has the values appended to it as one single string which can easily be used in reporting. Posted Oct 01 2009, 10:43 AM by Ryan Farley with | with 2 comment(s) Tags: Views, Query, Database, SQL, Reporting