Which operating systems have you tested for this bug?
Windows
Which server did you use?
apache
Database
MariaDB 10.2
Did you customize Shield?
I customized the UserModel class to include a function to generate a full name of a user from their first and last name before insert and before update. I also customized the User entity class to include two functions to set the first and last name of a user after cleaning the string input and performing formatting on it like capitalization.
What happened?
Searching using the like clause doesn't work. Here is the code am using: auth()->getProvider()->like(['username' => $query, 'secret' => $query])->orderBy('id', 'ASC')->paginate(100, 'usersList', null, 4)
Steps to Reproduce
Include 'secret' column in the where clause so that someone can use the like clause to search for a user using both the username and email address.
Expected Output
The system should display a list of matches or no matches based on the provided query string.
PHP Version
8.2.0
CodeIgniter4 Version
4.4.5
Shield Version
1.0.1
Which operating systems have you tested for this bug?
Windows
Which server did you use?
apache
Database
MariaDB 10.2
Did you customize Shield?
I customized the
UserModel
class to include a function to generate a full name of a user from their first and last name before insert and before update. I also customized theUser
entity class to include two functions to set the first and last name of a user after cleaning the string input and performing formatting on it like capitalization.What happened?
Searching using the
like
clause doesn't work. Here is the code am using:auth()->getProvider()->like(['username' => $query, 'secret' => $query])->orderBy('id', 'ASC')->paginate(100, 'usersList', null, 4)
Steps to Reproduce
Include
'secret'
column in thewhere
clause so that someone can use thelike
clause to search for a user using both the username and email address.Expected Output
The system should display a list of matches or no matches based on the provided query string.
Anything else?
No response