ODBC guide

List portfolios by owner and workspace


Returns portfolios for a specified owner and workspace. Supply both the owner's user ID and the workspace ID. Use this when you have multiple workspaces and need portfolios scoped to a single workspace.

SELECT * FROM Portfolios WITH(OwnerId='1200442904128317', WorkspaceId='1200442900140748')