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

2018-03-22 03:10:59 GMT *** alfbot` is now known as alfbot

2018-03-22 07:00:46 GMT <kkore> how to use /api/audit/query/alfresco-access?fromTime=2018-2-21&toTime=2018-3-20&forward=false&limit=50&verbose=true in java to get the details

2018-03-22 08:34:14 GMT <ph_> hi guys

2018-03-22 08:34:45 GMT <ph_> I am searching for rest client for Alfresco 5.0+. I only found the unspported project on github. Any alternatives? https://github.com/Alfresco/alfresco-client-sdk

2018-03-22 08:34:46 GMT <alfbot> Title: GitHub - Alfresco/alfresco-client-sdk: Alfresco Java Client SDK (at github.com)

2018-03-22 08:37:12 GMT <Tichodroma> ph_: What is this REST client supposed to do?

2018-03-22 08:43:13 GMT <ph_> basically CRUD operations

2018-03-22 08:45:07 GMT <ph_> I guess the alfresco-client-sdk is still working, but I am not sure if it's worth using, when it's abandoned

2018-03-22 08:45:16 GMT <Tichodroma> This is still quite broad. Alfresco has a REST API that you can play with at https://api-explorer.alfresco.com/api-explorer/#/

2018-03-22 08:45:18 GMT <alfbot> Title: Alfresco Content Services REST API Explorer (at api-explorer.alfresco.com)

2018-03-22 08:45:30 GMT <Tichodroma> Any HTTP client can be used to access this API.

2018-03-22 08:45:54 GMT <ph_> I am aware of the REST explorer. I was hoping, that a nice client could make life easier ... :-)

2018-03-22 08:46:04 GMT <Tichodroma> "nice" means GUI?

2018-03-22 08:46:28 GMT <ph_> no, java sdk, so that I do not have to convert types etc...

2018-03-22 08:46:35 GMT <Tichodroma> OK

2018-03-22 08:46:57 GMT <ph_> One additional question, nearly for all requests at the REST explorer there is a note saying "available for Alfresco 5.2 and newer"

2018-03-22 08:47:05 GMT <ph_> is that really true? I would like to support Alfresco 5.0 +

2018-03-22 08:47:19 GMT <Tichodroma> I fear, yes.

2018-03-22 08:47:36 GMT <ph_> it's a pitty. Is there any rest api for 5.0?

2018-03-22 08:48:32 GMT <Tichodroma> The REST API is a rather late addition to Alfresco.

2018-03-22 08:49:31 GMT <ph_> ok. what api do you recommend to communicate with alfresco 5.0+?

2018-03-22 08:51:26 GMT <ph_> the alfresco-client-sdk is nearly a year old. I think Alfresco 5.2 was not released yet at this time?

2018-03-22 08:53:03 GMT <ph_> it seems unfortunately it is using 5.2 EA ...

2018-03-22 08:54:54 GMT <Tichodroma> It depends on the operations you want to perform. Often I implement custom web scripts and build my own API.

2018-03-22 08:55:07 GMT <Tichodroma> Of course there is not default client for such a custom API.

2018-03-22 09:09:32 GMT <yreg> morning everyone !

2018-03-22 09:37:44 GMT <kkore> how to get the latest modified/access files in alfresco java for audits ??

2018-03-22 09:45:15 GMT <yreg> kkore, I have seen your question from 3 hours ago

2018-03-22 09:46:11 GMT <yreg> Are you trying to access that information from within alfresco ?

2018-03-22 09:47:22 GMT <AFaust> kkore: Use the AuditService API in Java and execute a call to auditQuery. The AuditQueryParameters take similar parameters to that ReST API (in fact, the ReST API just wraps that)

2018-03-22 09:48:39 GMT <kkore> yreg: within alfresco

2018-03-22 09:52:35 GMT <kkore> AFaust: In REST API auditQuery where we require nodepath all but how to get the latest nodes pathParams.setApplicationName(applicationName); pathParams.addSearchKey("/alfresco-access/transaction/path", nodePath); auditService.auditQuery(callback, pathParams, Integer.MAX_VALUE); pathParams need to add nodepath??

2018-03-22 09:54:18 GMT <AFaust> You seriously need to better express yourself. I thought you wanted to query for the latest modified / accessed nodes via audit? In that case you should not need to add the search key for a path...

2018-03-22 09:55:19 GMT <AFaust> The search key on path is only useful if you already know of a specific path for which you want to have the access history.

2018-03-22 09:56:10 GMT <AFaust> Also bear in mind that path is a horribly useless search key for getting the audit history of a node, since path is volatile information changing on any rename on that path. You should typically only ever rely on specific node refs as a search key.

2018-03-22 10:01:09 GMT <kkore> ok AFaust:I will go through auditservices how to get those nodes then

2018-03-22 10:32:23 GMT <fwu> hi all

2018-03-22 10:45:33 GMT <qwebirc63677> hi

2018-03-22 10:46:30 GMT <qwebirc63677> I want to know how Activiti Api help to do bussiness process.

2018-03-22 10:57:08 GMT <bhuvana_> hi every one

2018-03-22 11:00:08 GMT <bhuvana_> i need to display alert message conformation on workflow approve and reject

2018-03-22 12:43:45 GMT <fwu> ppl anyone ever got an error like this:

2018-03-22 12:44:05 GMT <fwu> SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? ### Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "act_ru_execution" violates foreign key constraint "act_fk_var_exe" on table "act_ru_variable" Detail: Key (id_)=(13840) is still referenced from table "act_ru_variable".

2018-03-22 12:46:23 GMT <fwu> this process create new (parallel) instances of a subprocess. I dont get this error all the time. Just sometimes.

2018-03-22 12:46:59 GMT <fwu> so it seems, Alfresco is trying to delete something that is already in use. Which makes me think that it may be variables of one of the instance of the process.

2018-03-22 12:47:48 GMT <fwu> but if this is the problem, why it happens just sometimes?

2018-03-22 13:28:30 GMT <Loftux> Why would xpath with solr6 suddenly stop working? An xpatch such as /app:company_home/* returns zero results in node browser

2018-03-22 13:32:18 GMT <Loftux> Or xpath is a database only search?

2018-03-22 13:32:30 GMT <yreg> loftux

2018-03-22 13:32:40 GMT <yreg> can you provide your full search query ?

2018-03-22 13:34:21 GMT <Loftux> It is for a customer site where the picker doesn't get the children so something like /app:company_home/st:sites/templatesite/cm:documentLibrary

2018-03-22 13:34:54 GMT <Loftux> But I think it must be a db issue, works in test env, their other soon to be prod fails.

2018-03-22 13:35:01 GMT <yreg> I think you should be using PATH:"/app:company_home/st:sites/cm:templatesite/cm:documentLibrary"

2018-03-22 13:35:19 GMT <yreg> no asterisk query can be run on DB

2018-03-22 13:35:27 GMT <Loftux> Exakt same xpath, as part of the standard forms picker webscript

2018-03-22 13:35:35 GMT <yreg> and paths should work just fine in solr6

2018-03-22 13:36:08 GMT <yreg> Loftux, note that I added "cm:" to the path you pasted

2018-03-22 13:36:19 GMT * soop yawns and stretches

2018-03-22 13:36:20 GMT <Loftux> So my question is if an xpath is db only or solr

2018-03-22 13:36:51 GMT <Loftux> yreg: the path was just a quick "typo" example

2018-03-22 13:36:52 GMT <yreg> loftux you can NOT use paths in DB queries

2018-03-22 13:37:09 GMT <yreg> it's exclusively for solr search

2018-03-22 13:37:10 GMT <Loftux> So it is Solr only then that is used.

2018-03-22 13:38:00 GMT <yreg> unless if you use a special method that would actually break the Path into different components and starts resolving children one by one from store root

2018-03-22 13:38:19 GMT <Loftux> yreg: but it is an xpath search, not an alfresco fts PATH

2018-03-22 13:38:48 GMT <yreg> ah, yes, then that goes straight to DB, sorry didn't catch that detail earlier

2018-03-22 13:41:50 GMT <yreg> @Loftux, I had few problems with that before that were related to encoding parts of the path

2018-03-22 13:55:16 GMT <yreg> Just checked the code, and can not guarantee that what I have said is not outdated..

2018-03-22 14:17:58 GMT <Loftux> yreg: Turns out a full re-index of solr6 helped (stil ongoing), but the basic xpath search worked. And the user search that just returned a small number of users, now returned all as expected.

2018-03-22 14:35:51 GMT <AxelFaust> yreg: There is no support for PATH queries on the DB - with asterisk or not

2018-03-22 14:36:54 GMT <AxelFaust> Oh - you already mentioned that after your first statement of "no asterisk query can be run on DB" - so forget my statement then

2018-03-22 14:38:49 GMT <AxelFaust> yreg: Loftux: there are multiple ways to do an xpath search - either by using query() + language "xpath" or by using selectNodes(). ONLY selectNodes() will do a DB-only query, and only as long as you do not use XPath conditions that require FTS checks (with such elements you can have countless index-based sub-queries)

2018-03-22 14:39:09 GMT <AxelFaust> query() + "xpath" is basically the same as doing a PATH query in FTS

2018-03-22 14:39:20 GMT <AxelFaust> ... and index-only

2018-03-22 14:40:33 GMT <AxelFaust> Note: The Script API xpathSearch() function is doing a query() + language "xpath" call, and as such is also doing index-based searches

2018-03-22 14:41:29 GMT <yreg> AxelFaust, correct :

2018-03-22 14:41:31 GMT <yreg> !

2018-03-22 14:42:44 GMT <AxelFaust> yreg: The slides from the training 3 weeks ago mention this as well...

2018-03-22 14:44:16 GMT <yreg> AxelFaust, I haven't gotten a copy ... but I can imagine they are full of precious goodies ...

2018-03-22 14:44:48 GMT <AxelFaust> I believe they are in the internal Alfresco system...

2018-03-22 14:47:30 GMT <yreg> AxelFaust, found them :)

2018-03-22 16:42:18 GMT <fwu> back

End of Daily Log

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