How to customise strapi admin data which we see, while adding content to content manager, like exclude draft content from relational field

System Information
  • 4.3.4:
  • Ubuntu 18:
  • postgres:
  • 16.16:
  • 8.11:
  • Yarn Version:

In Strapi Admin panel,
I have two relational collection type Book, and Author, Book has (one-to-one) relation with Author.
Now, while adding a new book from admin panel, in Author relation drop down it show all authors,
But I want to see only author which are in Published state. I want to exclude Draft Authors from this drop down, How can I achieve this.
Any help and suggestion are highly appreciable.