Searching Using Like Clause Gives An Error

[Elvis254]

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 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.

Anything else?

No response

[kenjis]

There is no secret column in users table:

shield/src/Database/Migrations/2020-12-28-223112_create_auth_tables.php

Lines 48 to 56 in 0802f39

	'id' => ['type' => 'int', 'constraint' => 11, 'unsigned' => true, 'auto_increment' => true],
	'username' => ['type' => 'varchar', 'constraint' => 30, 'null' => true],
	'status' => ['type' => 'varchar', 'constraint' => 255, 'null' => true],
	'status_message' => ['type' => 'varchar', 'constraint' => 255, 'null' => true],
	'active' => ['type' => 'tinyint', 'constraint' => 1, 'null' => 0, 'default' => 0],
	'last_active' => ['type' => 'datetime', 'null' => true],
	'created_at' => ['type' => 'datetime', 'null' => true],
	'updated_at' => ['type' => 'datetime', 'null' => true],
	'deleted_at' => ['type' => 'datetime', 'null' => true],

See https://shield.codeigniter.com/getting_started/concepts/#user-identities

[Elvis254]

That is the error am getting when I write auth()->getProvider()->like(['username' => $query, 'secret' => $query])->orderBy('id', 'ASC')->paginate(100, 'usersList', null, 4) as shown above. Are we able to use the two fields when searching for a user because the provider fetches values from both the users and identities tables when listing? This code auth()->getProvider()->orderBy('id', 'ASC')->paginate(100, 'usersList', null, 2) works for listing purposes no need to write a join clause to get the secret value from the identities table.

[kenjis]

The CodeIgniter’s Model provides convenience features and additional functionality that people commonly use to make working with a single table in your database more convenient.
https://codeigniter4.github.io/CodeIgniter4/models/model.html#models

You get the error because there is no column named secret in the table.
So you need to join by yourself.

[Elvis254]

Okay let me do it.