DD's Stats

Members
Total Members: 157
Latest: irsmalik
New This Month: 7
New This Week: 3
New Today: 0
Stats
Total Posts: 876
Total Topics: 444
Most Online Today: 3
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 2
Total: 2

Recommended Posts

DD Approved Members group Added by DD Admin
05-06-2020, 12:48:35


Posting Additions or alterations rules by DD Admin
27-02-2020, 10:33:01


A Trip Down Memory Lane by DD Admin
24-08-2019, 14:17:16


Todays Birthdays

DD's Top Posters

DD Admin
Posts: 910
borobutch
Posts: 69
Carol
Posts: 12
Ram
Posts: 8
Clarissa
Posts: 8
richardsoj
Posts: 5
ComputerTech
Posts: 5

Author Topic: Bug Tracker Project Status  (Read 66 times)

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Bug Tracker Project Status
« on: April 03, 2020, 04:34:13 pm »


I've started work on the ERD I'm posting what I've done to date, One thing to note is it's using a altered copy of the task Management Template I was going to remove the customer contacts but when I got to the Bug reporting I found that customer contacts are required as a bug could be reported by a customer/User so have to allow for customers and also in house testing.

so this is what it look like so far:
1448-1

« Last Edit: April 04, 2020, 08:16:56 pm by Michael »

Share on Facebook Share on Twitter


Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #1 on: April 04, 2020, 05:19:05 pm »
Have made a few alterations as I was going though the ERD Adding the tables as below:
1460-0

This is what the Relationships look like in access
1464-1

As you can see I have added a few additional fields the main one being the LevelUpdated as I can use this to show when an employees experience was updated it would also Identify which enployees were stuggling and maybe needed a bit of help.
Also I was going to use the task Category Table but decided to use a seperate one for bugs it may have limited that leaving it as was.
« Last Edit: April 04, 2020, 06:54:41 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Bug Tracker Project Status
« Reply #2 on: April 04, 2020, 11:09:06 pm »
Have updated the copy of TaskManagement I'm using so it will now use the BugID in tasks and reports, Plus created the first of the screens.

Projects List:

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #3 on: April 05, 2020, 05:48:51 pm »
Have added the Employee Skill and related items.

I have added a updated spin up/down to the Levels I will include the current data in the final file plus explain how all the bits fit together in the user manual

Employee form I may add a count for number of Skills added just haven't made my mind up yet.
1470-0

Employee Skills: Add a Skill then a level for that skill NOTE: When you update the level the Level Updated Date will be updated to current date but you can alter this should that not be the date the level was given, The Skill Attained Date is added when a new record is added but can be updated.
All items are required.
1472-1

Skills List
1474-2

Skills Levels List
1476-3

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Bug Tracker Project Status
« Reply #4 on: April 07, 2020, 10:18:15 pm »
Moved along with the bug tracker today

Bug Reporter still needs a lot of work but starting to take shape.
1485-0

Status Editor
1487-1

Project versions
1489-2

I will be adding a bug category editor tomorrow as I decided to make the bug categories seperate from the Task Categories not sure why just seems right.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #5 on: April 12, 2020, 09:12:13 pm »
Have spend a good 4-5 hour today and moved along with the project nicely

The Bug Reporter This screen is just about complete and just needs futher testing
1530-0

The Current form I'm working on is the main task and employee assignment screen this is a unbound screen and has 2 mods one viewing the requested task I.E. FROM the task list and adding a new task from the bug reporter screen.
1536-1

The main Tasks list is nearly complete except for more testing and a lookup filter for when data is requested by the Bug Recorder
1532-2

The task List Filter screen again complete I don't think it requires more testing
1534-3
« Last Edit: April 13, 2020, 12:35:35 pm by Michael »

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #6 on: April 13, 2020, 07:24:25 pm »
Completed most of the work on the task screen so it can now add or edit tasks

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #7 on: April 14, 2020, 04:38:20 pm »
Getting Very Close Now

Just About Finnished with the tasks screen bar a bit of testing and the bug search screen is complete bar testiing, the Print screen has been finnished and will under go testing when I have a few reports

I'm going to use the reports main screen from the Charitable Contributions Template for the main control.
1542-0

1544-1

1546-2

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #8 on: April 14, 2020, 07:24:30 pm »
Thats my llot today added the print screen and updated for use with the but tracker.

1548-0

I have one more object to Update thats the task assign employees screen below I will need to turn that into a search screen so the right person can get assigned to the task baised on there skills, I'll be starting that tomorrow

1550-1

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 910
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
Re: Bug Tracker Project Status
« Reply #9 on: April 15, 2020, 02:55:10 pm »
Got the final screen complete this is a complex screen even though it dosen't look it, when the employees list is filtering for employees with the skills and levels selected it uses 3 sub queries
1 to limit the employees already attached to the task
2 Limit By 1 or more skills
3 Limt By 1 or more Levels

The skills list contains the same subquery as the man employees list so only this skills for employees NOT assigned to the task are shown.

1552-0

 

Related Topics

  Subject / Started by Replies Last post
38 Replies
214 Views
Last post August 22, 2020, 09:52:33 pm
by DD Admin
0 Replies
20 Views
Last post July 03, 2020, 12:28:25 pm
by DD Admin
57 Replies
252 Views
Last post January 02, 2021, 03:52:13 pm
by DD Admin
9 Replies
117 Views
Last post January 15, 2021, 11:00:15 am
by DD Admin
0 Replies
8 Views
Last post December 10, 2020, 08:41:12 pm
by DD Admin

DD's Social Media

DD's Programs


Development Schedule

DD's Freeware

Apollo

DJ 2020

Chart Tracker Elite

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

Project Manager (accde)


Developer Tools

Project Manager (accdb)

Style Manager

Code Library


Open Code Templates

Master Template

Task Management

Charitable Contributions

Bug Tracker Template

Time And Billing Template

Real Estate Template

Household Inventory V1


Open Code Examples

DD's Northwind V1

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples


Recent Topics

Apollo Project Status by DD Admin
January 15, 2021, 11:00:15 am

Apollo Manual: Main Music Player by DD Admin
January 13, 2021, 10:21:36 am

UK Singles/Albums Charts 01 Jan 2021 to 07 Jan 2021 Analysis by borobutch
January 11, 2021, 09:27:29 pm

Please welcome irsmalik to DD by DD Admin
January 11, 2021, 09:34:58 am

Please welcome FamiliaRoca to DD by DD Admin
January 11, 2021, 07:49:40 am

Please welcome Gasman to DD by DD Admin
January 10, 2021, 02:01:23 pm

Please welcome ferrancc to DD by DD Admin
January 09, 2021, 06:21:49 pm

Database Dreams is not affiliated with Microsoft