I would like to share some of SQL queries for Alfresco database which could be useful.
After several days of using my Lenovo m5400 I faced serious problem with built-in touchpad. Sometimes it didn't work at all, sometimes every touch I made was understood as scrolling, sometimes it was stuck for several seconds and started to work again. Here is solution to this problem!
I am big fan of Ubuntu, but I've never liked the Unity shell, so I was using a Gnome shell mostly. But recently I decided to switch to the Awesome window manager. I watched few videos of it and I quite liked the idea of being able to control size and number of windows per workspace. So I've installed it and here want to share some of my problems with solutions.
Probably you even didn't have enough time to have a look on pop-up window because in case of successful upload it immediately hides. Which is quite sad because it could show a bit more to the user than just a status of upload. I will show how to improve this component and get a bit more from it. This article is split in two parts. This one covers the UI changes. The second one will show how to extend functionality of upload webscript. I'll post a link to it here when it would be written.
I was quite surprised when discovered that out-the-box alfresco RM doesn't audit document view action. After suffering for a while I've finally managed to turn it on!
For better understanding of Alfresco sometimes it's needed to see Alfresco tables. Here I'm showing how to connect to Alfresco Postgre database on a server and to h2 database during development.
Recently I've started discovering some new features of regular expressions which I didn't know before. Here I want to share some of these discoveries. Also I would like to write some useful patterns which are needed sometimes, but to write them from scratch could take some time.
Alfresco 5.0.a is the first version with faceted search support. By default it supports 7 facets. Here I'll show how to add custom facets on custom metadata.
Here I'm showing how to wipe alfresco database.
This post describes how to change Alfresco environment for DB connection using command line arguments.