Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How I can separation: timesheet line,task timesheet,issue timesheet in table account_analytic_line

on 10/28/15, 7:58 AM 172 views

  query result mistake:

SELECT name,unit_amount,date FROM account_analytic_line

WHERE account_id=100 AND user_id=2 AND id IN


    SELECT hat.line_id FROM hr_analytic_timesheet as hat,project_task_work as ptw

            WHERE hat.issue_id is null AND line_id not in(

                select ptw.hr_analytic_timesheet_id from project_task_work as ptw,hr_analytic_timesheet as hatt

                where ptw.hr_analytic_timesheet_id=hatt.line_id and ptw.user_id=2)


please help me..................................

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 10/28/15, 7:58 AM
Seen: 172 times
Last updated: 10/28/15, 7:59 AM