none
Project Server - Filtering projects with csom by custom field RRS feed

  • Question

  • Hello, somebody could help me with the question down?

    I'm trying to filter the PWA projects through custom fields and my query returns values but in the project server api returns the field value.


    C #

     var projetoValor = contexto.LoadQuery(contexto.Projects.Where(t => (string) t.["Custom_x005f_d062e23bf8b8e4119bcd00155dbc7202"] == "Planning Finished"));

    Api (/sites/pwa/_api/ProjectServer/Projects('47592fcc-2bae-e411-82d7-5cc9d3ffa3e6')/IncludeCustomFields)

    </d:Custom_x005f_1048aed8f0ade311a87d00155db0fd20><d:Custom_x005f_7985d87f5aade411b4b300155dbc4305 m:type="Edm.Decimal">0.000000</d:Custom_x005f_7985d87f5aade411b4b300155dbc4305><d:Custom_x005f_d062e23bf8b8e4119bcd00155dbc7202>Planning Finished</d:Custom_x005f_d062e23bf8b8e4119bcd00155dbc7202><d:Custom_x005f_7f2edcdcefade311bb7d00155db0fb1f m:type="Edm.Decimal">0.00000</d:Custom_x005f_7f2edcdcefade311bb7d00155db0fb1f><d:Custom_x005f_18d177c2f0ade31187cc00155d689b21 m:type="Edm.Decimal">0.00000</d:Custom_x005f_18d177c2f0ade31187cc00155d689b21><d:Custom_x005f_79a8d1f00e1ce4119a7200155dbc690b m:type="Edm.Decimal">120.00000</d:Custom_x005f_79a8d1f00e1ce4119a7200155dbc690b><d:Custom_x005f_dd5fd03c477be4118ee200155dc06e00 m:type="Edm.Decimal">0.00000</d:Custom_x005f_dd5fd03c477be4118ee200155dc06e00><d:Custom_x005f_7d899ebc487be411bbb700155dc07f00 m:type="Edm.Decimal">0.00000</d:Custom_x005f_7d899ebc487be411bbb700155dc07f00><d:Custom_x005f_53617ba80caee3118cef00155da0981e m:null="true" /><d:Custom_x005f_9c9916f36bb8e411ad3d00155dc03b01 m:type="Collection(Edm.String)"><d:element>Entry_965c7edf6bb8e411ad3d00155dc03b01</d:element></d:Custom_x005f_9c9916f36bb8e411ad3d00155dc03b01></m:properties></content></entry>
    Friday, February 20, 2015 2:26 PM

All replies

  • Hello, somebody could help me with the question down?

    I'm trying to filter the PWA projects through custom fields and my query returns values but in the project server api returns the field value.


    C #

     var projetoValor = contexto.LoadQuery(contexto.Projects.Where(t => (string) t.["Custom_x005f_d062e23bf8b8e4119bcd00155dbc7202"] == "Planning Finished"));

    Api (/sites/pwa/_api/ProjectServer/Projects('47592fcc-2bae-e411-82d7-5cc9d3ffa3e6')/IncludeCustomFields)

    </d:Custom_x005f_1048aed8f0ade311a87d00155db0fd20><d:Custom_x005f_7985d87f5aade411b4b300155dbc4305 m:type="Edm.Decimal">0.000000</d:Custom_x005f_7985d87f5aade411b4b300155dbc4305><d:Custom_x005f_d062e23bf8b8e4119bcd00155dbc7202>Planning Finished</d:Custom_x005f_d062e23bf8b8e4119bcd00155dbc7202><d:Custom_x005f_7f2edcdcefade311bb7d00155db0fb1f m:type="Edm.Decimal">0.00000</d:Custom_x005f_7f2edcdcefade311bb7d00155db0fb1f><d:Custom_x005f_18d177c2f0ade31187cc00155d689b21 m:type="Edm.Decimal">0.00000</d:Custom_x005f_18d177c2f0ade31187cc00155d689b21><d:Custom_x005f_79a8d1f00e1ce4119a7200155dbc690b m:type="Edm.Decimal">120.00000</d:Custom_x005f_79a8d1f00e1ce4119a7200155dbc690b><d:Custom_x005f_dd5fd03c477be4118ee200155dc06e00 m:type="Edm.Decimal">0.00000</d:Custom_x005f_dd5fd03c477be4118ee200155dc06e00><d:Custom_x005f_7d899ebc487be411bbb700155dc07f00 m:type="Edm.Decimal">0.00000</d:Custom_x005f_7d899ebc487be411bbb700155dc07f00><d:Custom_x005f_53617ba80caee3118cef00155da0981e m:null="true" /><d:Custom_x005f_9c9916f36bb8e411ad3d00155dc03b01 m:type="Collection(Edm.String)"><d:element>Entry_965c7edf6bb8e411ad3d00155dc03b01</d:element></d:Custom_x005f_9c9916f36bb8e411ad3d00155dc03b01></m:properties></content></entry>

    • Merged by Victoria Xia Monday, February 23, 2015 8:08 AM the question is about project and duplicated https://social.technet.microsoft.com/Forums/en-US/92355a3b-bdc1-49f8-b440-8f11038b2262/project-server-filtering-projects-with-csom-by-custom-field?forum=project2010custprog
    • Proposed as answer by Denis Ursulino Wednesday, April 22, 2015 7:54 PM
    • Unproposed as answer by Denis Ursulino Wednesday, April 22, 2015 7:55 PM
    • Proposed as answer by Denis Ursulino Wednesday, April 22, 2015 7:55 PM
    • Unproposed as answer by Denis Ursulino Wednesday, April 22, 2015 7:55 PM
    Friday, February 20, 2015 2:16 PM
  • OK,Not helped!

    Wednesday, April 22, 2015 7:56 PM
  • Ok, not helped!
    Wednesday, April 22, 2015 7:57 PM