Hi Smith,

In your custom module, check how it differentiates between students and faculty.

For example,

Let's assume that there is a selection field called "type," where the options are  [('student', 'Student'), ('faculty', 'Faculty'), ('others', 'Others')], 

Then query for students will be  

SELECT * FROM hr_employee WHERE type = 'student'

If the students have separate model, for example, 'student.student' in odoo.
Then the query will be,

SELECT * FROM student_student.

Remember to replace the '.' in the model name with '_' when mentioning the table name in the query.

Hope it helps,
Kiran K

For example, let's assume the following table names for Odoo:

• Students: school_student
• Faculty: school_faculty
• Inventory Items: product_template

Your queries might look like this:

sqlCopy code-- List Students
SELECT * FROM school_student;

-- List Faculty
SELECT * FROM school_faculty;

-- List Inventory Items
SELECT * FROM product_template;

Note: The table names I provided are just placeholders. You need to replace them with the actual table names or models used in your Odoo instance. You can find this information by checking the database structure or consulting the Odoo documentation.

Additionally, you may want to refine your queries by specifying conditions or joining tables based on the relationships between different entities in your Odoo system. For example, if students are associated with a particular faculty, you might use a JOIN clause to retrieve data from both the school_student and school_faculty tables.

Here's a simple example assuming there's a foreign key relationship between school_student and school_faculty:

 code-- List Students with Faculty Information
SELECT school_student.*, school_faculty.*
FROM school_student
JOIN school_faculty ON school_student.faculty_id = school_faculty.id;

Again, you should adapt these queries based on your actual Odoo database structure and relationships.