Site
Web
Search
Login
Home
Document Exchange
Features
Extensions
Licensing
Testimonials
Translations
Buy
DMX Extensions
Support
Forums
Downloads
Free Stuff
Translations
Company
Partners
News
Contact
Test
You are here:
Support
/
Forums
Bring2mind Forums
Forums
Search Forum
Search
Advanced Search
Topics
Posts
Unanswered
Active Topics
Forums
>
Document Exchange
>
Search
All entry with "All Users"
Last Post 03/31/2010 5:49 AM by
Younan Younan
. 2 Replies.
Sort:
Oldest First
Most Recent First
Prev
Next
You are not authorized to post a reply.
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
You are not authorized to post a reply.
Document Exchange
--Release Notes for Document Exc...
--Installation and Activation Is...
--User Interface
--Search
--Storage and Security
--WebDAV
--API
Document Exchange Lite
--Installation and Activation Is...
--Search
--Localization
--UI
--Storage and Security
--Extensions and addons
Forums
>
Document Exchange
>
Search