TimePeriod

[soniasweety]

Hi all,

I have a two  tables one is main table, one is SLA table

so I need to map the data based on type and task status I need to show the numbers . attached excel is the sample data

I explained with example in sheet1

can anyone suggest the way to achieve this?

Thanks

Sony

[antoniotiman]

Hi,

See Attachment.

Regards,

Antonio

[soniasweety]

thanks for your attempt Antonio .  But  that is not my expected result. it is showing all the tickets

but I need only the ticket status value is greater than main table data rest it should not be shown in table.

Could guide on that way?

example: SLA table

Order

ZAA - OS (Configure  )

129600

108000

86400

M-57600

   Main table 

MM15343678

Order

SCTASK5415502

ZAA - OS (Configure  )

Medium

Open

612078 like30000

in above  record elopse time in main table is greater than Sla table status  Medium  so it is displaying   but if it is less than that it should not be displayed in table:

instead of 612078   if you put 30000   still the ticket is showing.

thanks

Sony

[antoniotiman]

Like this

[soniasweety]

thanks Antonio but what is the difference between in your first attachment ? nd second?

[antoniotiman]

I'm sorry, I don't understand Your request.

What is Your expected output ?

[soniasweety]

Hi,

in my original app am getting  duplicate values I need distinct how to use distinct in the exp?

[antoniotiman]

Can You show Your expected output ?

[soniasweety]

whatever you have done is correct . but in my app it is each duplicate numbers

[antoniotiman]

I don't see Your app and result.

Can You provide sceenshot ?