switched over portfolios view to use sql view, api portfolios list as well