11/26/2024 3:27:13 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Going crazy? Why isn't this working...
Posted: 19 Jul 08 2:26 PM
|
The query below is tied to a datagrid. It's designed to fill a grid with email templates that start with a dash. It works just fine - IF you're the admin, and one of my 40 users. But for all the other users, the list is blank. No error is thrown.
Looked in administrator to see any security differences, but couldn't find any. Any ideas on why this very simple query wouldn't return results for some users?
SELECT A1.PLUGINID, A1.NAME FROM PLUGIN A1 WHERE (UPPER(A1.RELEASED)='T') AND (A1.TYPE=25) AND (UPPER(A1.FAMILY)='E-MAIL')
ORDER BY A1.NAME ASC
|
|
|
|
Re: Going crazy? Why isn't this working...
Posted: 19 Jul 08 3:32 PM
|
The only thing that immediately comes to mind when someone says "This works when logged in as Admin but it doesn't when logged in as a user" is that the problem has to deal with security.
It looks like you are looking at EMail templates. Could these templates not be released to the users who get the blank datagrid? It could be you released the templates to a department so those users are able to see that template but other users won't see the email templates?
In any case, it is definately a security rights issue. Hopefully you can trace it down.
Ted |
|
|
|
Re: Going crazy? Why isn't this working...
Posted: 19 Jul 08 5:17 PM
|
Thanks for the feedback, and I was thinking a similar thing, except for 2 other factors.
1.) these templates ARE released to the users not seeing in the datagrid (because they use them every day from their write menu!) - i'm just trying to show the templates more conveniently.
2.) one user does see them, but the others don't.
it's very frustrating, because it works for two users - not really sure where else to look! |
|
|
|
Re: Going crazy? Why isn't this working...
Posted: 20 Jul 08 6:12 AM
|
The plugin table is a "special" table - and since v6.x you cannot work with it as you may have done before - as the security provider ties up the query. To test this - run your test whilst you have SLXProfiler.exe running - execute your query as Admin and you'll see it run through as you wrote it - run it as a user and I'm betting you'll see something completely unexpected (ClientSQL and ExecutedSQL).
|
|
|
|
Re: Going crazy? Why isn't this working...
Posted: 20 Jul 08 12:57 PM
|
wow - what a difference a profile makes. Turns out SLX was definitely augmenting the code before returning results, and there were all sorts of security joins that I wasn't being mindful. but, armed with the results of the profile, i was able to see the difference between a valid query and a non-valid query, and use the valid in my code.
Excellent! and thanks so much, Mike!
Tony
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|