跳至内容
菜单
此问题已终结
1 回复
2631 查看

Odoo 17

What I'd like to do is to set up portal users with a a Many2one field of other portal users so that when logged into the portal, they can see the Sales Order, Invoices of those other portal users.

These need to be separate portal users, and not Contacts belonging to the Portal User.

Two options are acceptable:

1) Logged in as Portal User A, user can see all Sales Orders and Invoices from themselves (Portal User A) as well as Portal User B and Portal User C.

2) Logged in as Portal User A, user can see all Sales Orders and Invoices from themselves (Portal User A), and then have a dropdown menu of other allowed users (Portal User B and Portal User C) to be able to see Sales Orders and Invoices for them.

I've tried even hacking the Query object to include additional partner_ids but it doesn't seem to work.  Too many security protections, I assume.

I tried changing the standard:

Query: 'SELECT "sale_order"."id" FROM "sale_order" WHERE
(((("sale_order"."partner_id" = %s) AND
"sale_order"."pricelist_id" IS NULL) AND
("sale_order"."website_id" = %s)) AND
("sale_order"."state" = %s)) ORDER BY
"sale_order"."write_date" DESC  LIMIT %s' with params:
[828, 1, 'draft', 1]
To this:

Query: 'SELECT "sale_order"."id" FROM "sale_order" WHERE
(((("sale_order"."partner_id" in %s) AND
"sale_order"."pricelist_id" IS NULL) AND
("sale_order"."website_id" = %s)) AND
("sale_order"."state" = %s)) ORDER BY
"sale_order"."write_date" DESC  LIMIT %s' with params:
[(828,829,830), 1, 'draft', 1]

But nothing seems to allow this.

Any suggestions?  Third party apps that do this?


形象
丢弃
最佳答案

One standard solution is available: if the end user adds the portal user as a follower, they can see the orders. 

No need any customization.

形象
丢弃
编写者

How does the portal user do that? I don't see anywhere in the portal to do that?

编写者

OH, OK. I see what you mean. It does give me a place to start!

相关帖文 回复 查看 活动
2
7月 25
1345
2
2月 24
2148
0
4月 23
1510
6
2月 23
18280
1
11月 22
4674