René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"UI - SQL error when searching/filtering on accountuser page","articleBody":"\r\n##### ISSUE TYPE\r\n * Bug Report\r\n\r\n##### COMPONENT NAME\r\n~~~\r\nUI\r\n~~~\r\n\r\n##### CLOUDSTACK VERSION\r\nTested on\r\n* 4.17.2.0\r\n* 4.17.0.1\r\n\r\n##### CONFIGURATION\r\nStandard install.\r\n\r\n##### OS / ENVIRONMENT\r\nRocky Linux 8\r\n\r\n##### SUMMARY\r\nI am getting the following error message in the web console when trying to search for a specific user account.\r\n\r\n```\r\nRequest failed. (530)\r\nCaught: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT user_view.id, user_view.uuid, user_view.username, user_view.password, user_view.firstname, user_view.lastname, user_view.email, user_view.state, user_view.api_key, user_view.secret_key, user_view.created, user_view.removed, user_view.timezone, user_view.registration_token, user_view.is_registered, user_view.incorrect_login_attempts, user_view.account_id, user_view.account_uuid, user_view.account_name, user_view.account_type, user_view.account_role_id, user_view.domain_id, user_view.domain_uuid, user_view.domain_name, user_view.domain_path, user_view.job_id, user_view.job_uuid, user_view.job_status, user_view.default, user_view.source FROM user_view WHERE user_view.account_type != 5 AND user_view.id != 1 AND (user_view.username LIKE x'257573657225' OR user_view.firstname LIKE x'257573657225' OR user_view.lastname LIKE x'257573657225' OR user_view.email LIKE x'257573657225' OR user_view.state LIKE x'257573657225' OR user_view.account_name LIKE x'257573657225' OR user_view.account_type LIKE ** NOT SPECIFIED ** ) AND user_view.removed IS NULL ORDER BY user_view.id ASC LIMIT 0, 50\r\n```\r\n\r\nThe page I am trying to search on is the `/#/accountuser` page.\r\n\r\n\r\n##### STEPS TO REPRODUCE\r\n1. Log in to CloudStack UI\r\n2. Click on 'Accounts'\r\n3. Click on any account\r\n4. Click on 'View Users'\r\n5. On the user list page (i.e. the /#/accountuser page, eg. https://cloudstack.example.com/client/#/accountuser), use the search box at the top right of the user table.\r\n6. The 'Request failed' error appears.\r\n\r\n##### EXPECTED RESULTS\r\nThe user table should be filtered by the search.\r\n\r\n##### ACTUAL RESULTS\r\nA '500 Internal Server Error.' page is displayed.\r\n","author":{"url":"https://github.com/kohrar","@type":"Person","name":"kohrar"},"datePublished":"2023-02-02T22:16:22.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/7165/cloudstack/issues/7165"}