web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / smartlist designer - w...
Microsoft Dynamics GP (Archived)

smartlist designer - will not return records

(0) ShareShare
ReportReport
Posted on by Rachel Nusbaum 2,935

I created a smartlist from a view.  I created the view in SQL.  I ran the query and it returns results.

I created it in smartlist designer.

When I run it I won't complete even thought there is only one record.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Rachel,

    Have you selected the view under Smartlist builder - Security - SQL Table Security and selected the view for the required company.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Rachel -

    Babu is correct, you must set security for the view in SmartList viewer. It is also prudent to grant select privileges to DYNGRP for the view:

    GRANT SELECT ON your_view TO DYNGRP

    Finally, it is not uncommon for a SmartList to be created based on a view in a test company, and for someone to neglect to create the view in the live company database. Make sure the view exists in the company database.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Rachel,

    Harry is absolutely correct please check the same, sorry Harry I forgot the point about view is created on the test and live database as well as granting permission to DYNGRP.

  • Rachel Nusbaum Profile Picture
    Rachel Nusbaum 2,935 on at

    I did create it in both TWO, Test and Live.  We can see it when logged in as sa but cannot see it when logged in as the user.  The user is a poweruser.  This was built in designer and not smartlist builder.

    thx

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Rachel,

    Here is a link to my blog post on setting up security for SmartList Builder. Make sure you have security setup for users to access SmartList Builder objects.

    redbeardblogging.blogspot.com/.../smartlist-security-setup.html

  • Rachel Nusbaum Profile Picture
    Rachel Nusbaum 2,935 on at

    does this apply to Microsoft's version of smartlist designer?  They do not own eOne's version of smartlist builder.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Rachel -

    I apologize for the oversight.  Here is a link to an earlier forum post on how to make sure users have access rights to SmartList Designer objects.

    community.dynamics.com/.../144098

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans