Discussion

Ask a Question
ANSWERED

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?
ANSWERED

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?
ANSWERED

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?
ANSWERED

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)?
ANSWERED

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.
ANSWERED

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.
ANSWERED

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
ANSWERED

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!
ANSWERED

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.
ANSWERED

Is it possible to export data directly into xlsx format - instead of a csv?