Alfresco discussion and collaboration. Stick around a few hours after asking a question.
Official support for Enterprise subscribers: support.alfresco.com.
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.
More help is available in this list of resources.
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
The other logs are at http://esplins.org/hash_alfresco