Page Comparison

...

Include Page

	Tempo for Data Center
	Tempo for Data Center

Page Properties

Question	How do I create a dynamic work attribute in Tempo Timesheets for

Server

Data Center

Answer

Work attributes can be added as additional fields to the worklog dialog screen within Tempo Timesheets (required permission: Tempo Administrator). Work attributes can be added within the Tempo report engine and are included in the Excel output reports as well.
Dynamic work attributes are special in that you define the list items in an external service that connects to Tempo Timesheets. Additionally Tempo can pass several parameters from the worklog dialog screen (Jira issue key, the user key and the Tempo account key) to the script in order to make the available work attributes dependent on the selected value within the worklog dialog screen. In the example below, we show you how you can create a dynamic work attribute that will pull all Tempo Teams the user (who logs the time) is a member of as possible options to select. Follow the steps below to set up a dynamic work attribute.

First, create the worklog attribute field from the Tempo Administration section. Select the type "Dynamic Dropdown":

Image Removed

Image Added

Click the "Configure API URL (for dropdown values)" and enter the path to your script. Add the user parameter ("/{author}") to the script url to pass the user key to it.

Image Removed

Image Added

Code Block

language	php

$callback= $_GET['callback'];


echo $callback;


$url = $_SERVER['PHP_SELF'];


$path = parse_url($url, PHP_URL_PATH);


$pos = strpos ( $path , '/' ,1 );


$len = strlen ( $path );


$parameter = substr ( $path , $pos+1, $len-$pos);



$datetoday = date('Y-m-d', time());


$url = "http://localhost:8080/rest/tempo-teams/2/teammember/".$parameter."/memberships?from=".$datetoday."&to=".$datetoday;


$username = 'username';

$password = 'password';


$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, $url);


curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);


curl_setopt($ch, CURLOPT_USERPWD, $username.":".$password);


curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);


$output = curl_exec($ch);


$jsonData = (json_decode($output, true));


$teams = count($jsonData);

Finally the script needs to parse the data in JSON to be readable by the Tempo interpreter. The format need to be similar to the following:

Code Block

language	json


  {"values":

"key":"0100",

"value":"This is option ONE"

},

"key":"0200",

"value":"And here is option TWO"

]
}


    ]
  }
)

^We

^use

^our

^script

^to

^create

^the

^JSON

^data

^by

^looping

^through

^the

^returned

^values

^from

^the

^API

^call.

(

Code Block

language	json

(
  {"values":

<?

php
$i

php$i = 1;

 foreach ($jsonData as $team) { ?>

"key":"<?php echo $team['team']['id'];?>",


    "value":"<?php echo $team['team']['name'];?> "

<?

php
if

phpif ($teams === $i) {

?>

<?php

 
      else {

?>

},


      <?php

$i++;

?>

]
}

   ]
  }
)

^That's

^it!

^When

^we

^look

^into

^our

^worklog

^dialog

^screen

^we

^should

^see

^the

^work

^attribute

^be

^populated

^by

^all

^team

^members

^the

^user

^is

^member

^of:

Image Removed

Image Added

As a side note: the value will be preselected when there is only one option available AND the work attribute has been made required.

Versions Compared

Old Version 9

New Version 10

Key