topic Re: Searching for files in a folder by property in Alfresco Archive

Searching for files in a folder by property

stuart_turner — Wed, 08 Aug 2007 16:02:41 GMT

Hi,I'm trying to call the web services to search a folder to find a file(s) which match a certain criteria.The property on the file is something like:Name: {ORS}tenantref Value: 259499I used the following code to find the folder I need (c#.NET): reference = new Reference(); .store = spacesStor

Re: Searching for files in a folder by property

gis-olli — Fri, 10 Aug 2007 09:18:22 GMT

I have the same problem. I`m trying to search content via the Web Service API related to a specific property. I have created an own ContentModel with some additional properties. Now i try to search via this properties. If i search only for a some text like:

Query query = new Query(Constants.QUERY_LANG_LUCENE, "TEXT:'anExampleText'");

        // Execute the query
        QueryResult queryResult = repositoryService.query(STORE, query, true);

i get the Results e.g.:
row 0: {http://www.alfresco.org/model/content/1.0}PLZ = 26188

This is a property, i added to my Content Model. Now i want to search "backwards" e.g. i want to search the property PLZ.
Can anyone post some code examples?

Thx

Re: Searching for files in a folder by property

gis-olli — Fri, 10 Aug 2007 11:33:41 GMT

Now i solved the Problem. You only have to change the query statement:

Query query1 = new Query(Constants.QUERY_LANG_LUCENE, "+@\\{http\\://www.alfresco.org/model/content/1.0\\}property1:\'value1\" AND (TYPE:\"{http://www.alfresco.org/model/content/1.0}content\")");

        // Execute the query
        QueryResult queryResult = repositoryService.query(STORE, query1, true);

Re: Searching for files in a folder by property

stuart_turner — Mon, 13 Aug 2007 10:17:19 GMT

Hi, I solved my issue too by using the following code:

                Query query = new Query();
                query.language = "lucene"; // 2 types "lucene and xpath"
                query.statement = "+PARENT:\"workspace://SpacesStore/" + schema.id + "\"" + "+@ors\\:tenantref:259499";
                result = repositoryServiceWSE.query(spacesStore, query, true);