Error: "tabLMS Enrollment"."progress" ilike '%%100%%'

[TGTGamer]

Describe the bug
Database query error

To Reproduce
Install LMS using get-app lms and install-app lms

Expected behavior
No error

App Versions

{
	"control_centre": "0.0.1",
	"discord_integration": "0.0.1",
	"erpnext": "15.2.0",
	"fleet_management": "0.0.1",
	"frappe": "15.1.0",
	"gaming": "0.0.1",
	"grand_theft_auto": "0.0.1",
	"healthcare": "15.0.0-dev",
	"incident_management": "0.0.1",
	"justice": "0.0.1",
	"lending": "0.0.1",
	"lms": "1.0.0",
	"payments": "0.0.1",
	"segment_connect": "0.0.1",
	"teamspeak_integration": "0.0.1",
	"vetting": "0.0.1"
}

Route

Workspaces/LMS

Traceback

Error in query:
operator does not exist: numeric ~~* unknown
LINE 3:    where "tabLMS Enrollment"."progress" ilike '%%100%%'
                                                ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 110, in application
    response = frappe.api.handle(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/__init__.py", line 49, in handle
    data = endpoint(**arguments)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
    return frappe.handler.handle()
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 49, in handle
    data = execute_cmd(cmd)
           ^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 85, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 1683, in call
    return fn(*args, **newargs)
           ^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 848, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/desk/reportview.py", line 58, in get_count
    data = execute(**args)[0].get("total_count")
           ^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/desk/reportview.py", line 64, in execute
    return DatabaseQuery(doctype).execute(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/db_query.py", line 200, in execute
    result = self.build_and_run()
             ^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/db_query.py", line 240, in build_and_run
    return frappe.db.sql(
           ^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/postgres/database.py", line 203, in sql
    return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 217, in sql
    self._cursor.execute(query, values)
psycopg2.errors.UndefinedFunction: operator does not exist: numeric ~~* unknown
LINE 3:    where "tabLMS Enrollment"."progress" ilike '%%100%%'
                                                ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

Request Data

{
	"type": "POST",
	"args": {
		"doctype": "LMS Enrollment",
		"filters": "{\"progress\":[\"like\",\"%100%\"]}",
		"fields": "[]",
		"distinct": false
	},
	"headers": {},
	"error_handlers": {},
	"url": "/api/method/frappe.desk.reportview.get_count",
	"request_id": null
}

Response Data

{
	"exception": "",
	"exc_type": "UndefinedFunction"
}

[pateljannat]

@TGTGamer I am unable to replicate this. Please share the steps to replicate.