Skip to Content
This question has been flagged
crmdomainv7
5 Replies
12741 Zobrazenia
Avatar
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...

Avatar
Zrušiť
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

Avatar
Ong Li Wee
Best Answer

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

Avatar
Zrušiť
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
Autor

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

Avatar
Oliver Yuan
Best Answer

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

Avatar
Zrušiť
jeffery

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

Avatar
Fabien Pinckaers (fp)
Best Answer

Try something like:

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

Avatar
Zrušiť
Avatar
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.

Avatar
Zrušiť
Avatar
SANTIAGO SAN MARTIN
Autor 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...

Avatar
Zrušiť
Yug Faa

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

SANTIAGO SAN MARTIN
Autor

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

Related Posts Replies Zobrazenia Aktivita
How do I import my contacts in OpenERP? Solved
crm v7
Avatar
Avatar
Avatar
3
feb 25
27154
How to Set Fixed Filter for a User / User group ?
domain v7
Avatar
Avatar
1
aug 15
6669
problem in installing crm_claim_ext
crm v7
Avatar
0
máj 15
4484
how to force user to fill fields on every stage of opportunity in openerp 7.0
crm v7
Avatar
Avatar
1
mar 15
5560
How domain defined for a field in header tag
crm domain
Avatar
0
mar 15
5291