Need query help

[Former Member]

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

[Former Member · Accepted solution]

Hi,

You may try using AHEM.updatedate to filter.

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks Gordon

[kothandaraman_nagarajan]

Hi,

Do you have any UDF to capture employee creation date?

Thanks & Regards,

Nagarajan

[Former Member]

Hi rajan

no we do not capture employee creation date in udf

Regards

[kothandaraman_nagarajan]

I thought your requirement is to filter employee based on creation date. Thats why i raised above question.

What will happen if you use OHEM.updatedate? Just for clarification.

[Former Member]

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