Is it possible that the other party can request a warrant of arrest even if the case has been dismissed by court? Thanks

The "other party' can ask for you to be executed if they want, it has no bearing.

For an arrest warrant, there has to be formal charges according to your state law, and a judge to sign off on it.

If the case was dismissed, if there is additional evidence, they can refile charges of course.

The court dismissed the case due to lack of evidence or no evidence at all, and yes there's no solid evidence for their claims how come a complainant attorney can summon or refile the case? And can request an arrest warrant? Something fishy going on

What type of case is this ?

Only in a civil case will the other side have an attorney and you can't go to jail or be arrested for a civil case ( except child support)

The DA is the only one to present things to the court in criminal charges