Скачать или смотреть Understanding the empty recordset Issue in Odoo 14

Learn how to resolve the empty recordset issue in Odoo 14 when searching using model relationships. This guide covers the correct syntax for queries.
---
This video is based on the question https://stackoverflow.com/q/77322418/ asked by the user 'user1632812' ( https://stackoverflow.com/u/1632812/ ) and on the answer https://stackoverflow.com/a/77322745/ provided by the user 'OpenCode' ( https://stackoverflow.com/u/11362175/ ) 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: empty recordset. Why?

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.
---
Understanding the empty recordset Issue in Odoo 14: A Complete Guide

Have you ever encountered an empty recordset while working in the Odoo 14 shell? This issue can be quite frustrating, especially when you're certain that records exist in the database. In this guide, we will discuss this problem and provide a solution that you can use to avoid this pitfall in your projects.

The Problem: Empty Recordset

Imagine you are trying to retrieve records from a model called model_A based on a relationship with another model, model_B. You might execute a command like this:

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

However, instead of getting the expected records, you receive an empty recordset. You may be wondering, "Why am I not getting the records I know exist?"

Common Reasons for Empty Recordsets

Syntax Errors: Small mistakes in your search query can lead to no results being returned.

Query Structure: Odoo requires specific formats when querying models, especially when dealing with relationships.

Data Types: Certain fields may require specific data types for the search conditions.

The Solution: Correcting the Search Syntax

In response to this issue, the solution lies in using the correct syntax for your search command. Instead of searching like this:

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

You should structure your search like this:

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

Key Points to Note

Using Tuples: In Odoo, when searching for records, you need to provide the search criteria as a list of tuples. The correct format ('field_name', 'operator', value) should always be maintained.

Using Integers: When a field represents a many-to-one relationship (like model_B_id), you must pass the ID as an integer. In this case, using 17 directly suffices as it represents an integer.

Parentheses Matter: Notice how the search condition is enclosed in parentheses. This is essential for the Odoo ORM engine to interpret your search criteria correctly.

Conclusion

If you encounter an empty recordset while querying in Odoo 14, remember to check the syntax of your search commands. By utilizing the correct tuple format and ensuring you're using the appropriate data types, you can retrieve the records as expected.

With this knowledge in hand, you can resolve the issues that arise from improperly structured queries and improve your Odoo 14 experience significantly. Happy coding!