Skip to Content
avatar image
Former Member

Need query help

Hi Experts

i had created a query, in which i need to filter it via, year wise for example , FY2014 and dept wise, in which dept is already working

how is it possible

the below attached is the query 

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT distinct T3.[Name] as 'Worker Category', max(T0.[U_Rate]) as 'Current Rate',

max(T1.[U_Rate]) as 'Revision Rate' ,T2.[Name]as 'Department'

FROM OHEM T0  INNER JOIN AHEM T1 ON T0.empID = T1.empid

INNER JOIN OUDP T2 ON T0.[dept]=T2.[Code]

INNER JOIN OHPS T3 ON T0.[position]=T3.posID

WHERE (T1.[U_IQId] <> T0.[U_IQId] OR T1.[U_IQId] is null ) and T0.[dept]='11'

group by T3.[NAME],T0.[U_Rate],T1.[U_Rate],T2.[Name]

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 02:02 AM

    Hi,

    You may try using AHEM.updatedate to filter.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 02:50 PM

    Hi,

    Do you have any UDF to capture employee creation date?

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Nagarajan K

      hi rajan

      my idea was first to just to get the result by entering FY2014 all the data for that year, any way

      i will use the update data itself, no issue

      regards