3

I've been trying to filter the Task collection using custom field called "TaskType" (I've created this one). This custom field has an associated lookup table. So if i query the OData :

https://myserver/PWA/_api/ProjectServer/Projects('0647003e-dce3-e211-9477-080027efb62d')/IncludeCustomFields/Tasks

I get the following custom field data:

 "Custom_x005f_fe7ff100cee3e2119477080027efb62d":{
   "results":[
     "Entry_960a8ffef3334cc2bfee14a27cf95dbb"
   ]
}

since this is an array I can't filter using this field. I can extract names of the assigned custom fields, but not the value. so the following query

https://PWA/_api/ProjectServer/Projects('0647003e-dce3-e211-9477-080027efb62d')/IncludeCustomFields/Tasks?$select=CustomFields/Name,CustomFields/LookupEntries/Value&$expand=CustomFields,CustomFields/LookupEntries

would return something like this

{
   "CustomFields":{
      "results":[
         {
            "LookupEntries":{
               "results":[
                  {
                     "Value":"Normal"
                  },
                  {
                     "Value":"Auto"
                  },
                  {
                     "Value":"Manual"
                  }
               ]
            },
            "Name":"Task Type"
         }
      ]
   }
}

Is there any association between Task and its Custom Field Value so that could be used to filter the results?

Using the ProjectData API is not something I want to go into.

nizzik
  • 826
  • 5
  • 18

0 Answers0