What is the ruling on bearing false witness if no one is harmed by it, and it was for the purpose of an niece obtaining her rights, and the case failed?

False testimony is forbidden and a major sin. It is not permissible to resort to it, even if it harms no one. When necessary, one can use ma'areed (euphemisms or ambiguous statements) to arrive at the truth.