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
       Can I Bind an Attachment to a Specific Activity in Infor CRM version 7.54?
    Recently I had a user ask if they could bind an attachment to a specific Activity within Infor CRM??
    Posted on Jul 07, 2015 by Dale Richter to Infor CRM Questions & Answers
       Infor CRM (Formerly Saleslogix) Iterating through all tabs on a Page
     Using the TabWorskpace you can iterate through all the tabs on a page and do something with them, l
    Posted on Jun 19, 2015 by Kris Halsrud to Kris Halsrud's Blog
       Infor CRM (Formerly Saleslogix) Hiding Tabs at Runtime Without Using Modules
     As Ryan wrote a long time ago, you can create a module and add it to a page in the Infor CRM web cl
    Posted on Jun 10, 2015 by Kris Halsrud to Kris Halsrud's Blog
       How I assign ownership to a group of Leads in Infor CRM?
    There is a tool within Infor CRM to align Accounts to different Account Owners. It is called Territory Re
    Posted on Jun 05, 2015 by Dale Richter to Infor CRM Questions & Answers
       Infor CRM (Formerly Saleslogix) Adding a Client Side Confirmation on a Dependency Lookup in the Web Client
     We recently had a client who wanted to have a user confirmation prompt before a user was allowed to
    Posted on May 28, 2015 by Kris Halsrud to Kris Halsrud's Blog

    No Comments

    Leave a Comment

    All contents Copyright © 2015 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