Lobby counter configuration on the 'Element Designer'

Hey @Pedro_Duarte 

Configure your navigation according to the logic you wish to have by adding the search criteria.

Example

Cheers!

Hey @Pedro_Duarte 

I suggest that you would create a custom view for that purpose.

For exampl:

CREATE VIEW C_MY_VIEW AS
SELECT COLUMN1, COLUMN2, COLUMNn....
FROM TASK T JOIN PERSON P ON T.TEAM_ID = P.TEAM_ID

Then in view, instead of task populate the view name.

In conditions do nothing, or just add the person_id condition (depends how you build the custom view).

In the navigation fields just add the person_id condition (depends how you build the custom view).

Cheers!

Hello,
There is a straightforward solution to this but I cannot remember that at the moment. However I can suggest the following workaround to this. 

Here are the steps

1. Return required columns from the data source as shown below. You can change accordingly. Change into your query and columns accordingly.

   

    

2. You need a specific field in the advance search in the task screen apart from the team id field for this to work. It can be invisible and virtual. Lets assume you have a column called “crew_size”.
   Then you setup your counter element to set a value to that column - crew_size.

   

   This will set a parameter value into the URL when opening the task screen via counter element. This is a trigger point for the next step

3. Create a Client Script as shown below.

   var check = getControlValue('task','crew_size');
   var personId = getUserInfo('personId');
   if(check == 'ss')
   {
   	var teamList = getDBValues('TEST_PIUMAL',personId);
   
   	//format a string to have all the team_ids separated by a | 
   	//	eg: TEAM_X|TEAM_Z|TEAM_Q
   	var stringTeamList = 'XXXXXX'; //assuming this is the correct string with all teams
   	setRowControlValue('task', 'team_id', stringTeamList);
   
   }

   You may have to loop through a list of teams returned for the particular user and generate a single string with pipe as a delimiter and then set that string to task.team_id as shown in the client script. 
   Client Script SQL:

   select team_id from team_member where person_id = '{0}'

    

4. Add the created client script as AfterScreenLoad event in the Task screen in UI Designer.

Remember you have to have team_id and one extra column in the advance search area on task screen for this to work.

PS: You need to keep an eye on the performance levels

Would you mind set my answer as the solution, so it might help others to grab quickly

Thanks in advance.

Regards,

Piumal