Failed to get information in bdm and used it in operations.

Q&A
1

Hi,

I am getting the max value of a certain column in bdm table using custom query with parameter. Then I call the query using DAO and used it in the operations once the manager have approved the task. But when i run the task it always fails. I set the petCashNo to store a new series of pet cash no. Just want to create a petcash series number

This is my custom query

SELECT MAX(p.petCashNo)
FROM PettyCashHeader p
WHERE p.branch = :branch

Return of custom query is single

This is how i call my query in operations

pettyCashHeaderDAO.findByMaxPetCashNo(branch)

The branch parameter is defined in the local variables

pettyCashRequest.getBranch()

Please help. Thanks very much

2

I think this is not supported yet.

However I do believe there is also a bug as query1 (in my case) tells me that it needs two parameters and this is wrong, there should only be one.

This looks like a bug, I would open a report here, then report the number back here and I will support you in it.

https://bonita.atlassian.net

regards
Seán

PS: I realise this may not be the answer you are looking for but it’s the best we can do for this type of error on the community forum, please mark as resolved so others don’t have to reply.