Tuesday, September 16, 2025

BUGGISH: GitHub Search Result Does Not Show Certain Repositories (Work-around)

My corporation has over 15000 repositories. I have migrated over 800+ repositories with no issue. Suddenly a group of apps did not show up. I migrated more and those showed up.

I do not know if it was because of the timing to some internal issue to GitHub. I spent about an hour figuring out why it does not show. I can access the repositories manually by updating the URL.

I decided to see if I updated the description, if it would check there instead. And suddenly, it came up in the results. Only for that one repo. So, I had to go through each of the missing repos and update the description just to have it appear. I only put part of the project name and I can search the repo name that doesn't include the project name. 

My guess is that saving caused GitHub to "index" the repo again. The repos were migrated last Friday. It has been several days. I don't know the root cause but this seemed to resolve the issue. 

Friday, September 5, 2025

RANT: Atlassian Jira has nothing out of the box to filter basic admin search/filter

 As of 2025-09-05, there is nothing out-of-the-box with Jira to allow someone to find and identify an item with open sub-items or parent-items.


Scenario 1

There are several stories that were canceled that have sub-tasks that were not canceled. If you go to the default dashboard for yourself, all those sub-tasks still show up on your list. There is no way to find all the sub-tasks that have a parent-item that is Cancelled, Closed, or Done.


Scenario 2

I want to find stories that are not Cancelled, Closed, or Done that have all sub-tasks that are all Cancelled, Closed, or Done.

Thursday, July 10, 2025

HOWTO: Move every other row to column with any spreadsheet (Google Sheets or MS Excel)


Basic 

1. Copy all data from second row to last

2. Paste data to second column starting on the first row

3. In third column or new column, alternate 0 and 1

4. Sort by new column

5. Delete all rows not needed


Alternative

3a. Use row count

4a. Use if even/odd to filter the rows


More Rows

1. Use formula to extract data from next row to column
1a. Second column equals second row
1b. Third column equals third row
1c. Repeat until last data in set
2. Copy all the new columns
3. Paste as value in new columns
4. Delete formulated columns
5. Use new row to count (use either method from Basic or Alternative except expand to needed column count)
6. Sort or filter (use either method from Basic or Alternative to delete unneeded rows)