Skip to Content
This question has been flagged
crmdomainv7
5 Replies
12756 Rodiniai
Portretas
SANTIAGO SAN MARTIN

In V6 you can set the permissions in crm.lead using this domain:

[('section_id','=',user.context_section_id.id)]

But in V7 context_section_id doesn't exist, so how can I filter this same domain in V7?

I'd tried this:

[('section_id.user_ids','in',[uid])]

and it gives me this error: 

NameError: name 'uid' is not defined.

Also, trying this:

[('section_id','=',section_id.user_id)]

Gives:

NameError: name 'section_id' is not defined

So, it seems like there is no section_id for user_id

Maybe something like this would work:

'section_id','=',  'section_id' for 'member_id' of 'user_id' from 'sale_member_rel' table

But I don't know how to write this code...

Portretas
Atmesti
Fabrice Henrion (fhe)

Your question title is not clear. Please edit it. Also, make sure to escape your underscores to display them instead of writing in italic.

Ong Li Wee

in early versions of v7, i used "user.section_id.id" but I had to add "default_" for the later versions of v7

Portretas
Ong Li Wee
Best Answer

this worked for me ('section_id','=',user.default_section_id.id)

Portretas
Atmesti
Miguel Fernández

Hi. I'm Santiago's partner. With ('section_id','=',user.default_section_id.id) we can see another error: AttributeError: "Field 'default_section_id' does not exist in object 'browse_record(res.users, 27)'" We only use CRM module, not Sales module. Maybe that's why?

Ong Li Wee

Hi, do u have a test server? Try installing the following modules (CRM, Sales Management, Warehouse Management, Claim Management, LDAP, Document Management System). And you must set the default sales team under settings -> users -> preferences.

SANTIAGO SAN MARTIN
Autorius

Thank you On Li Wee! We do have a test server and I'm almost sure that if we install SALES module, your code will work! But we want to keep a clean install with only the CRM that we are using now...

Oliver Yuan

this one works for me. FYI

Portretas
Oliver Yuan
Best Answer

['|',('section_id.member_ids','in',[user.id]),('section_id','=',False)]

Portretas
Atmesti
jeffery

this can work, but cause can not read on res.partner select partner when create SO

Portretas
Fabien Pinckaers (fp)
Best Answer

Try something like:

[('section_id.user_ids','in',[uid])]

Portretas
Atmesti
Portretas
jeffery
Best Answer

both ['|',('section_id.member_ids','in',[user.id]),('section_id','=',False)] and ['|', ('section_id','=',user.default_section_id.id), ,('section_id','=',False)] is worked to filter customer via sales teams.

and ['|',('section_id.member_ids','in',[user.id]),('section_id','=',False)] is the best filter.

but there have one issue.

when select partner in create SO, it raise error.

Access Denied

The requested operation cannot be completed due to security restrictions. Please contact your system administrator.

(Document type: Partner, Operation: read)

there may be have security conflict in those rules.

Portretas
Atmesti
Portretas
SANTIAGO SAN MARTIN
Autorius Best Answer

I'd tried this:

[('section_id.user_ids','in',[uid])]

and it gives me this error: 

NameError: name 'uid' is not defined.

Also, trying this:

[('section_id','=',section_id.user_id)]

Gives:

NameError: name 'section_id' is not defined

So, it seems like there is no section_id for user_id

Maybe something like this would work:

'section_id','=',  'section_id' for 'member_id' of 'user_id' from 'sale_member_rel' table

but I don't know how to write this code...

Portretas
Atmesti
Yug Faa

Try to use user.id in place of uid, i hope that it will works

SANTIAGO SAN MARTIN
Autorius

Another error: ValueError: Invalid field 'user_ids' in leaf "<osv.ExtendedLeaf: ('user_ids', 'in', [27]) on crm_case_section (ctx: )>

Related Posts Replies Rodiniai Veikla
How do I import my contacts in OpenERP? Solved
crm v7
Portretas
Portretas
Portretas
3
vas. 25
27164
How to Set Fixed Filter for a User / User group ?
domain v7
Portretas
Portretas
1
rugp. 15
6675
problem in installing crm_claim_ext
crm v7
Portretas
0
geg. 15
4490
how to force user to fill fields on every stage of opportunity in openerp 7.0
crm v7
Portretas
Portretas
1
kov. 15
5577
How domain defined for a field in header tag
crm domain
Portretas
0
kov. 15
5296