Forums
>
Document Exchange
>
Search
All entry with "All Users"
Last Post 03/31/2010 5:49 AM by
Younan Younan
. 2 Replies.
Author
Messages
Younan Younan
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
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
Posts:17
03/31/2010 5:49 AM
Thanks. That works great
Forums
>
Document Exchange
>
Search