Show All Projects
TechHELP was Tim's project, but I made significant contributions to it. Before Kofax Support transitioned to SalesForce, this was an internal web frontend to view support cases as an alternative to the unituitive old CMS program we used. It was fun working on this because it was collaborative, the end product actively made my job easier, and other people enjoyed using it.

Despite that, project was done with the "ask forgiveness, not permission"-idea. We had access to resources we were not meant to, but no one took any action about that because what we made was unarguably useful, and we would be moving to SalesForce eventually anyway.

The main appeal was that it provided a very simple view to cases of various criteria, highlighting cases that needed attention. Domain authentication was used to show an individuals cases without any login needed. It even tied in with the other systems to show knowledgebase articles written and Software Problem Reports written. Customer Surveys were exposed as well, which were not available to us before, and have not been available to us again after the move to SalesForce.

The more experimental features included a search to try to make sense of the (at the time) mess of contact information, and a chart to show chart to show knowledgebase articles most often used to solve cases.

Timeline

Screenshots

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Project / Id )  0.0107
Total Execution Time  0.0126
  GET DATA  
No GET data exists
  MEMORY USAGE  
909,184 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/72/TechHELP
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0032 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '72' 
0.0005   SELECT *
FROM `Projects`
WHERE `ProjectID` = '72' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '72' 
0.0009   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0008   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)