Open Forum

Expand all | Collapse all

Permissions - Searching for table names

  • 1.  Permissions - Searching for table names

    Posted May 01, 2019 03:50 PM
      |   view attached
    We are working on the upgrade to Navision 2018.  I have stumbled upon a roadblock for adding tables to permission sets.   In our current environment, Nav 2016,  when on Permissions Page  (page 9803) we are able to add tables by the searching the filter box or by Control F (find) and search by the object name in the drop down menu.    In 2018, the filter box is missing and the Ctrl/F menu box is missing the Object Name field.   Has anyone had this issue and do you have a work around?  Other than searching for Object Designer first by object name and then going back to Permissions to add the permissions; is there a quicker way to search for and add a table(permission) to a permission set within the Permissions Page?

    Old and New view are displayed in the attachment.

    Thank you .

    Lori

    ------------------------------
    Lori Parent
    Application Support Specialist
    Stonewall Kitchen
    York ME
    ------------------------------

    Attachment(s)



  • 2.  RE: Permissions - Searching for table names

    TOP CONTRIBUTOR
    Posted May 01, 2019 04:54 PM
    ​You just need to turn on the filter pane.

    Turn on Filters

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    ------------------------------



  • 3.  RE: Permissions - Searching for table names

    Posted May 02, 2019 08:02 AM
    Good Morning Lewis,

    Thank you for the great tip.  The Object Name (table description) is still not in my drop down and I cannot search for it.  Is it that way for you to?

    menu

    ------------------------------
    Lori Parent
    Application Support Specialist
    Stonewall Kitchen
    York ME
    ------------------------------



  • 4.  RE: Permissions - Searching for table names

    TOP CONTRIBUTOR
    Posted May 02, 2019 08:13 AM
    The filter drop down (right side) will only show the columns you have displayed.  If you are not showing the Object Name on the Page it will not be in that filter drop down.  Use "Choose Columns" to show the Object Name field, which would add it to the filter drop down.

    You should still be able to use the Advanced Filter (left side), which allows you to filter on any field in the table regardless of whether it is displayed on the Page.

    ------------------------------
    Ben Baxter
    Consultant
    Accent Software, Inc.
    carmel IN
    ------------------------------



  • 5.  RE: Permissions - Searching for table names

    Posted May 02, 2019 08:26 AM
    Hi Ben,

    Thank you.   I am displaying the Object Name in my page.  I still don't see if in my drop down menu.  I just had my developer look at this field and it is a function.  I am able to get to that field through the Advanced Filter, go to All and see in the list.

    Thank you. This is a good workaround.

    Lori

    ------------------------------
    Lori Parent
    Application Support Specialist
    Stonewall Kitchen
    York ME
    ------------------------------



  • 6.  RE: Permissions - Searching for table names

    TOP CONTRIBUTOR
    Posted May 03, 2019 09:16 AM
    Hi Lori,  I checked my NAV2018 playground vs.my live NAV2013R2 system and I see the same behavior as you.  NAV2013R2 has the objet name in the quick filter drop-down and NAV2018 does not.

    There may be a setting on the table or page to select what fields appear on the quick filter, but I don't see anything and for whatever reason, I cannot see page objects for my NAV2018 playground, I can only see table objects.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    ------------------------------



  • 7.  RE: Permissions - Searching for table names

    Posted May 03, 2019 04:00 PM
    Hi Lewis,

    Thank you for your additional look at this.  I will review with my developer (Jason Wilder).
    I have a workaround but it takes much longer than it used to.
    Lori

    ------------------------------
    Lori Parent
    Application Support Specialist
    Stonewall Kitchen
    York ME
    ------------------------------



  • 8.  RE: Permissions - Searching for table names

    TOP CONTRIBUTOR
    Posted May 03, 2019 05:24 PM
    I'm sure that Jason will figure it out. ​

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    ------------------------------



  • 9.  RE: Permissions - Searching for table names

    TOP CONTRIBUTOR
    Posted May 10, 2019 07:37 AM
    We fixed this by hiding the ObjectName field (which is actually a function so you can't filter or search) and adding back the original flowfield called Object Name.  Now we can filter and search by this field like we could in NAV 2016.  Also there is a property on the Page called ShowFilter which we changed from No to Yes.  This allows you to actually show the filter and keeps it open for next time you come into the screen.

    Here is why Microsoft made this change in NAV 2018.  If you enter a 0 in Object ID it shows blank for Object Name if you use the old Object Name.  Now it will show something like this: "All objects of type Table" in the new Object Name control.  That's the only reason they did this change as far as I can see.  Totally does not seem worth losing the filtering capability just for a few extra words!

    Here is a screen shot of what I am talking about:
    Permission Screenshot
    Also I will mention that when I went to do this in AL as a page extension it was not possible.  The Object name field (Lookup flowfield) gave me an error when I tried to deploy it (could be a glitch in my version of NAV 2018 or could be you can't add a flowfield to a page extension).  Also in NAV 2018 AL we do not have access to the ShowFilter property so this could not be done (not sure if they have added the ability to do this in BC yet).  So I ended up doing this in C/AL since we are running a hybrid mode of AL and C/AL.

    ------------------------------
    Jason Wilder
    Senior Application Developer
    Stonewall Kitchen
    York ME
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role