Answers.Body: <p>Do you have <a href="https://github.com/civicrm/cv" rel="nofollow noreferrer">cv</a> installed? You can do</p>
  <p><code>cv ev  '\Civi::settings()-&gt;set(&quot;quicksearch_options&quot;, array (  0 =&gt; &quot;sort_name&quot;,  1 =&gt; &quot;contact_id&quot;,  2 =&gt; &quot;external_identifier&quot;,  3 =&gt; &quot;first_name&quot;,  4 =&gt; &quot;last_name&quot;,  5 =&gt; &quot;email&quot;,  6 =&gt; &quot;phone_numeric&quot;,  7 =&gt; &quot;street_address&quot;,  8 =&gt; &quot;city&quot;,  9 =&gt; &quot;postal_code&quot;,  10 =&gt; &quot;job_title&quot;));'</code></p>
  <p>Alternatively if you have database access you can do</p>
  <p><code>UPDATE civicrm_setting set value='a:11:{i:0;s:9:&quot;sort_name&quot;;i:1;s:10:&quot;contact_id&quot;;i:2;s:19:&quot;external_identifier&quot;;i:3;s:10:&quot;first_name&quot;;i:4;s:9:&quot;last_name&quot;;i:5;s:5:&quot;email&quot;;i:6;s:13:&quot;phone_numeric&quot;;i:7;s:14:&quot;street_address&quot;;i:8;s:4:&quot;city&quot;;i:9;s:11:&quot;postal_code&quot;;i:10;s:9:&quot;job_title&quot;;}' where name='quicksearch_options';</code></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-03T02:51:08.580Z
Answers.Text: I understand cv runs on your local environment or a secure shell on remote server. this is hosted at PANTHEON and there is no shell access. I have drush available .. the SQL will help! THANKS
Answers.UserDisplayName: Eldon Leeburstroghm Allison II
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-02T23:25:50.400Z
Answers.LastActivityDate: 2022-12-02T23:25:50.400Z
Answers.UserDisplayName: Demerit
Body: <p>In Refrence to my <a href="https://civicrm.stackexchange.com/q/43060/14046">related issue</a> how do I re-write the default preferences back to what they were when first CiviCRM was installed? Admin screen no longer accessible after search preferences changes..</p>
  <p>Drupal 9, PHP 8, CiviCRM 5.55.2</p>
  
Tags: <drupal-9><php8>
Title: Way to reset search preferences, display preferences when admin page inaccessible?
ThreadText: # Way to reset search preferences, display preferences when admin page inaccessible?
  
  (Asked by: username_0 on 2022-12-02)
  
  In Refrence to my [related issue](https://civicrm.stackexchange.com/q/43060/14046) how do I re-write the default preferences back to what they were when first CiviCRM was installed? Admin screen no longer accessible after search preferences changes..
  
  Drupal 9, PHP 8, CiviCRM 5.55.2
  
  **Tags:** drupal-9, php8
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-12-02. Score: 1 | Accepted answer
  
  Do you have [cv](https://github.com/civicrm/cv) installed? You can do
  
  `cv ev '\Civi::settings()->set("quicksearch_options", array ( 0 => "sort_name", 1 => "contact_id", 2 => "external_identifier", 3 => "first_name", 4 => "last_name", 5 => "email", 6 => "phone_numeric", 7 => "street_address", 8 => "city", 9 => "postal_code", 10 => "job_title"));'`
  
  Alternatively if you have database access you can do
  
  `UPDATE civicrm_setting set value='a:11:{i:0;s:9:"sort_name";i:1;s:10:"contact_id";i:2;s:19:"external_identifier";i:3;s:10:"first_name";i:4;s:9:"last_name";i:5;s:5:"email";i:6;s:13:"phone_numeric";i:7;s:14:"street_address";i:8;s:4:"city";i:9;s:11:"postal_code";i:10;s:9:"job_title";}' where name='quicksearch_options';`
  
  > **Comments:**
  > **username_0**: I understand cv runs on your local environment or a secure shell on remote server. this is hosted at PANTHEON and there is no shell access. I have drush available .. the SQL will help! THANKS  
  
  ---
  
  