I'm trying to do a field comparison in the API. I get a SQL error when I do. https://company.my.workfront.com/attask/api/v9.0/EXPNS/search?apiKey=apikey&plannedDate=FIELD:datePaid&plannedDate_Mod=gte This syntax is supposed to work in Reports but I can't seem to get it to work in the API. Also, through the API, I would like to find all projects where Project percentComplete > (Project Actual Hours/Project Planned Hours) Essentially I'd like to do a calculation comparison based on project fields. Is this even possible and how would I go about doing it? Eric Decker
