Discussion
Filtering by tags in the script.google.com
Here https://dev.targetprocess.com/docs/google-apps-script at the very and of the page is provided example for filtering by date var filter = '(\'CustomFields.Next Date\' gte \'2017-01-09\') and (\'CustomFields.Next Date\' lte \'2017-01-16\')';, but I need filter by tags. Here https://dev.targetprocess.com/docs/sorting-and-filters is also present example of API for filtering by tags - /api/v1/userstories?where=(Tags contains 'abc') How I apply it for filtering by tags via google apps script?
Posted by Art 11 months ago
Update UserStory Error 500
Hi.
I'm trying to update a UserStory and I'm getting this error message:
Status code: 500
{"Status":"InternalServerError","Message":"Oops... Something's wrong.","Type":"Presentational","Details":{"Items":[{"Type":"Resolvable","Message":{"Token":"Oops... Something's wrong.","Data":{},"Value":"Oops... Something's wrong."},"Resolution":{"Type":"ContactSupport"}}]},"ErrorId":"c336ee09-7a6c-427a-a63a-96ae7de5a52c"}
This is the data I'm posting:
query: "https://csantosvp.tpondemand.com/api/v1/UserStories?access_token=****************************=&format=json"
body: {'Project':{'Id': 5548},'Effort': 22,'EffortToDo': 22,'TimeRemain': 22,'Id': 5778}
What am I doing wrong?
Posted by José Prada 12 months ago
Querying and updating Assignable substates
We are using SubEntityStates in our workflow that looks something like this (substates in brackets):
Backlog -> Ready -> Development [In Dev -> Code Review -> Dev Done] -> Testing [...] -> Done [Accepted, LIVE, ...]
I'm building internal integration that uses the targetprocess REST API v1 to (among other things) query and update entity states. I can already achieve these for the parent states, but I can't find the current substate of an Assignable in the API response and trying to update the EntityState to a substate returns with an error.
For example, I have a UserStory that shows on the web interface to be in "In Dev" state, but the EntityState returned by the API is "Development" (the parent state). When I try to update EntityState to "Code Review" this is what I get:
```
POST /Assignable/60091 {"EntityState": {"Id": 2961}}
{
"Status": "BadRequest",
"Message": "Invalid entity state 'Code Review' for UserStory.",
"Type": "Presentational",
"Details": {
"Items": [
{
"Type": "BrokenRule",
"FieldPath": {
"EntityKind": "UserStory",
"Column": "EntityState"
},
"Message": {
"Token": "Invalid entity state '{entityStateName}' for {entityKind}.",
"Data": {
"entityStateName": "Code Review",
"entityKind": "UserStory"
},
"Value": "Invalid entity state 'Code Review' for UserStory."
},
"Details": null,
"Resolution": null
}
]
},
"ErrorId": "067dd05f-9adf-42db-94e6-d999bdd90cc0"
}
```
Am I missing something or is this not supported by the current APIs?
Posted by László Bácsi about 1 year ago
Inheriting Custom Field from Project to Epic
How can we create an automated rule to pass down the value in a custom field from the project (parent) to the epic (child)?
Posted by Tarin Obbink about 1 year ago
Query for the effort assigned to an individual or role on a user story or task
I am trying to run a query that will tell me the effort for each individual assigned to a user story or task. For example, I have a user story and have assigned a developer and a qa person. I want to know the amount of effort for each. I can get the Role and the GeneralUser but I can't figure out how to get the assigned effort. I can get the total effort but that is not what I need as I need to cost based on the role or individual.
Posted by Steve Russell about 1 year ago
Creating a List and can't select some objects
Sorry, I'm new to TP and so this may be an obvious answer but here goes:
I'm creating a List for ARTs and Teams. When I go to select Users as the third tier card it isn't available to select, only a few objects are able to be picked. Am I missing a way to make Users the third tier or is there a reason it isn't selectable? Thank you in advance.
Posted by Tad Beaty about 1 year ago
Setting the value of a custom field
I am trying to update a custom field. I can successfully do it on a request with the following call:
https://kofile.tpondemand.com/api/v1/Requests/" + TPid + token, options) where the TPid is the id, and the options is as follows:
var payload = {
"CustomFields" : [{'Name': "Notes",
'Value': Note}]
};
var options = {
'method': 'POST',
'payload': JSON.stringify(payload),
'contentType' : 'application/json',
};
Notes is the custom field.
I want to be able to make the same update to bugs and userstories. I tried Assignables and UserStories in place of requests and neither will work. I was hoping that Assignables would work for requests, bugs and user stories.
Thanks
Posted by Steve Russell about 1 year ago
Customize Entity detailed view -- desired process not selectable
I would like to modify my company's Scrum process for my team and am looking at the instructions to modify the Customize Entity Detailed View. I've created a process for my team, but do not see it in the process dropdown; there are only 4 processes listed there although I see 14 distinct processes in the Settings. I've been switching back and forth between my process and one of the non-default processes that is shown in the dropdown to see if I can identify a setting that would make my process show up in that dropdown, but don't see anything that might do it.
Have I overlooked something? What do I need to set to get the process that I want to modify visible in the process dropdown so that I change the view for my team and not the entire company?
Thanks for your help!
Posted by Peter Degen-Portnoy over 1 year ago
Filter by owners based on team?
I am creating a view where I can see what my team is creating. Specifically I am looking for items that aren't assigned to a team, as those tend to get overlooked, so I want my team to easily see when they have missed this step. I've created a list with Owner as my first hierarchy, and team as my second level. For Team, the filter was easy "it is none" but for owner, I don't know how to filter for owners who are members of a team. Is this possible? I currently have it filtered by id, but I really don't want to have to update this view anytime anyone leave or joins my team.
Posted by Jennifer Dieckman over 1 year ago
Is it possible to export data directly into xlsx format - instead of a csv?
Posted by Saikiran Panuganti over 1 year ago