Error in Custom Query
Hi everyone, i am trying to create custom update bdm query. But suddenly when i started the process the error message like this "The business data 'requestCA' with the class name 'com.company.model.RequestCA', is not managed by the current version of the BDM" displayed right after i pressed the run button. I changed the query many times but the message keep appearing. These are queries that i have tried before:
- UPDATE Budget SET b.costCode = :costCode AND b.budgetTotal = :budgetTotal AND b.sisa = :sisa AND b.tanggalBudget = :tanggalBudget WHERE b.persistenceId
- UPDATE Budget SET b.costCode = :costCode, b.budgetTotal = :budgetTotal, b.sisa = :sisa, b.tanggalBudget = :tanggalBudget WHERE b.persistenceId
All queries that i have tried above, gave me same error message. I want to know what is went wrong. Is it the query or the the BDM version doesn't support custom query.
If you don't know how to, I suggest you to folow the tutorial: https://documentation.bonitasoft.com/bonita/7.9/_getting-started-tutorial
To edit your datas, if you modify them by a form, you need to map the input with your business data object in the 'Operation' section of your task.
If you just want to edit without form, just set your business object with your values.
I think the link that you have shared is too basic, i have followed every step in the link since the first time i learned bonita. None in the link above mentioned editing data in the bdm. In my case i want to do a basic editing data in my project. i want to edit data by selecting a row in a table in the form -> once row selected the field in a row displayed in the text field -> and then in the text field we can edit through the text field and then press submit to send edited data to the bdm.
thanks for reply, what you have instructed is similar to what i have done in my project. however, when i checked in the H2 the data won't updated. Here is my .bos file https://www.dropbox.com/s/mayojowlsdkx728/Update.bos?dl=0 i hope you can check out the project and see what i have done. Make sure you run TEST Update-1.0.proc diagram and see what went wrong there. I'm looking forward for your answer.
mine is version 7.9.
I think, the bdm queries is used only for 'SELECT' clause, i don't think that you can usse it for other clause like UPDATE.
To update a businessObject, you need to pass througt an 'Operation' in your process.
myBusnessObject 'useJaveMethod' -> setMyAttribute() -> myInput.myAttribute.
thanks for replying, if it's only for "SELECT" clause then how we can edit or update the data? In this case i want to update the data that i have been previously selected from table row. Do you know how to implement updating data in the bdm?