About Barry_at_GU

Barry_at_GU · 05-06-2019

Hi All.I'm getting some good results on using DQL for custom reports...... but I've hit a problem with a DQL report returning many-to-many joins.1 [PATH ("directory")] has Many [USERS]1 [PATH ("directory")] has Many [PERMISSIONS]The DQL I'm using ret...

Barry_at_GU · 04-17-2019

Hi allFirst time asking a DQL quesiton, thanks for having an active forum and an opportunity to both ask and contribute.I've been all over the Programmers Refernce Guide, and while "IF" is mentioned as part of the DQL syntax, the obvious SQL-like "WH...

Barry_at_GU · 05-14-2019

Thanks @Rod_p1 I've been having a re-think on what I'm trying to achieve.What to achieve1) FOR THIS [path]: a list of available permissions ("readable_permission", "type", "appliesto" ("this folder, all subfolders, only immediate files") and permissi...

Barry_at_GU · 04-23-2019

Thanks heaps, Rod.So far, I've been "cheating" and getting away with the WHERE clause in the DQL, without incident.I'm essentially kicking the tyres and seeing how fast this baby goes around corners. The highlighting of the "EACH" and "ANY" clauses c...

VOX

User Statistics

User Activity

(DQL) many to many joins without "path_row" (navigating perms-path-perm_users objects)

DQL "IF" vs "WHERE" - what's the difference? Why?

Re: (DQL) many to many joins without "path_row" (navigating perms-path-perm_users objects)

Re: DQL "IF" vs "WHERE" - what's the difference? Why?