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
       Editing Filters in Saleslogix Web Client 8.0
    Is it possible to add or remove Saleslogix filters from the List view in Accounts?
    Posted on Apr 08, 2014 by SalesLogix Support to SalesLogix Questions & Answers
     
       Bug in the Saleslogix Web LiveGrid Lookup dialog
    I recently ran into an issue with the Opportunity Products grid in the Saleslogix web client.  I cli
    Posted on Apr 04, 2014 by Kris Halsrud to Kris Halsrud's Blog
     
       Saleslogix Web Client Controls are Missing
    Every so often we hear that a user can no longer add products to an opportunity whether it is a new oppor
    Posted on Mar 24, 2014 by Mark Duthoy to SalesLogix Support
     
       Major Problem in Saleslogix v8.1 Cloud Instances
    I have been working with a new client who is on the hosted cloud solution for Saleslogix version 8.1.&nbs
    Posted on Mar 19, 2014 by Kris Halsrud to Kris Halsrud's Blog
     
       Setting the Defaults on the Insert Account/Contact Duplicate Record View
    When creating a new Account/Contact record in Saleslogix web, you have the ability to check for duplicat
    Posted on Mar 10, 2014 by Jason Buss to Jason Buss' 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