Server: Find users per name or email address in /settings/users list

Created on 25 May 2018  路  5Comments  路  Source: nextcloud/server

Steps to reproduce

  1. go to /index.php/settings/users
  2. press ctrl+f or click in the NC search field
  3. enter part of name or email address or part of the username

Expected behaviour

username, email AND name (OR connected) should be queried for the searchstring and this result should be shown.

Actual behaviour

Only username is queried.

Server configuration

Operating system:
SLES Expanded Support platform release 7.5

Web server:
Apache 2.4
Database:
mariadb 5.5
PHP version:
php7.0.22
Nextcloud version: (see Nextcloud admin page)
13.0.1.1
Updated from an older Nextcloud/ownCloud or fresh install:
upgraded since owncloud 5
Where did you install Nextcloud from:
official sources from nextcloud.com
Signing status:


Signing status

No errors have been found.

List of activated apps:


App list

occ app:list
Enabled:
  - admin_audit: 1.3.0
  - comments: 1.3.0
  - dav: 1.4.6
  - federatedfilesharing: 1.3.1
  - federation: 1.3.0
  - files: 1.8.0
  - files_pdfviewer: 1.2.1
  - files_sharing: 1.5.0
  - files_texteditor: 2.5.1
  - files_trashbin: 1.3.0
  - files_versions: 1.6.0
  - files_videoplayer: 1.2.0
  - firstrunwizard: 2.2.1
  - groupfolders: 1.2.0
  - logreader: 2.0.0
  - lookup_server_connector: 1.1.0
  - nextcloud_announcements: 1.2.0
  - notifications: 2.1.2
  - oauth2: 1.1.0
  - password_policy: 1.3.0
  - provisioning_api: 1.3.0
  - serverinfo: 1.3.0
  - sharebymail: 1.3.0
  - systemtags: 1.3.0
  - theming: 1.4.1
  - twofactor_backupcodes: 1.2.3
  - updatenotification: 1.3.0
  - workflowengine: 1.3.0
Disabled:
  - activity
  - encryption
  - files_external
  - gallery
  - survey_client
  - user_external
  - user_ldap

Nextcloud configuration:


Config report

occ config:list
{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "13.0.1.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "loglevel": 1,
        "logfile": "\/opt\/appl\/serverlogs\/owncloud.log",
        "updatechecker": false,
        "knowledgebaseenabled": false,
        "appstoreenabled": true,
        "appstore.experimental.enabled": true,
        "proxy": "localhost:3128",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "theme": "",
        "trusted_domains": [
            "transfer.oebb.at"
        ],
        "secret": "***REMOVED SENSITIVE VALUE***",
        "share_folder": "\/Shared",
        "mail_smtpmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "overwritehost": "transfer.oebb.at",
        "overwriteprotocol": "https",
        "overwritewebroot": "",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "enable_avatars": true,
        "trashbin_retention_obligation": "auto, 14",
        "versions_retention_obligation": "auto",
        "auth.bruteforce.protection.enabled": false,
        "singleuser": false,
        "overwrite.cli.url": "https:\/\/transfer.oebb.at",
        "updater.release.channel": "stable",
        "mail_smtpauthtype": "LOGIN"
    },
    "apps": {
        "activity": {
            "enabled": "no",
            "installed_version": "2.5.2",
            "types": "filesystem"
        },
        "admin_audit": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "logging"
        },
        "admin_dependencies_chk": {
            "enabled": "no",
            "installed_version": "0.02",
            "ocsid": "166041",
            "types": ""
        },
        "admin_migrate": {
            "enabled": "no",
            "installed_version": "0.1",
            "types": ""
        },
        "backgroundjob": {
            "lastjob": "166813"
        },
        "calendar": {
            "enabled": "no",
            "installed_version": "0.4.1\n",
            "types": ""
        },
        "comments": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "logging"
        },
        "configreport": {
            "enabled": "no",
            "installed_version": "0.1.1",
            "types": "filesystem"
        },
        "contacts": {
            "enabled": "no",
            "installed_version": "0.2",
            "types": ""
        },
        "core": {
            "backgroundjobs_mode": "cron",
            "backgroundjobs_step": "queued_tasks",
            "backgroundjobs_task": "OC_Cache_FileGlobal-gc",
            "global_cache_gc_lastrun": "1461431848",
            "incoming_server2server_share_enabled": "no",
            "installedat": "1345803025.5034",
            "lastcron": "1524555918",
            "lastupdateResult": "{\"version\":\"13.0.2.1\",\"versionstring\":\"Nextcloud 13.0.2\",\"url\":\"https:\\\/\\\/download.nextcloud.com\\\/server\\\/releases\\\/nextcloud-13.0.2.zip\",\"web\":\"https:\\\/\\\/docs.nextcloud.com\\\/server\\\/13\\\/admin_manual\\\/maintenance\\\/upgrade.html\",\"autoupdater\":\"1\"}",
            "lastupdatedat": "1527237853",
            "moveavatarsdone": "yes",
            "oc.integritycheck.checker": "[]",
            "outgoing_server2server_share_enabled": "no",
            "previewsCleanedUp": "1",
            "public_caldav": "\/apps\/calendar\/share.php",
            "public_calendar": "\/apps\/calendar\/share.php",
            "public_files": "files_sharing\/public.php",
            "public_gallery": "\/apps\/gallery\/sharing.php",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "remote_ampache": "\/apps\/media\/remote.php",
            "remote_caldav": "dav\/appinfo\/v1\/caldav.php",
            "remote_calendar": "dav\/appinfo\/v1\/caldav.php",
            "remote_carddav": "dav\/appinfo\/v1\/carddav.php",
            "remote_contacts": "dav\/appinfo\/v1\/carddav.php",
            "remote_core.css": "\/core\/minimizer.php",
            "remote_core.js": "\/core\/minimizer.php",
            "remote_dav": "dav\/appinfo\/v2\/remote.php",
            "remote_files": "dav\/appinfo\/v1\/webdav.php",
            "remote_filesync": "files\/appinfo\/filesync.php",
            "remote_webdav": "dav\/appinfo\/v1\/webdav.php",
            "repairlegacystoragesdone": "yes",
            "shareapi_allow_mail_notification": "yes",
            "shareapi_allow_public_notification": "yes",
            "shareapi_default_expire_date": "yes",
            "shareapi_exclude_groups": "no",
            "shareapi_expire_after_n_days": "10",
            "umgmt_send_email": "true",
            "umgmt_show_backend": "true",
            "umgmt_show_email": "true",
            "umgmt_show_last_login": "true",
            "umgmt_show_storage_location": "true",
            "vendor": "nextcloud"
        },
        "dav": {
            "OCA\\DAV\\Migration\\ValueFixInsert_ran": "true",
            "buildCalendarSearchIndex": "yes",
            "enabled": "yes",
            "installed_version": "1.4.6",
            "types": "filesystem"
        },
        "federatedfilesharing": {
            "enabled": "yes",
            "installed_version": "1.3.1",
            "types": ""
        },
        "federation": {
            "autoAddServers": "0",
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "authentication"
        },
        "files": {
            "backgroundwatcher_previous_file": "13466",
            "backgroundwatcher_previous_folder": "20484",
            "cronjob_scan_files": "500",
            "default_quota": "8 GB",
            "enabled": "yes",
            "installed_version": "1.8.0",
            "types": "filesystem"
        },
        "files_archive": {
            "enabled": "no",
            "installed_version": "0.2",
            "types": "filesystem"
        },
        "files_imageviewer": {
            "enabled": "no",
            "installed_version": "1.0",
            "types": ""
        },
        "files_odfviewer": {
            "enabled": "no",
            "installed_version": "0.1",
            "types": ""
        },
        "files_pdfviewer": {
            "enabled": "yes",
            "installed_version": "1.2.1",
            "types": ""
        },
        "files_retention": {
            "enabled": "no",
            "installed_version": "1.0.1",
            "types": "filesystem"
        },
        "files_sharing": {
            "enabled": "yes",
            "incoming_server2server_share_enabled": "yes",
            "installed_version": "1.5.0",
            "outgoing_server2server_share_enabled": "yes",
            "types": "filesystem"
        },
        "files_texteditor": {
            "enabled": "yes",
            "installed_version": "2.5.1",
            "types": ""
        },
        "files_trashbin": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "filesystem"
        },
        "files_versions": {
            "enabled": "yes",
            "installed_version": "1.6.0",
            "types": "filesystem"
        },
        "files_videoplayer": {
            "enabled": "yes",
            "installed_version": "1.2.0",
            "types": ""
        },
        "firstrunwizard": {
            "enabled": "yes",
            "installed_version": "2.2.1",
            "types": "logging"
        },
        "gallery": {
            "enabled": "no",
            "installed_version": "0.5.0\n",
            "types": ""
        },
        "groupfolders": {
            "enabled": "yes",
            "installed_version": "1.2.0",
            "types": "filesystem"
        },
        "keeweb": {
            "enabled": "no",
            "installed_version": "0.4.0",
            "types": ""
        },
        "logreader": {
            "enabled": "yes",
            "installed_version": "2.0.0",
            "levels": "00111",
            "ocsid": "170871",
            "types": ""
        },
        "lookup_server_connector": {
            "enabled": "yes",
            "installed_version": "1.1.0",
            "types": "authentication"
        },
        "media": {
            "enabled": "no",
            "installed_version": "0.4",
            "types": ""
        },
        "nextcloud_announcements": {
            "enabled": "yes",
            "installed_version": "1.2.0",
            "pub_date": "Sat, 10 Dec 2016 00:00:00 +0100",
            "types": "logging"
        },
        "notifications": {
            "enabled": "yes",
            "installed_version": "2.1.2",
            "types": "logging"
        },
        "oauth2": {
            "enabled": "yes",
            "installed_version": "1.1.0",
            "types": "authentication"
        },
        "passman": {
            "enabled": "no",
            "installed_version": "2.1.2",
            "types": ""
        },
        "password_policy": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": ""
        },
        "provisioning_api": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "prevent_group_restriction"
        },
        "serverinfo": {
            "enabled": "[\"admin\"]",
            "installed_version": "1.3.0",
            "types": ""
        },
        "sharebymail": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "filesystem"
        },
        "storagecharts2": {
            "enabled": "no",
            "installed_version": "2.6.0",
            "types": ""
        },
        "survey_client": {
            "enabled": "no",
            "installed_version": "0.1.5",
            "types": ""
        },
        "systemtags": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "logging"
        },
        "templateeditor": {
            "enabled": "no",
            "installed_version": "0.2",
            "types": ""
        },
        "theming": {
            "backgroundMime": "image\/jpeg",
            "cachebuster": "23",
            "color": "#E2002A",
            "enabled": "yes",
            "installed_version": "1.4.1",
            "logoMime": "image\/svg+xml",
            "name": "",
            "slogan": "",
            "types": "logging",
            "url": ""
        },
        "twofactor_backupcodes": {
            "enabled": "yes",
            "installed_version": "1.2.3",
            "types": ""
        },
        "updater": {
            "enabled": "no",
            "installed_version": "0.6",
            "types": ""
        },
        "user_migrate": {
            "enabled": "no",
            "installed_version": "0.1",
            "types": ""
        },
        "workflowengine": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": "filesystem"
        }
    }
}

Are you using external storage, if yes which one: local/smb/sftp/...
no
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no

1. to develop enhancement users and groups
Source
picture samweisgamdschie

Most helpful comment

Works for me with the new user management code in 14. Closing.

@skjnldsv Please reopen if there are still some flaws and specify what does not work. ;)

picture MorrisJobke on 25 Jun 2018
👍2 🎉1

All 5 comments

Only username is queried.

We also query the display name: #7169 Could you check this again?

MorrisJobke picture MorrisJobke on 25 May 2018

@skjnldsv is this implemented in the new user management? #8824

MorrisJobke picture MorrisJobke on 31 May 2018

Hi, sorry for the delay. I checked it, you are right, display name is also queried. But it only queries like "^<ignore-case-querystring>.*". In our environment it would be a huge benefit, when it shows ".*<ignore-case-querystring>.*" for display name AND email address too (like it does with username).

samweisgamdschie picture samweisgamdschie on 12 Jun 2018

Works for me with the new user management code in 14. Closing.

@skjnldsv Please reopen if there are still some flaws and specify what does not work. ;)

MorrisJobke picture MorrisJobke on 25 Jun 2018
👍2 🎉1

Many Thanks to you!!!

samweisgamdschie picture samweisgamdschie on 13 Jul 2018
Was this page helpful?
0 / 5 - 0 ratings

Related issues

georgehrke picture georgehrke  路  3Comments
j-ed picture j-ed  路  3Comments
dl5rcw picture dl5rcw  路  3Comments
mama21mama picture mama21mama  路  3Comments
Django-BOfH picture Django-BOfH  路  3Comments