Patch provides an inner join for album access table so you can filter albums view by access type:
Example Usage:
- show only albums that are "open"
- show only albums that are pass protected
- etc
Patch provides SQL query like so:
SELECT photos_album.pid AS pid, photos_album.fid AS photos_album_fid
FROM
{photos_album} photos_album
INNER JOIN {photos_access_album} photos_access_album ON photos_album.pid = photos_access_album.nid
WHERE (( (photos_access_album.viewid = '0') ))
LIMIT 5 OFFSET 0
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | 2701989-extended-patch.patch | 668 bytes | dakku |
| #2 | 2701989-patch.patch | 1.95 KB | dakku |
Comments
Comment #2
dakku commentedComment #3
dakku commentedextending patch to make access type available to images too:
Example usage:
- show all images where album access is "open"
Comment #4
nathaniel commentedThis is a great idea. I think it would be best in the photos_access sub-module since that module creates the {photos_access_album} table. Added it there in the D8 version.
Comment #5
nathaniel commentedComment #7
nathaniel commented