Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

All entry with "All Users"
Last Post 03/31/2010 5:49 AM by Younan Younan. 2 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Younan Younan
New Member
New Member
Posts:17


--
03/25/2010 7:24 AM

 Hi,

 

How do I get a list of all files that has the "All Users" permission selected?

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
03/25/2010 10:14 AM
Hi Younan,

Only through SQL. Something like this:

SELECT
e.EntryId,
(SELECT [Text] FROM {databaseOwner}{objectQualifier}DMX_ShortTexts WHERE ObjectId=e.EntryId AND TypeKey='ENT' AND SubTypeKey='TITLE') AS Title
FROM {databaseOwner}{objectQualifier}DMX_Entries e
INNER JOIN {databaseOwner}{objectQualifier}DMX_EntryPermissions ep ON e.EntryID=ep.EntryId
WHERE ep.RoleId=-1

Peter

Younan Younan
New Member
New Member
Posts:17


--
03/31/2010 5:49 AM
Thanks. That works great
You are not authorized to post a reply.