You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We need a web API that dumps the badge data - counts of each badge per person - so ad-hoc reporting is possible via Excel or other analytics tool (Power BI?).
The output from this service will be loaded into Excel, so the output should be a CSV or tab-delimited text file that can be downloaded. It is less of a "service" than downloading a generated file.
Each row in the file should contain:
Username (e.g. "rockyl")
User first name
User last name
Badge id
Badge name
Badge graphic URL
Date awarded
Amount awarded for badge
Was the amount paid out for this badge
The output should include all badges for all people - just a big table of data that can be analyzed in Excel.
The text was updated successfully, but these errors were encountered:
For a short term fix we can at least have a call people can make to return all the people who have received a particular badge. Query should look something like:
select ba.badgeawardid, ba.awardAmount, ba.paidout, B.BadgeName, E.FirstName, E.LastName, BA.awardDate from badgeaward BA inner join employee E on BA.employeeid = E.employeeid inner join badge B on BA.badgeid = B.badgeid where B.BadgeName = 'Secure Developer Level 1'
We need a web API that dumps the badge data - counts of each badge per person - so ad-hoc reporting is possible via Excel or other analytics tool (Power BI?).
The output from this service will be loaded into Excel, so the output should be a CSV or tab-delimited text file that can be downloaded. It is less of a "service" than downloading a generated file.
Each row in the file should contain:
The output should include all badges for all people - just a big table of data that can be analyzed in Excel.
The text was updated successfully, but these errors were encountered: