'JBPM Business central - Data set not working with aggregate function

I have an issue with the Data set - Execution server. I am using PostgreSQL as DB. I want to calculate the difference between the two dates column for my report. The query I have used in DB is:

Query 1:

SELECT end_date as end,
               start_date as start,
               processid as pidd,
              AGE(end_date, start_date) as duration
  from processinstancelog

Query 2:

select end_date,start_date,processid, end_date - start_date as
duration from processinstancelog

Both queries reflecting the correct expected result in Postgres DB. But when I am using the same queries in the Data set>Execution server it's not showing the "duration" column.

Question

Can anyone please advise what is issue why the data set is not showing the duration column?

Many Thanks

postgresqljbpm


Solution 1:[1]

Answer, I deleted the old setup and installed the new setup for JBPM and data set start appearing

Solution 2:[2]

Both queries reflecting the correct expected result in Postgres DB. But when I am using the same queries in the Data set>Execution server it's not showing the "duration" column.

How do you use in the query in the execution server? Are you implementing advance query functionality? If yes can you please share the exact steps you are following and your advance query definition to review.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Akzy
Solution 2 Akzy

Related Questions