Hi, We've defined some structured dates (well, extensions almost identical to structured dates) in repeating groups in Cataloging and I'm trying to get them working with advanced search. The extensions can be saved and retrieved without problems. But when I try to search on them in advanced search I run into this: Request: GET /cspace-services/collectionobjects?kw=&as=%28+%28collectionobjects_finearts%3AfaObjectProductionDate+%3E%3D+%221960-01-01%22%29+%29&pgSz=10&wf_deleted=false HTTP/1.1 Response: Search request failed: org.nuxeo.ecm.core.api.ClientException: Failed to execute query: No such property: collectionobjects_finearts:faObjectProductionDate The faObjectProductionDate does exist in the schema - the difference between it and core is that ours is in a repeating group, where as the production date in core is just repeatable. It just struck me that maybe Nuxeo couldn't even handle searching structured dates embedded this deeply- anybody know for sure? Cheers, Chris

Hi Chris - It looks like a couple of things are going wrong here. Services adv. search works on scalar fields, not structures, so it should be searching on one or both of the scalar computed values. The app layer should set this up if it recognizes the field type. It also looks like it is not using the full path to the field, if it is nested as you note. Without a valid xpath/elpath expression, services cannot find the field in the db. Again, it sounds like an app config issue. Can you send along your app config, the relevant UI snippet, and the services extension. This will help us to help you. I am pretty sure this works, if we get the config right. Patrick Christopher Pott <Christopher.Pott@smk.dk> wrote: >Hi, > >We've defined some structured dates (well, extensions almost identical >to structured dates) in repeating groups in Cataloging and I'm trying >to get them working with advanced search. The extensions can be saved >and retrieved without problems. But when I try to search on them in >advanced search I run into this: > >Request: GET >/cspace-services/collectionobjects?kw=&as=%28+%28collectionobjects_finearts%3AfaObjectProductionDate+%3E%3D+%221960-01-01%22%29+%29&pgSz=10&wf_deleted=false >HTTP/1.1 > >Response: Search request failed: >org.nuxeo.ecm.core.api.ClientException: Failed to execute query: No >such property: collectionobjects_finearts:faObjectProductionDate > >The faObjectProductionDate does exist in the schema - the difference >between it and core is that ours is in a repeating group, where as the >production date in core is just repeatable. It just struck me that >maybe Nuxeo couldn't even handle searching structured dates embedded >this deeply- anybody know for sure? > >Cheers, >Chris > > >------------------------------------------------------------------------ > >_______________________________________________ >Talk mailing list >Talk@lists.collectionspace.org >http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org -- Sent from my Android phone with K-9 Mail. Please excuse my brevity.

Hi Chris, To augment Patrick's excellent response, you might look for an existing implementation of advanced search on a structured date within a repeatable group, as a potential pattern to follow, and for any issues that might be getting in your way. Here's one place to start hunting; there is a large list of structured date fields in CollectionSpace, already implemented or planned for implementation, listed in the description of: http://issues.collectionspace.org/browse/CSPACE-3937 However, before you start looking, you might also find these JIRAs interesting ... there's a modest possibility, at least, they may pertain to your current work / issue: "Implement Structured dates in 4 fields" http://issues.collectionspace.org/browse/CSPACE-4775 (I believe one or more of those structured date fields - possibly all of them - are contained within structured groups; see specially Ray's comments) And "Incorrect behavior on advanced search form when multiple fields are added from the same repeating group" http://issues.collectionspace.org/browse/CSPACE-4903 Aron On Thu, Jan 31, 2013 at 8:42 AM, Patrick Schmitz <pschmitz@berkeley.edu> wrote: > Hi Chris - > > It looks like a couple of things are going wrong here. Services adv. search > works on scalar fields, not structures, so it should be searching on one or > both of the scalar computed values. The app layer should set this up if it > recognizes the field type. > > It also looks like it is not using the full path to the field, if it is > nested as you note. Without a valid xpath/elpath expression, services cannot > find the field in the db. Again, it sounds like an app config issue. > > Can you send along your app config, the relevant UI snippet, and the > services extension. This will help us to help you. > > I am pretty sure this works, if we get the config right. > > Patrick > > Christopher Pott <Christopher.Pott@smk.dk> wrote: >> >> Hi, >> >> >> >> We’ve defined some structured dates (well, extensions almost identical to >> structured dates) in repeating groups in Cataloging and I’m trying to get >> them working with advanced search. The extensions can be saved and retrieved >> without problems. But when I try to search on them in advanced search I run >> into this: >> >> >> >> Request: GET >> /cspace-services/collectionobjects?kw=&as=%28+%28collectionobjects_finearts%3AfaObjectProductionDate+%3E%3D+%221960-01-01%22%29+%29&pgSz=10&wf_deleted=false >> HTTP/1.1 >> >> >> >> Response: Search request failed: org.nuxeo.ecm.core.api.ClientException: >> Failed to execute query: No such property: >> collectionobjects_finearts:faObjectProductionDate >> >> >> >> The faObjectProductionDate does exist in the schema – the difference >> between it and core is that ours is in a repeating group, where as the >> production date in core is just repeatable. It just struck me that maybe >> Nuxeo couldn’t even handle searching structured dates embedded this deeply– >> anybody know for sure? >> >> >> >> Cheers, >> >> Chris >> >> ________________________________ >> >> Talk mailing list >> Talk@lists.collectionspace.org >> >> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > > > -- > Sent from my Android phone with K-9 Mail. Please excuse my brevity. > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >

Many thanks for your responses to this, and apologies it's taken me some time to follow through. I've tried to follow Arons advice, but the closest implementation I could find was a repeating date group in acquistions. This is quite different, as it's not an extension and doesn't include any other fields in the group. Also, our config is complicated by an existing bug CSPACE-5085 which steers it even further from the default examples. I've attached the current implementation details as Patrick requested. I'd appreciate any insight into this. Thanks, Chris

I'm still trying to solve this, and I noticed that the error message I originally posted doesn't match the code I attached, which creates all kinds of confusion. So the current error message is: request failed: org.nuxeo.ecm.core.api.ClientException: Failed to execute query: No such property: collectionobjects_smk:smkObjectProductionDateGroupList/*/smkObjectProductionDate /Chris -----Oprindelig meddelelse----- Fra: Talk [mailto:talk-bounces@lists.collectionspace.org] På vegne af Christopher Pott Sendt: 7. februar 2013 11:12 Til: 'Aron Roberts' Cc: talk@lists.collectionspace.org Emne: Re: [Talk] Can Collectionspace handle advanced searching for structured dates within repeating groups? Many thanks for your responses to this, and apologies it's taken me some time to follow through. I've tried to follow Arons advice, but the closest implementation I could find was a repeating date group in acquistions. This is quite different, as it's not an extension and doesn't include any other fields in the group. Also, our config is complicated by an existing bug CSPACE-5085 which steers it even further from the default examples. I've attached the current implementation details as Patrick requested. I'd appreciate any insight into this. Thanks, Chris

What was the query that produced this result, Chris? The advanced search request itself? Two artifacts that would be helpful are - around the timestamp of that error message - any actual NXQL query that appears in the cspace-services.log file, and/or the actual query to the services from the app layer - one that begins with /cspace-services/, in the relevant access log file, both of these files found in $CATALINA_HOME/logs. I'm thinking that this could conceivably be an extension schema issue rather than an 'advanced search on hierarchically-nested structured date' issue. At the least, that gives us a second angle to explore. On Mon, Feb 11, 2013 at 2:52 AM, Christopher Pott <Christopher.Pott@smk.dk> wrote: > I'm still trying to solve this, and I noticed that the error message I originally posted doesn't match the code I attached, which creates all kinds of confusion. So the current error message is: > > request failed: org.nuxeo.ecm.core.api.ClientException: Failed to execute query: No such property: collectionobjects_smk:smkObjectProductionDateGroupList/*/smkObjectProductionDate > > /Chris > > -----Oprindelig meddelelse----- > Fra: Talk [mailto:talk-bounces@lists.collectionspace.org] På vegne af Christopher Pott > Sendt: 7. februar 2013 11:12 > Til: 'Aron Roberts' > Cc: talk@lists.collectionspace.org > Emne: Re: [Talk] Can Collectionspace handle advanced searching for structured dates within repeating groups? > > Many thanks for your responses to this, and apologies it's taken me some time to follow through. I've tried to follow Arons advice, but the closest implementation I could find was a repeating date group in acquistions. This is quite different, as it's not an extension and doesn't include any other fields in the group. Also, our config is complicated by > an existing bug CSPACE-5085 which steers it even further from the default examples. > > I've attached the current implementation details as Patrick requested. I'd appreciate any insight into this. > > Thanks, > Chris > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

Hi Aron, I've attached the information you requested. I think you're correct in that it's likely to be an extension issue, but I can't get to the root of it. Thanks, Chris > -----Oprindelig meddelelse----- > Fra: aronroberts@gmail.com [mailto:aronroberts@gmail.com] På > vegne af Aron Roberts > Sendt: 11. februar 2013 17:37 > Til: Christopher Pott > Cc: talk@lists.collectionspace.org > Emne: Re: [Talk] Can Collectionspace handle advanced > searching for structured dates within repeating groups? > > What was the query that produced this result, Chris? The > advanced search request itself? > > Two artifacts that would be helpful are - around the > timestamp of that error message - any actual NXQL query that > appears in the cspace-services.log file, and/or the actual > query to the services from the app layer - one that begins > with /cspace-services/, in the relevant access log file, both > of these files found in $CATALINA_HOME/logs. > > I'm thinking that this could conceivably be an extension > schema issue rather than an 'advanced search on > hierarchically-nested structured date' issue. At the least, > that gives us a second angle to explore. > > On Mon, Feb 11, 2013 at 2:52 AM, Christopher Pott > <Christopher.Pott@smk.dk> wrote: > > I'm still trying to solve this, and I noticed that the > error message I originally posted doesn't match the code I > attached, which creates all kinds of confusion. So the > current error message is: > > > > request failed: org.nuxeo.ecm.core.api.ClientException: Failed to > > execute query: No such property: > > > collectionobjects_smk:smkObjectProductionDateGroupList/*/smkObjectProd > > uctionDate > > > > /Chris > > > > -----Oprindelig meddelelse----- > > Fra: Talk [mailto:talk-bounces@lists.collectionspace.org] > På vegne af > > Christopher Pott > > Sendt: 7. februar 2013 11:12 > > Til: 'Aron Roberts' > > Cc: talk@lists.collectionspace.org > > Emne: Re: [Talk] Can Collectionspace handle advanced > searching for structured dates within repeating groups? > > > > Many thanks for your responses to this, and apologies it's taken me > > some time to follow through. I've tried to follow Arons > advice, but the closest implementation I could find was a > repeating date group in acquistions. This is quite different, > as it's not an extension and doesn't include any other fields > in the group. Also, our config is complicated by an existing > bug CSPACE-5085 which steers it even further from the default > examples. > > > > I've attached the current implementation details as Patrick > requested. I'd appreciate any insight into this. > > > > Thanks, > > Chris > > > > > > _______________________________________________ > > Talk mailing list > > Talk@lists.collectionspace.org > > > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectio > > nspace.org >