Service Solution

[former_member218051]

Hi All,

I want to frame a query which will give me call wise solutions entered in the service -> Service Call -> Solutions.

I am unable to find a link between OSCL i.e. SERVICE CALL MASTER & OSLT i.e. SOLUTIONS MASTER tables.

Apart from item code i did not found any link column.

If i use that then the solutions are not getting listed call wise.

Pls. help.

Thanks

Malhaar

[Former Member]

Hi Malhar

Try This

SELECT     T0.[callID],T0.customer, T0.custmrName, T1.ItemCode, T2.ItemName, T1.SltCode, T1.Subject, T1.Cause, T1.Descriptio,  T3.srcPath, T3.trgtPath, 
                      T3.FileName, T3.FileExt, T3.Date, T0.userSign
FROM         OSCL AS T0 Left outer join
                      ATC1 AS T3 ON T0.userSign = T3.UsrID CROSS JOIN
                      OSLT AS T1 left outer join
                      OITM AS T2 ON T1.itemCode = T2.ItemCode

Thanks,

Srujal Patel

[former_member196081]

Hi,

Try below......

OSCL T0 inner join  OSLT T1 on t0.callid = t1.sltcode

choose above both table and make join as above manually.

Regards

Deepak Tyagi

Edited by: Deepak Tyagi on Jun 10, 2011 8:35 AM

[former_member218051]

Hi Deepak,

SltCode is the primary key of OSLT table.

if you keep on entering solutin for each and every call then consequently callid and sltid will match.

but at random of somebody have entered the solutins rhen they will never match.

Thanks

Malhaar

[Former Member]

Hi Malhaar......

Better if you link a join with ItemCode on Both Tables.......

Regards,

Rahul

[former_member196081]

Hi,

You can use left outer join ...

Regards

Deepak Tyagi

[former_member218051]

Hi Rahul,

If i link on itemcode then it shows the solution where ever there is a match. but if you drill down to that service call the solution is not present.

thanks

Malhaar

[Former Member]

Hi Malhaar.......

You have to punch entry for Solution based knowledge for a service call and then you have to attach the same into the serveice call solution Tab.

Go to Service > Service Call> Solution Tab--> Solution based Knowledge....

Regards,

Rahul

[former_member218051]

Hi Rahul,

We have already entered solutions for the service calls.

Our management wants to see the solutions knowledge master with reference to the service call.

Thanks

Malhaar.

[former_member218051]

Hi all,

Thank you all guys for your response.

I worked out the query which, I'm sharing with the forum.

SELECT T0.[callID], T2.[SltCode], T0.[custmrName], T0.[createDate], T0.[subject], T2.[Subject] FROM OSCL T0 RIGHT OUTER JOIN SCL1 T1 ON T0.callID = T1.srvcCallID INNER JOIN OSLT T2 ON T1.solutionID = T2.SltCode

OSCL -- SERVICE CALL MASTER.

SCL1 -- SERVICE CALL SOLUTIONS ROWS.

OSLT -- SOLUTIONS MASTER.

Thanks

Malhaar

[Former Member]

That is really cool.....

It so nice of you that you are sharing your solution within forum.....

Thanks,

Rahul