Login / Register  search  syndication  about

          Kris Halsrud's Blog

Kris Halsrud on development and Integration with CRM and Development

Step by step guide to creating an Account filter on RegionalManagerID in the 7.5.4 SalesLogix Web client

The SalesLogix web client there is a standard account filter for Account Manager that allows you to filter groups on specific Account Managers.  You would think that adding a filter for Regional Manager would be as simple as mimicking the Account Manager filter- well, you would be wrong.

Due to some bugginess of the filter area you have to do some rigmarole to get this to work.  here are the exact steps to follow. (note these steps are for 7.5.4 with HF 1-4).

 

Properly Building the Filter

Log into the Application Architect as Admin

In the Project Explorer (Press Cntrl+Alt+E to open) browse to VFS…Entity Model…SalesLogix Application Entities…Account…Filters.

Right click on the Filters folder and choose New Filter.

 

SalesLogix adding entity filter step 1

 

Press F4 to ensure the Properties window is open (more on that later).

You should now see a screen like this:

SalesLogix new entity filter blank

You will notice a red asterisk.  This is Sage’s way of telling you something is important!  You need to define the Property in order to save your filter.  The Property is the Entity Property you want to filter on.  If you look at the AccountManager filter that is there OOTB the Property to filter is AccountManager which is actually the entity collection object referencing the User object.  So guess what you want to put in our filter for the Regional Manager?

If you said the RegionalManager collection object- good try but wrong.  What we actually need to select here is RegionalManager.UserInfo.UserName.

Well that is obvious?

 

OK, next we need to name our filter in the Filter Name.  I am just going to call it RegMgr.  In the Display Name I will enter Reg Mgr.  Now your screen should look like this:

SalesLogix new entity filter filled in

 

Now take a look at the property window you opened earlier.  Notice the Datapath value?

SalesLogix new entity filter properties bad

 

That is a bad thing.  Having this value in here causes all kinds of troubles, including the filters not rendering properly in the web client as well as the wire client script that runs when the filter is applied being malformed and non-functional.  Did I mention it was bad?  Thing is, any custom filters added to the system get this DataPath property set.  Worse you can not remove the property from here.  But there is a way!

Here is how you go about clearing out the bad Datapath:

  • In Application Architect go to View...Virtual File System Explorer.
  • In the Virtual File System Explorer expand out the following path: Model...Entity Model...SalesLogix Application Entities...Account (Or whatever entity has the filter)You should then see an XML file formatted as "Filtername".Filter.xml.
  • SalesLogix new entity filter browsing the VFS

  • Double Click the XML filter File.
  • In the XML file you will see a property like dataPath="ACCOUNT:CUSTOMFIELDTEST"
  • SalesLogix new entity filter modifying the VFS filter
  • Remove this property.
  • Save your changes to the XML file.
  • After you have removed the datapath property through the VFS for the filters you need, do a full re-build and re-deploy.
  • Close the Application Architect.
  • Run an IISReset.
  •  
  • Properly formatting groups

     

    OK, so now we have a filter properly built from within the Application Architect and have deployed.  In order to make the filter show in the web client it the property of the filter needs to exist as a column in the current group.  You will notice that as you switch groups in the web client the list of filters available changes.

    Again if we think that we can look at an Account group that has the Account Manager filter available and working and just copy its behavior you’d be wrong.  here is what you have to do:

    In the Web client, add or edit a group.

     

    Click the layout tab.

    SalesLogix Regional Manager Added to Group Layout Step 1

     

    Now you might be inclined to add the Account.RegionalManagerID field to the layout and set the format type to “User Name”.  While this would certainly show you the data in the group it will not allow the filter to display.  Why?  Because the filter is based really on UserInfo.UserName.  So what we need to do is pull that field.  There should be a global join in the system from RegionalManagerID to the UserInfo table’s UserId.  In the upper left box scroll down until you see the table shown here:

    SalesLogix Regional Manager Added to Group Layout Step 2

     

    Now in the right box, find the UserName field shown highlighted above and add that to the layout.  You will probably want to change the Column heading to say something like “Regional Mgr”.

    Now Click OK to Save your changes to the Group.You should now see your Regional Manager filter listed and be able to use it!!!!

     

     

     

     

     

     

     

     

     

     

    What's This?
      
    Bookmark and Share

    About Kris Halsrud

       Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.


    Related Content
       Easily Showing and Hiding Tabs at Runtime in Infor CRM (Saleslogix)
    Showing and hiding tabs in the Infor CRM (Saleslogix) client should be an easy thing. It should be someth
    Posted on Dec 16, 2014 by Ryan Farley to Ryan Farley's Blog
     
       Problem setting SLXTextbox enabled property / Setting unexposed base control properties for a custom control
    I recently had an issue with a Quickform where I was attempting to set the Enabled property of a TextBox
    Posted on Dec 05, 2014 by Jason Buss to Jason Buss' Blog
     
       Checking Infor CRM (Saleslogix) Picklists for valid data
    This week I received a question about a particular picklist. One of the picklist items, when chosen, wou
    Posted on Dec 05, 2014 by Dale Richter to Infor CRM Questions & Answers
     
       Avoiding the Dirty Data Message When Programatically Redirecting to a Record in Infor CRM (Saleslogix)
    In my last post I wrote about using the OnClientClick property of a control (or button) to run JavaScript
    Posted on Dec 02, 2014 by Ryan Farley to Ryan Farley's Blog
     
       Infor CRM (formerly Saleslogix) Web- Dependency Lookup OnChange Event Not Working Correctly
    In the Saleslogix 8.1 web client the dependency lookup still has a problem with the OnChange event. 
    Posted on Nov 26, 2014 by Kris Halsrud to Kris Halsrud's Blog
     
    Comments

    No Comments

    Leave a Comment

    (required)  
    (optional)
    (required)  
    Add
    All contents Copyright © 2014 Customer FX Corporation
    Customer FX Corporation
    2324 University Avenue West, Suite 115
    Saint Paul, Minnesota 55114
    Tel: 800.728.5783

      Follow @CustomerFX on twitter
    Follow the best news, tips, and articles
      Subscribe to Customer FX on youtube
    Watch SalesLogix tutorial videos from Customer FX
    Login / Register