Scattering studies of density wave orders in unconventional superconductors