Forum Discussion

waltercastillo's avatar
waltercastillo
New Member
7 years ago

Project Online ODATA Filter data from ResourceTimephasedDataSet

I have a Project Online implementation, around 3000 resources, but not all have assignments, the ResourceTimephaseDataSet table is very big, because it create rows for all 3000 resources, then load t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi waltercastillo ,

You can consider add conditions to url string based on URL Conventions, it should filter records before loading data to query table: URL Conventions (OData Version 3.0)

Regards,
Xiaoxin Sheng

  • waltercastillo's avatar
    waltercastillo
    New Member
    7 years ago

    Thanks a lot Xiaoxin

    I'm trying with Expand, but I don't find several samples with it.

    I need more examples to understand how can I take this done.

     

    WCC

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI waltercastillo ,

      Please refer to below odata basic filter tutorial from odata site:
      Odata Basic Tutorial

      Regards,

      Xiaoxin Sheng