How to make ListPreference with adapter in android?

Question

Android

How to make a ListPreference element with an adapter in PreferenceActivity to display list items from the database?

Answer 1

It turns out that it was necessary to write status = '1'
That is:
The status field was enum(-1, 0, 1), but I did it in Laravel Migrations:
And in PHPMyAdmin it shows the field type (status) like this:
In short, everything was decided

Answer 2

You most likely have an error with priorities in WHERE and your second option is
and so `status` only counts with the `description` field, while `title` and `domain` are chosen with any status