but if you pee on your hands the test will be negativeActually, it only indicates the possibility they fired a gun. It tests for nitrates, and there are several common items that can give a false positive, most notably any type of common fertilizer.
Calling it "gunpowder residue" is a misnomer - it can be residue of a lot of things, including hot dogs.