package Ġcom . f 4 erp . help _ desk . repositories Ċ Ċ import Ġcom . f 4 erp . help _ desk . entities . User Entity Ċ import Ġorg . springframework . data . jpa . repository . Query Ċ import Ġorg . springframework . data . repository . Paging And Sorting Repository Ċ import Ġorg . springframework . stereotype . Repository Ċ Ċ @ Repository Ċ interface ĠUser Repository Ġ: ĠP aging And Sorting Repository < User Entity , ĠString > Ġ{ ĊĠĠĠ Ġ@ Query ( value Ġ= Ġ" SELECT Ġ* ĠFROM Ġuser _ entity ĠWHERE Ġuser _ role Ġ= Ġ? 1 ", Ġnative Query Ġ= Ġtrue ) ĊĠĠĠ Ġfun ĠfindBy UserRole ( user Role : ĠString ): ĠList < User Entity > Ċ } Ċ