How to create a custom case overview

Q&A
1

Hi,

I want to create a custom case overview showing different fields. First is the gatePassNo from a new bdm table then the taskname where the task is and then date created from the table where the gatePassNo is also found. But dont know how to create this following. I put all this field in a default table in UI Designer but the following fields came from different bdm table. Please help to create this.

Thanks

2

Hi
The Best way to Pull data from BDM table is to use Rest API as provided by BonitaSoft.
Each table will have a unique query. Hence for 2 different tables , you will need 2 separate API queries to fetch data.

Here is an Example of a customQuery that I use
/bonita/API/bdm/businessData/com.myData.model.DemandProcessMasterData?q=find&p=0&c=10000
here DemandProcessMasterData is my table name .

You could find other API that are provided by Default in your BDM.
Open the Bonita Studio, go to Development, Business Data Model, Select the table you want, go to Queries.
There will be a list of available queries for you to use.
You can create custom queries as well.

To show the results together, you might need to write some javascript code to sort through the data and return only the value you are looking for.
Finally append the data to your datatable.

If you are looking for task details, it might be more tricky.
Usually I create a field inside my BDM titled as Current actor and i usually store the Name of the Person inside my BDM. Its easier to fetch that.
I did a special Page for Tasks. Here I searched using CASE id. There was a field returned as assigned_id.
I used that to retrieve the name of the person based on assigned id.

Ok, Here is the way to fetch tasks.
use the API …/API/bpm/humanTask?c=1000&p=0&f=processId={{processid}}&o=state%3dready
The returned data will contain case id’s and assigned id .
I had created a fragment to take assigned id as input and return name of the person as Output.

Regards

3

Hi,

How about the task done and when it is executed? How can I retrieve it? Can you create an example and include it in the previous .bos file youll give to me.

Thanks

4

Unfortunately , I discovered that in the community Edition , I am not able to execute certain queries.
i am getting unauthorized error message.It works fine in Subscription edition.
Hence I am not able to work on that.
I will try once more now.
Else I could make a document with Steps and screenshots for you.
Follow that and see if it Works for you.

5

Hi roy,

Ok sure you have been a great help.

Thanks

6

Here is the Page.
https://drive.google.com/open?id=0B-MHHSlP6-kMNkU2Q1QzeC1Uam8

After downloading , Open the Portal first and then Preview the page.
Select the Group as HR and select walter bates.
See if its Populating members based on groups.
if no, then Let me know .

7

Hi Roy,

How to upload this?

8

You could First Open the BPM Portal, Then Open the UI designer. Click on Import. Select the file.
Now Click on Preview Button on the Top of the Page.

Let me if that Works. ( An API is needed to Pull Data from the Portal into the Page.)
Incase the Names are not populating , I will share the API as Well.

9

Hi Roy,

Import Error
Invalid page .json json file structure

Thanks

10

Oh , it seems Subscription and community Editions are not compatible with Each other.
I will try to Create the same page in Community edition and upload.

Hope it will work for you.