title: How can I use the Find method to perform a case insensitive search on the database field?
body: <p>I am unable to get the case insensitive search from the database using <em>Sails.js V1.0</em> + <em>Waterline ORM</em>. I am using <em>sails-postgresql</em> adapter. The running environment is <em>Heroku</em> + <em>Heroku PostgreSQL</em>.</p>
  
  <p>Is there any way to turn off the following setting in database adapter - <em>For performance reasons, case-sensitivity of contains depends on the database adapter.</em></p>
  
  <p><strong>Tried the method:</strong></p>
  
  <p>Datastore configuration is:</p>
  
  <pre><code>default: {
    adapter: 'sails-postgresql',
    url: 'postgres://....',
    ssl: true,
    wlNext: {
      caseSensitive: true
    }
  }
  </code></pre>
  
  <p>The code block is:</p>
  
  <pre><code>var meetings = await Meeting.find({
    select: ['id', 'uid', 'name', 'deleted', 'complete'],
    where: {
      owner: user.id,
      name: { contains: searchJson.name } : ""
    },
    skip: (inputs.page &gt; 0) ? (inputs.page) : 0,
    limit: (inputs.limit &gt; 0) ? (inputs.limit) : 10,
    sort: 'date DESC'
  });
  </code></pre>