Nov 062014

Atlassian have not added subQuery support to the Jira query language (JQL) but you can do it via saved filters. When you save a filter you will notice it has a filterid in the url and you give it a name. You can’t reference the filterid in JQL without plugins but out of the box JQL allows you to reference the filter by name.

Say you want to find all the bugs closed by your team in the last 4 months.
Filter “Team Y bugs closed in last 4 months”:
project = XXX AND component = "Team Y" AND resolutiondate >= startOfMonth(-4M) AND issuetype in (bug) AND status = closed AND resolution = fixed

The you want to find all the bugs raised by your team which were closed by other teams.
Filter “Bugs raised by Team Y and fixed by other teams”:
project = XXX AND reporter in (Team member Y1, Team member Y2, Team member Y3) AND resolutiondate >= startOfMonth(-4M) AND issuetype in (bug) AND status = closed AND resolution = fixed and filter != "Team Y bugs closed in last 4 months"

If you are sharing the second filter you will want to ensure sharing permissions are also extended for the first filter.

 Posted by on November 6, 2014  Tagged with: ,
Oct 202014

I had to send my phone in for repair again, so once again I was looking at backing it up over the weekend.

I have the HTC Sync\Backup app installed but it does not seem to offer that much in terms of app backup.

I looked at Titanium Backup as previously mentioned but baulked due to the phone needing to be rooted and I not wanting to affect my guarantee when I was returning it for repair.

Via Lifehacker I took a look at Helium desktop which is advertised as working without rooting your phone. I installed the windows app & the android app. Even though I can see the contents off my phone in windows explorer and in htc sync manager when I connect it, Helium did not see my phone asking me to install drivers.

helium error.jpg

Following the Helium installation instructions I installed the common HTC driver listed and restarted but I still got the error message.

So no change at the moment to my backup process.

 Posted by on November 6, 2014  Tagged with: ,
Aug 292014

This year I have upgraded from a Samsung S3 to a HTC One (M7) and also had a HTC One replacement due to a bluetooth problem. In both those cases I managed the backup process myself. Having gone though this experience I think next time I will invest in the likes of Titanium Backup.

All my contacts are stored in Google contacts so that makes transition easy. Pulling down the People app left source menu you can see the contacts which are on the phone\SIM and decide if you want to move them to google.

A number of the apps I use store in the cloud, e.g., Pocket. Also, I store my passwords file for KeePassDroid in dropbox anyway.

I used the free and excellent Es File Explorer to allow me to copy backup files to a backup directory in dropbox and restore from there on the new phone. The dropbox folder location is found at /mnt/sdcard/Android/data/

I use SwipePad as my launcher. It has an option to back up via the More Spaces add-on (allows larger grids to show more apps on the screen). The backup is stored in /storage/emulated/0/swipepad_backup.db. I copied this to DropBox and restored from there to this location, this was picked up on the new phone. Be careful if you have a backup already there swipepad_backup(1).db will be created and the restore only picks up swipepad_backup.db.

I use Go SMS Pro for my SMSs. The app has a backup & restore option via the More Tools menu, you need to copy to /sdcard/GOSMS/backup/localbr directory to restore. Update Oct 14 – when I went to restore GOSMS Pro had upgraded to v6 and the restore was changed so I have not been able to get it back yet.

WhatsApp has a Backup conversations option via the Chat Settings sub menu. This creates a proprietary timestamped .crypt file in /storage/emulated/0/WhatsApp/Databases. However they have no restore or merge option (if you have been using another phone for a while) :-( You can include the backup file in the WhatsApp Databases folder after downloading, on install it finds this and asks you to restore it, however this restore completely failed for me :-(

I use Podkicker for podcasts, it has a opml backup within the app, you can copy /storage/emulated/0/Android/data/com.podkicker/files/podkicker_backup.opml to Dropbox. For restoring from the Dropbox app export to your download folder. In podkicker go to subscribe, OPML & it will find the file in your download folder. .

Food Diary has an export & import option, which works fine. I have blogged about this before.

I use LLama to automatically make my phone go into quiet mode at work, etc. It has a backup option in the app which copies 5 files to /storage/emulated/0/llama. Restoring the files to this location works. You them have to go into the Recent tab and re-hookup cells to an Area – minimal effort.

 Posted by on November 6, 2014  Tagged with: ,