Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SQL View does not appe...

SQL View does not appear in smart list builder

(0) Share

Report

Posted on by Community Member

hi everyone

it seems to be a simple issue but i can't figure out where is failure point , well i've just created a view in DB and i want to create a new smart list according to this view but in smart list builder i just can not find that view , i've granted ( update , select , insert , delete ) privileges for role ( DYNGRP ) just like all other view that i can see in the smart list builder , is there any suggestions ?

*This post is locked for comments

All responses (3)

Answers (1)

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: SQL View does not appear in smart list builder

You are welcome Joseph. : )
Community Member on at

Like (0)

Report

RE: SQL View does not appear in smart list builder

thanks so much Almas
Verified answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: SQL View does not appear in smart list builder

Goto Tools>Smartlist Builders>>Security>> SQL Security Table,

There select database where you created the view and select view option on the window, it will list all the views, mark you view and save and then go make to builder window.