[opencms-dev] opencms-dev Digest, Vol 426, Issue 1. publishqueue report

[Roman Arkhipov]

Hello Andrew,

There is a way. This query could be helpful:

SELECT
    REPLACE(CMS_HISTORY_STRUCTURE.RESOURCE_PATH,
        '/sites/default',
        '') AS RESOURCE_PATH,
    FROM_UNIXTIME(CMS_HISTORY_PROJECTS.PROJECT_PUBLISHDATE / 1000) AS 'PROJECT_PUBLISHDATE',
    PUBLISHED_USERS.USER_NAME PUBLISHED_USER,
    CMS_HISTORY_PROJECTS.PROJECT_NAME,
    FROM_UNIXTIME(CMS_HISTORY_RESOURCES.DATE_LASTMODIFIED / 1000) AS 'HISTORY_RESOURCES.DATE_LASTMODIFIED',
    CMS_HISTORY_PROJECTS.PROJECT_PUBLISHED_BY,
    CMS_HISTORY_STRUCTURE.PUBLISH_TAG,
    CMS_HISTORY_STRUCTURE.VERSION,
    CMS_HISTORY_STRUCTURE.STRUCTURE_STATE,
    CMS_HISTORY_RESOURCES.RESOURCE_STATE,
    USERS.USER_NAME USER_LASTMODIFIED
FROM
    CMS_HISTORY_STRUCTURE
        LEFT JOIN
    CMS_HISTORY_RESOURCES ON CMS_HISTORY_STRUCTURE.RESOURCE_ID = CMS_HISTORY_RESOURCES.RESOURCE_ID
        AND CMS_HISTORY_STRUCTURE.PUBLISH_TAG = CMS_HISTORY_RESOURCES.PUBLISH_TAG
        LEFT JOIN
    CMS_HISTORY_PROJECTS ON CMS_HISTORY_STRUCTURE.PUBLISH_TAG = CMS_HISTORY_PROJECTS.PUBLISH_TAG
        LEFT JOIN
    CMS_USERS PUBLISHED_USERS ON PUBLISHED_USERS.USER_ID = CMS_HISTORY_PROJECTS.PROJECT_PUBLISHED_BY
        LEFT JOIN
    CMS_USERS USERS ON USERS.USER_ID = CMS_HISTORY_RESOURCES.USER_LASTMODIFIED
WHERE
        CMS_HISTORY_STRUCTURE.RESOURCE_PATH = '/sites/default/somePath'
ORDER BY CMS_HISTORY_STRUCTURE.RESOURCE_PATH , CMS_HISTORY_STRUCTURE.PUBLISH_TAG DESC


You can easily adjust it with filter by user(name) instead of resource path.

Best,
Roman Arkhipov

-----Original Message-----
From: opencms-dev-bounces at opencms.org <opencms-dev-bounces at opencms.org> On Behalf Of opencms-dev-request at opencms.org
Sent: Tuesday, 23 June, 2020 12:00
To: opencms-dev at opencms.org
Subject: opencms-dev Digest, Vol 426, Issue 1

Send opencms-dev mailing list submissions to
opencms-dev at opencms.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
or, via email, send a message with subject or body 'help' to
opencms-dev-request at opencms.org

You can reach the person managing the list at
opencms-dev-owner at opencms.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of opencms-dev digest..."


Today's Topics:

   1. publishqueue report (????????? ?????? ???????)


----------------------------------------------------------------------

Message: 1
Date: Tue, 23 Jun 2020 06:30:11 +0000
From: ????????? ?????? ??????? <adikanskii at ncfu.ru>
To: "opencms-dev at opencms.org" <opencms-dev at opencms.org>
Subject: [opencms-dev] publishqueue report
Message-ID: <1592893811815.29077 at ncfu.ru>
Content-Type: text/plain; charset="koi8-r"

Hello, All


Is there any way to search in publishqueue report? in OpenCms 10.5 ?

I'd like to know what publications made a certain user?


Andrew Dikansky.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20200623/8e89bd7f/attachment-0001.html>

------------------------------

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev

End of opencms-dev Digest, Vol 426, Issue 1
*******************************************
Roman Arkhipov
Developer

Virtual Identity AG
Grünwälderstraße 10-14
79098 Freiburg

+49 761 20758-465
--

roman.arkhipov at virtual-identity.com
http://www.virtual-identity.com

Freiburg | München | Wien | Porto

________________________________

Virtual Identity AG
Grünwälderstraße 10-14
79098 Freiburg
Amtsgericht Freiburg, HRB 6218
Vorstand: Ralf Heller
Vorsitzende des Aufsichtsrates: Kirsten Heller
Umsatzsteuer-ID: DE208002218