Request to update the search and list query

Hi Team,

It was observed that List and Search queries have some functional limitations which are handled explicitly by teams. Below are the expectations:

• Search queries must support pagination, enabling users to retrieve results beyond the current 1000-record limit.

• Pagination should include a cursor or offset mechanism, allowing seamless navigation through large datasets without data loss or duplication.

• List queries must support case-insensitive filtering

• Users need substring search over large datasets, which is not fully supported. Can we provide feature like "Contains" which will allow substring search.

Thanks,

Rahul