HQL query to search by ContentProperty

Question

Hi,

I'm working on a Confluence Server plugin using CustomContentEntityObjects as outlined in https://bitbucket.org/resah/confluence-custom-content-example. Creating and storing the entities works like a charm and I can use HQL to fetch them using several different fields of CustomContentEntityObject (e.g. title or body).

However, I cannot for the life of me, figure out how to find objects using ContentProperties. As an example I have this code when setting the property:

contentEntityObject.getProperties().setLongProperty(PAGE_ID_KEY, page.getId());
// ...
customContentManager.saveContentEntity(contentEntityObject, SAVE_CONTEXT);

How can I retrieve this object using the page id?

Kind regards,
Christopher

Christopher Klinge_efjwzq · Answer

I knew that already. My goal was to retrieve CustomContentEntityObjects using HQL without having to do additional filtering in Java. See my answer to this question for a solution.

Well, scratch that. The language filter does not permit submitting my source code.

Sahal Saad · Answer

Hi,

I belive you can find the Content properties using getLongProperty:

contentEntityObject.getProperties().getLongProperty(String name, long defaultValue)