Daily Log for #alfresco IRC Channel

Alfresco discussion and collaboration. Stick around a few hours after asking a question.

Official support for Enterprise subscribers: support.alfresco.com.

Joining the Channel:

Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.

More information about the channel is in the wiki.

Getting Help

More help is available in this list of resources.

Daily Log for #alfresco

2017-08-14 06:43:11 GMT <qwebirc90744> Cheers! I need to troubleshoot an issue for a client of us. They are still running on Alfresco Community 4.2.0... Is there still a way to download the installer of this old version somewhere? Thank you.

2017-08-14 07:00:10 GMT <qwebirc90744> Cheers! I need to troubleshoot an issue for a client of us. They are running on Alfresco Community 4.2.0... Is there still a way to download the installer of this old version somewhere? Thank you.

2017-08-14 07:03:42 GMT <MorganP> 4.2.0 isn't community, it's enterprise

2017-08-14 07:04:03 GMT <MorganP> You can download old installers there: https://sourceforge.net/projects/alfresco/files/

2017-08-14 07:13:46 GMT <MorganP> qwebirc90744: is that what you wanted?

2017-08-14 07:26:26 GMT *** angelborroy_ is now known as angelborroy

2017-08-14 07:27:28 GMT <AFaust> qwebirc90744: Or you use the various file listings in the community platform, e.g. https://community.alfresco.com/docs/DOC-6210-community-file-list-42f

2017-08-14 07:27:30 GMT <alfbot> Title: Community file list 4.2.f | Alfresco Community (at community.alfresco.com)

2017-08-14 08:10:05 GMT *** angelborroy_ is now known as angelborroy

2017-08-14 09:00:11 GMT <fwu> hi all!

2017-08-14 09:03:46 GMT <qwebirc90744> MorganP: AFaust: Thank you. This helped a lot! Exactly what I was looking for!

2017-08-14 09:12:29 GMT <DarkStar1> Morning everyone

2017-08-14 09:39:35 GMT <fwu> ppl, im using the fts-alfresco language to query about the itens in a datalist. How can I filter de returned items from that list?

2017-08-14 09:40:04 GMT <fwu> im trying property_name:value but it is not returning items

2017-08-14 09:42:55 GMT <fwu> right now my query is returning all items from the list

2017-08-14 09:44:35 GMT <AFaust> fwu: What do you mean by "filter"? Normally, your query should already only select the items you want, so there should be no need to filter afterwards...

2017-08-14 09:45:26 GMT <AFaust> Otherwise simply iterate over the results and apply custom filter logic. The way you do that depends on the API layer / programming language you are using (different for Java-backed web script vs. JavaScript-backed ones)

2017-08-14 09:48:15 GMT <fwu> AFaust, what I want is exactly what you said: to retrieve only some of the items

2017-08-14 09:48:36 GMT <fwu> im applying and "and property_name:value" but is not working

2017-08-14 09:49:15 GMT <fwu> im doing this in a webscript. for testing im using javscript console

2017-08-14 09:50:49 GMT <AFaust> any do you really use property_name:value ? Can you provide an example because that pattern may be confusing - you could be using property_name as a placeholder or literally with an underscore (which would not be supported)

2017-08-14 09:51:08 GMT <AFaust> e.g. AND cm:firstName:Axel is a proper condition

2017-08-14 09:51:20 GMT <AFaust> Oh - the AND / OR are case sensitive - you cannot use them in lower-case

2017-08-14 09:51:34 GMT <fwu> im doing this:

2017-08-14 09:53:11 GMT <fwu> PARENT:"workspace://SpacesStore/810778bb-978d-4f7c-b310-e8fbd89f847f" AND ASPECT:"ri:riDataList" AND ri:codeprop:"1"

2017-08-14 09:53:29 GMT <fwu> it is returning nothing

2017-08-14 09:53:48 GMT <fwu> without the last "and" returns the two items I have

2017-08-14 09:54:07 GMT <fwu> codeprop is a datalist property/column with 1,2,3, etc

2017-08-14 09:56:27 GMT <fwu> actually, I beleive I dont need the first and either

2017-08-14 09:56:35 GMT <AFaust> I assume there is an item that actually has the value 1...

2017-08-14 09:56:45 GMT <fwu> because the parent is already pointing to the datalist I want

2017-08-14 09:56:57 GMT <fwu> yes Afaust there is. text value

2017-08-14 09:57:24 GMT <AFaust> Well - is the property defined as being indexed?

2017-08-14 09:58:32 GMT <fwu> <index enabled="true"> <tokenised>false</tokenised> </index>

2017-08-14 09:58:44 GMT <fwu> yes!

2017-08-14 10:08:03 GMT <fwu> im making this to retrieve the values: dataListItem.properties["ri:codeprop"];

2017-08-14 10:08:13 GMT <fwu> so this property is working for something

2017-08-14 10:08:26 GMT <fwu> I dont undrstand why I cant filter it

2017-08-14 10:12:07 GMT <fwu> AFaust, I did it!

2017-08-14 10:12:13 GMT <fwu> I need to do this:

2017-08-14 10:12:25 GMT <fwu> AND =ri:codeprop:"1"

2017-08-14 10:12:31 GMT <fwu> to use a equal sign...

2017-08-14 10:12:34 GMT <fwu> strange

2017-08-14 10:12:51 GMT <fwu> strange syntax

2017-08-14 10:13:00 GMT <AFaust> Well - with that you trigger "exact match" semantics and the query can go to the database

2017-08-14 10:13:19 GMT <fwu> but is it bad?

2017-08-14 10:13:24 GMT <AFaust> Without it it has to go to SOLR and there again it could be that the property or node has not been properly indexed

2017-08-14 10:13:32 GMT <fwu> ah

2017-08-14 10:13:44 GMT <fwu> but what is more quick to execute?

2017-08-14 10:13:52 GMT <fwu> the db, right?

2017-08-14 10:14:06 GMT <AFaust> ri:codeprop:"1" is perfectly valid - the major difference is that this allows similarity / partial matches using tokenisation (if allowed for the property)

2017-08-14 10:14:33 GMT <fwu> I set it to "false"

2017-08-14 10:14:38 GMT <AFaust> There is no clear winner - SOLR and DB both have their specific use-cases where each is stronger than the other...

2017-08-14 10:14:40 GMT <fwu> so it should work as expected

2017-08-14 10:14:51 GMT <AFaust> Again, check your index

2017-08-14 10:15:02 GMT <AFaust> i.e. check with the SOLR admin UI

2017-08-14 10:15:15 GMT <fwu> how I do that?

2017-08-14 10:16:30 GMT <fwu> let me open the admin page first

2017-08-14 10:20:06 GMT <fwu> should be this:https://localhost:8443/solr/

2017-08-14 10:20:07 GMT <fwu> ?

2017-08-14 10:20:10 GMT <fwu> 5.2

2017-08-14 10:20:20 GMT <fwu> on 4.2.f I think it was

2017-08-14 10:21:54 GMT <fwu> ok, it is solr4

2017-08-14 10:21:58 GMT <fwu> Im there now

2017-08-14 10:23:04 GMT <fwu> how can I see that AFaust?

2017-08-14 10:24:05 GMT <AFaust> There are multiple ways to check. Do low level queries, check low-level facets, browse the index schema and get the index terms...

2017-08-14 10:24:42 GMT <AFaust> It should even be possible to look at the indexed document via the /luke URL handler, though I have not done that myself... I usually use Luke as an offline tool

2017-08-14 10:26:09 GMT <fwu> browse the index schma looks nice. let me sse if I can do that.

2017-08-14 10:26:14 GMT <AFaust> e.g. when you browse the schema you should be able to see if that field is even contained in the index

2017-08-14 10:28:39 GMT <fwu> AFaust, it is indexed but not stored

2017-08-14 10:28:46 GMT <fwu> what this menas?

2017-08-14 10:28:48 GMT <AFaust> "not stored" is normal

2017-08-14 10:28:49 GMT <fwu> means

2017-08-14 10:28:52 GMT <fwu> stored?

2017-08-14 10:29:17 GMT <AFaust> "stored" means that the original value is also conatined in the index - in addition to the actual index terms

2017-08-14 10:29:39 GMT <AFaust> Basically "stored" would likely increase index size by 80-120%

2017-08-14 10:29:54 GMT <fwu> so it is not necessary to search, right?

2017-08-14 10:30:19 GMT <AFaust> If it were necessary there would be not option to set it to "not stored", right?

2017-08-14 10:30:46 GMT <fwu> ok

2017-08-14 13:05:44 GMT <Ziberius> hello

End of Daily Log

The other logs are at http://esplins.org/hash_alfresco