* get value bound for index scan

* change user email

* fixed linterror

* Addressed dutor's comments

* Simplified code logic for string

* fixed error

* Simplify the code

Co-authored-by: dutor <440396+dutor@users.noreply.github.com>