Can We Use lastUpdateDate at Project, User, Issue, and Task Level to Filter Records? - Help with Query Error | Community
Skip to main content
U
UjjwalKu
March 12, 2025
Solved

Can We Use lastUpdateDate at Project, User, Issue, and Task Level to Filter Records? - Help with Query Error

  • March 12, 2025
  • 2 replies
  • 567 views

Hello Workfront Community,

I am currently working with the Workfront API and trying to filter records using the lastUpdateDate parameter. However, I am encountering an error when attempting to query for records using this field.

I am trying to use the following query to fetch project-level records based on the lastUpdateDate field:
https://yourdomain.my.workfront.com/attask/api/v19.0/proj/search?fields=*&lastUpdateDate=2023-05-24T23:46:03Z
Invalid Parameter: lastUpdateDate value "2023-05-24T23:46:03Z"

My question is:

  1. Can we use lastUpdateDate to filter records at the Project, User, Issue, and Task levels?
  2. If yes, could you please help me understand how to properly format the lastUpdateDate parameter for filtering records at these levels?
  3. Is there any specific syntax or rules I need to follow for the lastUpdateDate field across different entity types (e.g., project, task, user, issue)?

Any assistance or examples would be greatly appreciated. Looking forward to your guidance!

Thanks!
Ujjwal Kumar




This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Rafal_Bainie
You date format is too short: 
2023-05-24T23:46:03Z
 
if you are pasting it as text, it should include milliseconds I think, e.g.
2025-02-28T21:30:00.000Z
 
and I second the comment about modifiers. Your current expression is targeting specific moment in time, you will want to do "last update date" + e.g. _Mod greater/smaller than
 
full example:
https://yourdomain.my.workfront.com/attask/api/v19.0/proj/search?lastUpdateDate=2025-02-28T21:30:00.000Z&lastUpdateDate_Mod=gt​

2 replies

D
D____D
Level 4
March 12, 2025

Doen't the search function use modifiers like - "eq, ne ... " and others? See details here - https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-general-information/api-basics

Make sure you scroll down to the "Using Search Modifiers" section to check.

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity AdvisorAccepted solution
Community Advisor
March 12, 2025
You date format is too short: 
2023-05-24T23:46:03Z
 
if you are pasting it as text, it should include milliseconds I think, e.g.
2025-02-28T21:30:00.000Z
 
and I second the comment about modifiers. Your current expression is targeting specific moment in time, you will want to do "last update date" + e.g. _Mod greater/smaller than
 
full example:
https://yourdomain.my.workfront.com/attask/api/v19.0/proj/search?lastUpdateDate=2025-02-28T21:30:00.000Z&lastUpdateDate_Mod=gt​
    D
    D____D
    Level 4
    March 12, 2025

    Great point on the date time value! 

    Terms & ConditionsAccessibility statement

    Loading footer...