I'm working with SharePoint and ProjectServer 2007 via PSI with Python.
I can't find any documentation on how Filter Class (Microsoft.Office.Project.Server.Library) objects work internally to emulate its behaviour in Python.
Any ideas?
I'm working with SharePoint and ProjectServer 2007 via PSI with Python.
I can't find any documentation on how Filter Class (Microsoft.Office.Project.Server.Library) objects work internally to emulate its behaviour in Python.
Any ideas?
Copyright © 2021 Jogjafile Inc.
Take a look at Colby Africa's blog post. Also, msdn docs are here.
Edit
The generated filter is just XML. Here is a filter that returns the data from the "LookupTables" table (list of all the lookup tables):
Here is another example of the filters required for getting all the data for one table...
Step 1: Get the row for the LookupTable (general table info)
Step 2: Get all the data from the LookupTableStructures table (hierarchy info)
Step 3: Get all of the values in this lookup table
It requires three separate filters to get all this data because it is split across three separate tables. In C#, I am calling the
ReadLookupTablesMultiLang
function with each of these filters and then merging the returned datatables.