nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

LEFT JOIN QUERY RESULT GROUP BY OR DISTINCT

Rafael_Bueno

Hi!

Can someone help me ? I'm trying to make a LEFT JOIN QUERY, but the query return duplicate result. Its possible make a DISTINCT or GROUPBY ? Why the query return the JOIN values to ? The result dont need to show me only F.cmis:objectId as ID, F.cmis:name as name this columns ?

SELECT F.cmis:objectId as ID, F.cmis:name as name  FROM arizona:file:business F
LEFT JOIN arizona:relationship:copyrights RFC ON RFC.cmis:sourceId = F.cmis:objectId 
LEFT JOIN arizona:copyrights C ON C.cmis:objectId = RFC.cmis:targetId 
LEFT JOIN arizona:copyrights:permission P ON P.arizonaCopyrightsPermission:copyrightsId = C.cmis:objectId

Find more posts tagged with

Comments

Florent_Guillau

The CMIS Query Language does not support DISTINCT or GROUP BY. See the spec § 2.1.14.2.1 BNF Grammar.

Nuxeo returns the object id and type for each joined document because this has proven to be very useful, and is used internally. Why is it a problem? The tool that is going to consume that data will only keep what it needs anyway.

Rafael_Bueno

Florent, do you know how resolve that using some other strategy ? Do you know something about the other questions ?

Florent_Guillau

Answer edited.

Rafael_Bueno

I cant create the max itens to the paginate