Widget Document Suggestion how to query on two fields?

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Mathilde_Viveri

Hello,

In my layout I would like to be able to search a document but be able to search either on its name or on its code. I tried several things with the nxql query but couldn't make it work. I thought about the javascript formatter but I think it wouldn't help me search on both field.

Here's what I tried: SELECT * FROM myDocType WHERE dc:title = '%?%' OR mySchema:code = '%?%'

but obviously it's not working. I get an empty response from the servor. Would you have any idea how to achieve this ? Or if it's even possible ?

Thanks

pibou_Bouvret

You can use your widget's custom parameter : "operationId" and set its value to the name of your contributed custom operation. There is an example with javascript automation here : https://www.nuxeo.com/blog/fun-suggestion-widget-javascript/