Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
crmdomainv7
5 Antwoorden
14160 Weergaven
Avatar
FASTER EMPLEO ETT SA, 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
Annuleer
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
Beste antwoord

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

Avatar
Annuleer
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.

FASTER EMPLEO ETT SA, SANTIAGO SAN MARTIN
Auteur

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
Beste antwoord

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

Avatar
Annuleer
jeffery

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

Avatar
Fabien Pinckaers (fp)
Beste antwoord

Try something like:

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

Avatar
Annuleer
Avatar
jeffery
Beste antwoord

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
Annuleer
Avatar
FASTER EMPLEO ETT SA, SANTIAGO SAN MARTIN
Auteur Beste antwoord

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
Annuleer
Yug Faa

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

FASTER EMPLEO ETT SA, SANTIAGO SAN MARTIN
Auteur

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

Gerelateerde posts Antwoorden Weergaven Activiteit
How do I import my contacts in OpenERP? Opgelost
crm v7
Avatar
Avatar
Avatar
3
feb. 25
28830
How to Set Fixed Filter for a User / User group ?
domain v7
Avatar
Avatar
1
aug. 15
7665
problem in installing crm_claim_ext
crm v7
Avatar
0
mei 15
5715
how to force user to fill fields on every stage of opportunity in openerp 7.0
crm v7
Avatar
Avatar
1
mrt. 15
6698
How domain defined for a field in header tag
crm domain
Avatar
0
mrt. 15
6149