How to Filter Employees by Project in Odoo 12

Discover how to effectively filter employees based on project selection in Odoo 12, by using the correct syntax in the search method.
---
This video is based on the question https://stackoverflow.com/q/64602112/ asked by the user 'pedrommuller' ( https://stackoverflow.com/u/690413/ ) and on the answer https://stackoverflow.com/a/64603103/ provided by the user 'Saumil gauswami' ( https://stackoverflow.com/u/12350123/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Filter employees by project in odoo 12

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Filtering Employees by Project in Odoo 12

Customizing the Odoo project module can be a bit tricky, especially when it comes to setting up dynamic dropdowns that depend on user selections. A common scenario arises when you want a dropdown to show employees assigned to tasks related to a selected project. In this post, we will dive into how to implement this feature in Odoo 12 and resolve potential errors you might encounter.

The Problem

You're working on a model where projects have tasks assigned to employees. You want to create a dropdown that filters employees based on the project selection. However, since there is no direct relationship, you must search through tasks related to the selected project first, then find the corresponding employees.

Here's a quick summary of the code structure you initially have:

[[See Video to Reveal this Text or Code Snippet]]

While this structure is a good start, you faced an issue with searching for employees based on user IDs.

The Solution

The problem lies in the syntax used for the search method on the employee model. When you tried executing the following line:

[[See Video to Reveal this Text or Code Snippet]]

You encountered an IndexError. This happens because the structure of the search criteria is not correctly formatted.

Correct Syntax

To fix this problem, you need to make sure that the search criteria is wrapped in round parentheses. Modify your search line to the following:

[[See Video to Reveal this Text or Code Snippet]]

Explanation

Round Braces: The search function requires a domain defined with tuples, and without the round braces around your conditions, Python does not treat it as a single argument.

Domain List: The search method in Odoo expects a list of tuples. Each tuple defines a condition (field, operator, value).

Revised Change Method

Here’s how your updated method should look:

[[See Video to Reveal this Text or Code Snippet]]

Summary

By ensuring you use the correct syntax for the search function, you can dynamically filter employees based on the selected project. This approach helps in creating a more user-friendly experience in Odoo 12.

Feel free to implement this solution in your project module and enjoy a smoother filtering experience!