@Raghu Dandu​ :

The error message suggests that the column "designation" does not exist in the table "tbl_customers". There could be several reasons for this error, such as a typo in the column name, a missing or deleted column, or a difference in the table schema.

To resolve this error, you should check the schema of the "tbl_customers" table and make sure that the column "designation" exists in the table. You can also try to qualify the column name with the table name or alias to avoid any ambiguity in the column name, like "tbl_customers.job_role" instead of just "job_role".

If the column "designation" is missing or renamed, you may need to modify your function accordingly or update the table schema.