1000kisoen
IS-IT--Management
hi,
I am creating a search page
the query is like this
SELECT Call.CallID, Call.CallTypeID, Call.IntakeDate, Call.CustomerName, Call.SystemID, Call.ShortDescription, Q_LastLogstatus.CallStatusID, Q_LastLogstatus.CallStatus, CallStatus.CallGroupStatus, Support.SupportTeamID FROM ((Call INNER JOIN Q_LastLogstatus ON Call.CallID = Q_LastLogstatus.CallID) INNER JOIN CallStatus ON Q_LastLogstatus.CallStatusID = CallStatus.CallStatusID) INNER JOIN Support ON Call.IntakeBy = Support.SupportID WHERE support.supportlogin = 'varuser'
name = varuser -- value = me --run time value = request("svusername")
so I want to query of my own record but is not working
(like a personal overview)
am i doying something wrong?
working with MX
please advise
thx kisoen
I am creating a search page
the query is like this
SELECT Call.CallID, Call.CallTypeID, Call.IntakeDate, Call.CustomerName, Call.SystemID, Call.ShortDescription, Q_LastLogstatus.CallStatusID, Q_LastLogstatus.CallStatus, CallStatus.CallGroupStatus, Support.SupportTeamID FROM ((Call INNER JOIN Q_LastLogstatus ON Call.CallID = Q_LastLogstatus.CallID) INNER JOIN CallStatus ON Q_LastLogstatus.CallStatusID = CallStatus.CallStatusID) INNER JOIN Support ON Call.IntakeBy = Support.SupportID WHERE support.supportlogin = 'varuser'
name = varuser -- value = me --run time value = request("svusername")
so I want to query of my own record but is not working
(like a personal overview)
am i doying something wrong?
working with MX
please advise
thx kisoen