topic Re: Duplicated sites with different title, same node in Alfresco Forum

Duplicated sites with different title, same node

calin_chiper — Thu, 11 Oct 2018 07:23:51 GMT

Recently I found a strange behavior in Alfresco. I reproduced the behavior when logged in ADF application on Internet Explorer changed the name of a site then logged in Chrome/Firefox and the changes can't be seen. I query the database using the following queryELECT n.id AS "Node ID", n.stor

Re: Duplicated sites with different title, same node

afaust — Thu, 11 Oct 2018 14:33:36 GMT

You are not selecting the site title. You are missing the relevant "title" property for this. The name (short name) of a site can never be changed after creation. Whatever you are changing to rename a site is always the title.

Re: Duplicated sites with different title, same node

calin_chiper — Thu, 11 Oct 2018 15:07:18 GMT

Yes, you’re right about it but my problem is why it returns 2 sites of “hr” short name instead of one. This appears when I update a site title from IE.

Re: Duplicated sites with different title, same node

afaust — Fri, 12 Oct 2018 14:04:00 GMT

Your query performs a simple cross-join instead of a proper left-join. This unnecessarily duplicates the results. This is completely unrelated to Alfresco which performs a correct query.