Open qgis application and go to layer tab >>add arcgis rest server layer>> new > in the connection details give any name for name filed in your case 'shooting v2' in the url give the below one enter link description here

In the shootingV2 drop down you will get shooting layer select and add.

After that right click on the layer and Select filter and enter "RptYear" = 2024 And click on ok