queries

Elasticsearch queries: Domain Specific Language (DSL)

There are several query languages to query Elasticsearch (e.g. KQL, EQL, DSL, aso), in this blog I will speak about Domain Specific Language (DSL) which is the most flexible and gives access to all Elasticsearch options!(…)

SQL Server 2016: IF EXISTS is included in the DROP command

With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested(…)

Alfresco: some useful database queries

In my previous post, I talked about the Lifecycle of Alfresco Nodes. You may have noticed that I tried to insert in my explanations some elements that are specific to(…)

Documentum: some useful queries (DQL/IAPI)

In this blog post I want to sharing some useful DQL and IAPI queries that I am using all the time. They are more dedicated to Documentum support/debug and grouped by components. In order to use them, I recommend Qdman:(…)