Odoo Help

0

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

By
sama
on 10/28/15, 7:58 AM 382 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..................................

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

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