You can use 'Datalist Inbox' in userview and map that to the required activity. If you do that, you don't need a hyperlink to pass information to that activity. Datalist Inbox will list down the records using Datalist created and have a link to the activity/form related to it. 

Is this something that you are looking for?

But sorry,I use the community version not the enterprise, So the userview doesn't have the Datalist element. Do you have any other solutions? Thank you in advance!

Hi there, we developed more or less the same, we could do that with the following:

In Hyperlink section (check yours):  http://XXX.XXX.XX.XXX:8080/jw/web/userview/APP_1/view2/_/9D9DBC96AB99401AA8A27ADD7DCA763C?_mode=assignment

Parameter and column name:  activityId (and this data come from a valid source with a query, related to table SHKAssignmentsTable, like in the example in: List Pending Activity and Assignees)

Camilo A. García, Thanks for your answer. Could you kindly elaborate on how you exactly implemented the query? What tool did you use?

Hello, as I mentioned before, the first was to make a list, with a source of data using "JDBC Datalist Binder" or related to a form whose origin of data is a DB view (works in postgresQL, I imagine that in mysql there must be an equivalent mechanism ) to link a complex query if the origin is not available through JDBC.

As I said then what you have to achieve is that in that source of data the necessary information is available to retrieve the parameter with the activityId. In my case, the query is more or less of the following structure:

SELECT distinct
  shkassignmentstable.activityId,
  shkactivities.name,
  CONCAT_WS( '', dir_user1.lastname, ', ', dir_user1.firstname) as Active_User,
  CONCAT_WS( '', dir_user2.lastname, ', ', dir_user2.firstname) as Requester,
FROM 
  public.shkassignmentstable,
  public.shkactivities, 
  public.app_fd_XXX,  
  public.dir_user dir_user1, 
  public.dir_user dir_user2,
  
WHERE 
shkassignmentstable.activityid=shkactivities.id and
  shkassignmentstable.resourceid = dir_user1.username AND
  app_fd_XXX.c_requester = dir_user2.username AND
  app_fd_XXX.id = shkassignmentstable.activityprocessid 

Where, as you can see, in shkassignmentstable.resourceid you can find the user assigned to the task, and the table app_fd_XXX is the one linked to your app forms specifically.

Camilo A. García
I get you. Unfortunately, these won't work on community edition as JDBC Datalist Binder isn't available. I had gotten an impression you were talking of an alternative way to achieve this in the community edition.

The trick of relating a form to a view works in the community version. Create a form with the fields that are needed in a similar way to the query I mentioned above. Then, create a view in the BD that returns the information in the same fields with the same title and test it. Once that is done, change the related table of the form for the view.

Then, make the list in joget, related to the form that you just modified. This should work since this form will be used only as a source of data and not to insert new records. For this task, a view and a table serve the same purpose.

Camilo A. García, Thank you very much! Worked like a charm and you probably saved me a ton of cash

That's what the community is for! We are interested in the proper use of the tool and be able to move forward. Regards!

Hi, i am currently facing the same problem as u. would u mind sharing your method on solving the problem? thanks a lot