Should return 416 when query transmissions with offset parameter and value is over than totalCount

[cherrycl]

🐞 Bug Report

Affected Services [REQUIRED]

The issue is located in: support-notifications

Is this a regression?

Yes

Description and Minimal Reproduction [REQUIRED]

1. Deploy service with compose file
2. Create subscription with following request body

POST http://localhost:59860/api/v3/subscription
[
   {
      "subscription":{
         "name":"Subscription-1730440698634",
         "description":"Test data for subscription",
         "channels":[
            {
               "host":"localhost",
               "port":7770,
               "httpMethod":"POST",
               "type":"REST"
            }
         ],
         "categories":[
            "health-check"
         ],
         "labels":[
            "simple"
         ],
         "receiver":"tafuser",
         "resendLimit":1,
         "resendInterval":"24h",
         "AdminState":"UNLOCKED"
      },
      "apiVersion":"v3"
   }
]

3. Create notifications with following request body

POST http://localhost:59860/api/v3/notification
[
   {
      "notification":{
         "description":"Test notification data 1730440698644",
         "labels":[
            "simple"
         ],
         "contentType":"string",
         "content":"This is a test notification",
         "sender":"taf-admin",
         "severity":"MINOR",
         "status":"NEW"
      },
      "apiVersion":"v3"
   },
   {
      "notification":{
         "description":"Test notification data 1730440698646",
         "category":"health-check",
         "labels":[
            "simple"
         ],
         "contentType":"string",
         "content":"This is a test notification",
         "sender":"taf-admin",
         "severity":"CRITICAL",
         "status":"NEW"
      },
      "apiVersion":"v3"
   },
   {
      "notification":{
         "description":"Test notification data 1730440698647",
         "category":"no-subscription",
         "labels":[
            "simple"
         ],
         "contentType":"string",
         "content":"This is a test notification",
         "sender":"taf-admin",
         "severity":"NORMAL",
         "status":"NEW"
      },
      "apiVersion":"v3"
   },
   {
      "notification":{
         "description":"Test notification data 1730440698649",
         "category":"health-check",
         "labels":[
            "simple"
         ],
         "contentType":"string",
         "content":"This is a test notification",
         "sender":"taf-admin",
         "severity":"MINOR",
         "status":"NEW"
      },
      "apiVersion":"v3"
   },
   {
      "notification":{
         "description":"Test notification data 1730440698650",
         "category":"health-check",
         "labels":[
            "simple"
         ],
         "contentType":"string",
         "content":"This is a test notification",
         "sender":"taf-admin",
         "severity":"NORMAL",
         "status":"NEW"
      },
      "apiVersion":"v3"
   }
]

4. Query transmission with API
   GET http://localhost:59860/api/v3/transmission/all?offset=10

🔥 Exception or Error

{
    "apiVersion": "v3",
    "statusCode": 200,
    "totalCount": 4,
    "transmissions": []
}

Expected result: Return status code 416

🌍 Your Environment

Deployment Environment: Ubuntu 2204 / arm64

EdgeX Version [REQUIRED]: Main

Anything else relevant?