Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Is it possible to use build in function in Active Objects?

I'm developing plugin for Jira Server.
I need to run the simple query

"select ENTITY_ID, (START_TIME > 0) as STARTED from MyEntity order by STARTED". 

Is it possible to do it with atlassian active objects?

public interface MyEntity extends Entity {

String getEntityId();
void setEntityId(String entityId);

long getStartTime();
void setStartTime(long startTime);


2 answers

I fixed the issue by myself. May be the solution would be helpful for somebody else.

I implemented own Query which removes "(START_TIME > 0) as STARTED" from canonical fields. It resolves the issue.


class MyQuery extends Query {

private static final long serialVersionUID = 1231231231231231231L;

public MyQuery(QueryType type, String fields) {
super(type, fields);

public String[] getCanonicalFields(EntityInfo<?, ?> entityInfo) {
String[] res = super.getCanonicalFields(entityInfo);
List<String> collect =
.filter(field -> !field.contains(">")) // this removes "(START_TIME > 0) as STARTED
return collect.toArray(new String[]{});

Hi @Irina S , yes it is possible. Active Objects uses to prepare the query which can be used to search the data you need:

@Martin Bayer _MoroSystems_ s_r_o__  - unfortunately it doesn't work.


Column STARTED doesn't exists in the db table.
'STARTED' is an alias. "(START_TIME > 0) as STARTED".
I need to order by the alias.

So the code silently returns nothing.

class MyEntityDao {
List<MyEntity> getItems() {
<MyEntity> entities = new ArrayList<>();
try {
Query query ="select ENTITY_ID, (START_TIME > 0) as STARTED")
.order("STARTED DESC")
.limit(5);, query, entities::add);
} catch (Exception ignored) {

return entities;


public class MyEntityDaoTest {

public void someTest() {
// add several items to the dao.
List<MyEntity> res = dao.getItems();
assertEquals(3, res); //falls because res is empty. It doesn't fell if query ="select ENTITY_ID") above;


It doesn't fell if query ="select ENTITY_ID") above.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events