topic Re: Smart Folder Template query with multiple values property in Alfresco Forum

Smart Folder Template query with multiple values property

ruudg — Thu, 14 Nov 2019 12:07:14 GMT

Hi,

I've got a folder with a multiple property called my:dossierCodes.

I want to see inside a smart folder all dossiers that has one of my codes, so I'm trying to apply this Smart Folder Template:

{
"language": "fts-alfresco",
"query": "+TYPE:'my:dossierType' AND =my:dossierCode:'<my:dossierCodes>'"
}

I have no results.

It's the first time I use multiple-value properties. How does they work in FTS queries?

Thanks

Re: Smart Folder Template query with multiple values property

venzia — Thu, 14 Nov 2019 12:16:10 GMT

Hi,

Can you post the real value used to perform the query?

KR,

Re: Smart Folder Template query with multiple values property

ruudg — Thu, 14 Nov 2019 13:06:33 GMT

The real value of my:dossierCodes is the array: ["1234", "4321"].

If I try to do this query:

+TYPE:"my:dossierType" AND =my:dossierCode"1234" OR "4321")

I get 3 nodes.

Re: Smart Folder Template query with multiple values property

venzia — Thu, 14 Nov 2019 13:46:29 GMT

Try with :

+TYPE:"my:dossierType" AND (=my:dossierCode:"1234" OR =my:dossierCode:"4321")

(maybe you will need to scape " characters)

Multivalued props are text props at the end.

KR,

Re: Smart Folder Template query with multiple values property

ruudg — Thu, 14 Nov 2019 13:56:56 GMT

This query do the same of yours, and it works fine for me:

+TYPE:"my:dossierType" AND =my:dossierCode:("1234" OR "4321")

It rapresents the result that I want to have on my smart folder.

I need to know how I could parameterize my multi-value property in the smart folder template to do this.

Re: Smart Folder Template query with multiple values property

venzia — Thu, 14 Nov 2019 15:33:47 GMT

I need to know how I could parameterize my multi-value property in the smart folder template to do this.

I think you are doing wrong assumptions, because, extracted from https://docs.alfresco.com/6.0/concepts/sf-ref-template-guidance.html :

Use angle brackets, for example, <cm:name>, to inherit property values from the physical parent folder. Used for inheritance in a filing rule and in a query.

So, basically brackets are used to inherit parent properties in nested json entries queries for smart folder templates.

Can you explain your use case in detail?

KR,

Re: Smart Folder Template query with multiple values property

ruudg — Thu, 14 Nov 2019 16:14:26 GMT

This is my data model:

<type name="my:dossierType">
	<parent>cm:folder</parent>
	<properties>
		<property name="my:dossierCode">
			<type>d:text</type>
			<mandatory>true</mandatory>
		</property>
	</properties>
</type>
..
..
..
<aspect name="my:dossierViewAspect">
	<properties>
		<property name="my:dossierCodes">
			<type>d:text</type> 
                        <mandatory>true</mandatory>
                        <multiple>true</multiple>
		</property>
	</properties>
</aspect>

I've got 3 nodes:

Called First, with my:dossierType and my:dossierCode:"1234"
Called Second, with my:dossierType and my:dossierCode:"4321"
Called View, a cm:folder the aspect my:dossierViewAspect and my:dossierCodes:["1234","4321"]

I want to see on the node called View the dossiers with the codes matching with one of my:dossierCodes values.

To do this, I added to the View node this smart folder template:

{
  "nodes": [
    {
      "search": {
        "query": "+TYPE:'my:dossierType' AND =my:dossierCode:'<my:dossierCodes>'",
        "language": "fts-alfresco"
      },
      "name": "Dossiers"
    }
  ],
  "name": "Dossiers"
}

As you see, I'm already using brackets on <my:dossierCodes>, but in the guide there's any reference about what happens when a multi-value property is inherited.

The other query I wrote on my previous post is only a sample to make you understand which result I want to receive in the View node in the end.

Thanks in advance

Re: Smart Folder Template query with multiple values property

venzia — Thu, 14 Nov 2019 16:28:03 GMT

I don't see any multi-value property in your model.

Can you show us

my:dossierCodes

sample value in node browser?

KR,

Re: Smart Folder Template query with multiple values property

ruudg — Thu, 14 Nov 2019 16:39:43 GMT

So sorry!!!

I missed it doing copy/paste

This is the right aspect definition:

<aspect name="my:dossierViewAspect">
	<properties>
		<property name="my:dossierCodes">
			<type>d:text</type>
			<mandatory>true</mandatory>
			<multiple>true</multiple>
		</property>
	</properties>
</aspect>

Re: Smart Folder Template query with multiple values property

venzia — Thu, 14 Nov 2019 16:49:05 GMT

Ok, I guess its passing all values as object.

So, View entry is "the parent" of First and Second node in json template structure, right?

Quick answer : I don't think its possible to do what you are thinking.

KR,