Ryan Farley's Blog - All Comments

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

Nick Hollis — Tue, 09 Mar 2010 10:45:30 GMT

Hi Ryan,

Excellent many thanks for posting this much needed info!

I certainly needed a good excuse to stop using foreach loops to get my Ilists :)

There seems to be a few syntactical errors in the sorts though, ef should be EF and does it not need repository in front of it, i.e. repository.EF.Asc....

Thanks again,

Nick

re: Changing Label Text at Runtime

Rachel — Tue, 09 Mar 2010 00:33:23 GMT

This method can become problematic if the field has some kind of requirement on it.

This is because originally a field on the form is like this:

<label for=name>Field Name<img alt=required src='/_imgs/frm_required.gif'></img></label>

And what the above does is replace the whole thing with text.

This removes the label tag altogether and thus causes the users to lose the required/not required functionality altogether.

The way around this is to change the innerHTML like this if it is a required field:

crmForm.all.fieldname_c.innerHTML = "<label for=name>Field Name<img alt=required src='/_imgs/frm_required.gif'></img></label>"

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

Ryan Farley — Sat, 06 Mar 2010 16:16:16 GMT

Ah, thanks for catching that Phil. All fixed.

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

Phil Parkin — Sat, 06 Mar 2010 10:46:38 GMT

Hi Ryan

Check your code for

SELECT * FROM PRODUCT ORDER BY FAMILY ASC

I think you copied in a chunk about opportunities by mistake ...

Phil

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

Nicolas Galler — Fri, 05 Mar 2010 21:06:46 GMT

Thanks, I did not know about the RepositoryHelper, that reduces the amount of boilerplate code quite a bit

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

Ryan Farley — Fri, 05 Mar 2010 19:36:03 GMT

Thanks for pointing to that, I had not read those. Looking at that now. BTW, I wanted to point out that one some of those articles, like this one slxtraining.net/.../irepository-and-icriteria-basics, that the angle brackets got munched in the HTML. So things show like this:

Sage.Platform.Repository.IRepository

rep = Sage.Platform.EntityFactory.GetRepository();

instead of this:

Sage.Platform.Repository.IRepository<Sage.Entity.Interfaces.IProduct>

rep = Sage.Platform.EntityFactory.GetRepository<Sage.Entity.Interfaces.IProduct>();

:) Hate it when that happens.

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

Jason Huber — Fri, 05 Mar 2010 19:28:42 GMT

Nice post Ryan. Good job of laying it out. Training posted a few of these related articles last year too. Someone reading this might benefit from checking them out: slxtraining.net/.../icriteria . Scroll down a bit and Diane does a good job of touching on a few subjects relating to your post.

re: Community Explorer - The Desktop Client for the Sage SalesLogix Community Forums

Ryan Farley — Mon, 01 Mar 2010 19:40:36 GMT

Thanks Mike! There are some huge things on the horizon for this tool that will give you more of the warm fuzzies you got from the older newsgroups. This is just the start of things.

-Ryan

re: Community Explorer - The Desktop Client for the Sage SalesLogix Community Forums

Mike Spragg — Mon, 01 Mar 2010 19:31:35 GMT

As always, another great tool from CustomerFX team - this gives me back the control I missed from the newsgroups!

Social comments and analytics for this post

uberVU - social comments — Thu, 11 Feb 2010 05:07:32 GMT

This post was mentioned on Twitter by GeekFetch: SalesLogix Community Explorer - The Desktop Client for the Sage SalesLogix Community Forums: Ever since Sage relea... http://bit.ly/9JdW1v

re: Community Explorer - The Desktop Client for the Sage SalesLogix Community Forums

Ryan Farley — Wed, 10 Feb 2010 14:33:54 GMT

Thanks Ted!

re: Community Explorer - The Desktop Client for the Sage SalesLogix Community Forums

Ted Sturr — Wed, 10 Feb 2010 13:55:46 GMT

Ryan, You ROCK! One of the huge downsides to web based forum postings is the ability to search and lookup information. I just downloaded the program and I am looking forward to "playing" with it.

Thanks for providing such great tools for the community.

Ted

re: CRM Metadata Browser

UnTo — Sun, 31 Jan 2010 14:47:03 GMT

One could also use this tool...

http://www.soho.at/tools.html

CYa

UnTo

re: Adding a Default Sort to the Add Opportunity Products List in SalesLogix Web

Nicolas Galler — Mon, 25 Jan 2010 21:08:49 GMT

Thanks for the post! Just wanted to mention that in 7.5.2 it is in App_Code/AddOpportunityProductRequest.cs instead.

GitHub - Moving to the Cloud - Part 7

Customer FX 3.0 — Tue, 19 Jan 2010 16:47:19 GMT

Another huge win for us. We are using GitHub for team developement collaboration and source control, internally and with our clients as part of the dev team. We are also using GitHub to host our SalesLogix Open Source projects.

re: Showing a Message to the User from a Code Snippet Action in SalesLogix Web

Ryan Farley — Fri, 08 Jan 2010 16:51:02 GMT

Hi Steve,

The whole idea of business rules is that the rule is a separation of logic from the UI. The rule operates at the entity level, not on the UI. A rule is better used to return some value like a boolean, leaving the prompting of some message to the UI layer.

Eventually (in the very near future), you'll be able to invoke business rules from SData as well, which obviously could cause problems if you did UI interaction type of things in the rule.

So, back to your question, no, you can't (and really shouldn't anyway) do this sort of thing inside of a business rule. Instead, have your rule return some value and then use a DialogAction or in code display the message based on the returned value.

-Ryan

re: Showing a Message to the User from a Code Snippet Action in SalesLogix Web

Steve — Fri, 08 Jan 2010 16:41:01 GMT

Ryan,

Interesting idea - thanks...

Is there a way to use this technique for events or business rule methods?

I tried it out, but can't get it to compile. It appears that "this" and "form" are not available for use in events or business rules.

Thanks!

re: Entity Change State And Getting Previous Values in SP2

Timmus Agersea — Wed, 06 Jan 2010 03:45:27 GMT

In case anyone else comes across this very helpful article I wanted to share that I am using this technique in 7.5.2 and it works great!

Thank you Ryan!

Timmus

re: ReadOnly and Disabled Fields

KAmaldeep — Thu, 31 Dec 2009 06:36:23 GMT

Thanks.. It helped me disable the lookup fields..

re: Update to Git Extensions for SalesLogix Available

Ryan Farley — Mon, 21 Dec 2009 16:53:48 GMT

Hi Mike,

I like PuTTY (that is what I use) but it does take some extra things to set up and it won't work if it isn't "just right". I do have some video tutorials I've made for my own devs for setting Git up that I've been considering making publically available.

Anyway, glad it is working.

-Ryan

re: Update to Git Extensions for SalesLogix Available

mikeboysen@hotmail.com — Mon, 21 Dec 2009 16:19:52 GMT

Nevermind. As soon as I posted this, I tried switching my settings from PuTTY to OpenSSH and I got a command line prompt for my pass phrase. All is good!

It sill might be worth writing about.

I lost some code using a network repository so I've gone Git Hub and like it.

re: Update to Git Extensions for SalesLogix Available

mikeboysen@hotmail.com — Mon, 21 Dec 2009 16:05:40 GMT

Ryan,

I'm only able to push to my GitHub repository using Git Bash. Doing so prompts me for my SSH passphrase. When i try to set up the remote repository or do a push through the UI. It fails.

I've scoured through the docs but cannot find anything that is lighting the bulb. Can you post steps that you used to set up your remote repostory on Git Hub? I don't want to have to use the command line for everything :)

re: Showing a Message to the User from a Code Snippet Action in SalesLogix Web

Ryan Farley — Fri, 11 Dec 2009 14:45:49 GMT

Thanks Mike. In the web, your message is rendering as HTML, so you *can* include HTML in the message (so for line breaks). A message like this is valid:

dialogService.ShowMessage("This is bold. This is italics. This is on a new line, etc");

-Ryan

re: Showing a Message to the User from a Code Snippet Action in SalesLogix Web

mikeboysen@hotmail.com — Fri, 11 Dec 2009 13:17:24 GMT

Ryan,

Wow. Just in the nick of time. I don't know where you came up with this idea? Really! :)

Question: Is there something about the ShowMessage method that will not allow me to incorporate vbCrLf or Chr(10) & Chr(13) into the message for separating lines? My message is getting strung together all on the same line

Showing a Message to the User from a Code Snippet Action in SalesLogix Web

Ryan Farley's Blog — Thu, 10 Dec 2009 20:23:09 GMT

Showing a message to a user in SalesLogix Web is an easy task. It should be, right? Of course - and it is, however, you might need to know where to look to do it. This post will take a look at how to do this from both a Code Snippet Action and a C# Snippet