I have some Database ID's. I have tried to run query to find out the corresponding nodes but it's not working. Tell me how to write a correct query using Database ID?
Asked
Active
Viewed 1,796 times
1
-
do you want to search nodes from the `Alfresco` database ?!? – Yagami Light Aug 11 '16 at 07:23
-
I am using this query to get document `SELECT * FROM cm:document WHERE IN_TREE('" + wikiFolder.getId() + "')` – Yagami Light Aug 11 '16 at 07:28
-
No not directly from database. i want to run a alfresco or solr query,i am using **sys;node-dbid:1190** but its not working – Sachin Singh Aug 11 '16 at 08:11
-
If my answer worked for you could you please accept it. If not please let us know what exactly you want to achieve. – streetturtle Aug 11 '16 at 14:50
1 Answers
5
In Node Browser (Admin Tools) you can run following query selecting lucene as language from dropdown:
@sys\:node-dbid:1190
To search with alfresco-fts option you need to escape hyphen with \:
sys\:node\-dbid:1190
streetturtle
- 5,472
- 2
- 25
- 43