How to Query the Database to Find a Page with a Specific Label
理由
To find all the pages created by a certain user and containing a specific label.
方法
データベースで次のクエリを実行します。
SELECT * FROM CONTENT
WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT_LABEL
WHERE LABELID IN (SELECT LABELID FROM LABEL
WHERE NAME='<label name>' AND OWNER IN (SELECT USER_KEY FROM USER_MAPPING WHERE LOWER_USERNAME = '<username>')));Be sure to replace <label name> with the actual label name you're looking for, and <username> with the username you're looking for.
You may need to modify the query for your database.
最終更新日 2016 年 8 月 30 日
Powered by Confluence and Scroll Viewport.