LiquidPlanner Classic Forum

Ask a Question
ANSWERED
ANSWERED

finding work worked on or completed in a time period

*Posted on behalf of Ricardo Signes. Original posting date 2017-10-13.* There are a few queries I'm looking to do through the API, but I don't think I can. The most important is: I'd like to find all the work a user marked done in a time window. This is problematic in a few ways. First, I can search for tasks where date_done is in a given range, but this is about task completion, and I am more interested in assignment completion. I don't think I have an efficient way, at all, to find all the work where a person has marked their assignment done in a time window. Next, I accept that I can only look for whole task closure, but then I want to look for assignment closure dates. Those aren't provided in the API. Assignments have done_on but not date_done. This means my approximation of "tasks a given person marked done in time window is "tasks marked done in a time window where a given person was ever assigned work on it." That's not a great approximation. (I see now that I am largely repeating myself form https://developer.liquidplanner.com/discuss/5d83aee6d952190015da3282 but I think I have more detail here, so I won't go delete this all.) The other query I'd like to get is "tasks on which a user logged time in a given time window." I realize I can get this through the timesheet API, but it means dealing with two different response formats, so having a direct query for this in the tree would be useful. Here's what I'm up to: I want to get a concise description of the ways in which our plans do not survive contact with the enemy. At the beginning of an iteration (sprint), I take a snapshot of all scheduled work. At the end, I produce a report, per-member, of how reality at the end of the iteration compares to the plan. This shows all the scheduled work, along with the amount of time logged, whether it has been completed (distinguishing between assignment or task completion), or repackaged. My next goal is to show all the work that *was not planned* but which was completed or worked on during the iteration. I can use the timesheet API to get tasks that got worked logged, but I think I'm mostly out of luck for tasks that were created and marked closed with no logged time. (This shouldn't happen, but does.)
ANSWERED
ANSWERED
ANSWERED

upcoming tasks for multiple members

*Posted on behalf of Ricardo Signes. Original posting date 2017-07-11.* I want to track how much work is in various states. Namely, per member: * how many tasks in the inbox with no estimate * how many tasks in the inbox with an estimate * how many tasks in the "urgent" package The "urgent" package is near the top of tree, so I know that if I start from "the top" I'll get to the end of urgent pretty quickly. So, the simplest thing, which I already use when individuals ask for this data, is to get upcoming_tasks with a high-enough limit that I'm sure to get all their tasks. This is no good, though, when I want to get a report across all members. It's far too slow. There are 27 members, and each one takes several seconds. It takes me two minutes to run the program. The upcoming_tasks endpoint seems only to work for one member at a time (which seems fine), and I've been trying to get the same data another way. I'm getting ```/tasks?filter[]=done is false&limit=500``` and then pulling the data out of that. I'm not entirely confident in this. Once I'm limiting, I want to know that I've got the data sorted usefully. I'm not sorting, here, because my only remotely plausible order is "earliest_start," but inbox tasks have no start date. I can't tell whether the natural ordering is sufficient: will it list items in their display order? The program, written this way, takes about 15 seconds. Ideally, I would be able to write a query that said: /tasks, (contained in INBOX or contained in Urgent) AND is_done is false AND (member_id in LIST-OF-IDS)
ANSWERED

Appear as a "Bot" user when making changes via the API

*Posted on behalf of Robert. Original posting date 2017-06-25.* We've an app taking actions in our LP workspace, but the avatar / user info in the logs and history is indistinguishable from the human user it's authorised as. Is it possible to make it obvious that those changes were made by a bot, without creating (and paying for) a whole new user?
ANSWERED

Task Name via API

*Posted on behalf of Lee Raybone. Original posting date 2017-06-06.* Is it possible to get the Task Name via the API based on the TaskID? Regards,
ANSWERED
ANSWERED
ANSWERED

No visibility despite being owner of the project

*Posted on behalf of Josu Basurko Mendez. Original posting date 2017-05-22.* Hello, I have successfully created a project structure with subfolders and tasks through the API. I have also assigned the project, subfolders and tasks to a different user and everything seems fine until I realized that the this user is not able to see it in the web application. This seems to be an access level problem. I use an API token from the workspace owner to create everything and the future owner is a member with "restricted" access level. As far as I know "restricted" access level means that you can see everything you have been assigned on, which seems to be the case but it is not working. The only workaround I have found is entering the webapp with the workspace owner account and grant permissions on that project to the user. After that everything seems to work. However it doesn`t sound like a long term solution for me. Is there something wrong with my approach? Can I grant permissions to a user on a package/folder so everything under that package/folder is visible to some users? Thank you in advanced for your time and attention. Josu