ProjectWise most efficient approach for Project \ Document \Attributes cache /aaApi_SelectLinkDataByWhere

What is the most efficient approach to Cache a Project, the Documents contained, and the document attributes,
After looking at this more, these function seems to be the best approach for narrowing the Project \ documents needed for my use case. aaApi_SelectLinkDataByWhere
Are there any examples with this function available?
Thanks
Craig
Parents
  • in the samples directory there are examples of aaApi_SelectLinkDataByObject which would fill the same table and have the same "Get" functions.

    If you use the folder tree structure to identify your projects you could use use aaApi_SelectProjectsFromBranch to get the list of folders in the project, then for each folder use aaApi_SelectDocumentsByProjectId  to get the list of documents, then for each document you can run the link data set of things to get the attributes.

    Or you could use the Export/Import feature to export a spreadsheet of all the document attributes if that is your sole end goal, then you could use Export/Import to load it back in later if needed.

Reply
  • in the samples directory there are examples of aaApi_SelectLinkDataByObject which would fill the same table and have the same "Get" functions.

    If you use the folder tree structure to identify your projects you could use use aaApi_SelectProjectsFromBranch to get the list of folders in the project, then for each folder use aaApi_SelectDocumentsByProjectId  to get the list of documents, then for each document you can run the link data set of things to get the attributes.

    Or you could use the Export/Import feature to export a spreadsheet of all the document attributes if that is your sole end goal, then you could use Export/Import to load it back in later if needed.

Children
No Data