Enabling RegExp as a valid condition

[loopbackio]

Enabling RegExp as a valid condition

[ssh24]

You can use like/nlike/ilike/nilike to query regular expressions. More info on pattern matching in postgres.

Here is a sample code snippet:

model-definition.json

{
  "name": "Post",
  "base": "PersistedModel",
  "idInjection": true,
  "options": {
    "validateUpsert": true
  },
  "properties": {
    "title": {
      "type": "string"
    }
  },
  "validations": [],
  "relations": {},
  "acls": [],
  "methods": {}
}

boot-script.js

'use strict';
var util = require('util');
var _ = require('lodash');

module.exports = function(app) {
    var db = app.datasources.postgresqlDs;
    var Post = app.models.Post;

    db.automigrate(function(err) {
        if (err) throw err;
        console.log('\nAutomigrate completed');

        Post.create([{
            title: 'Hello World'
        }, {
            title: 'hello world'
        }, {
            title: 'My Post'
        }, {
            title: 'my post'
        }], function(err, result) {
            if (err) throw err;
            console.log('\nCreated instance: ' + util.inspect(result));

            Post.find({where: {title: {like: 'h%'}}}, function(err, result) {
                console.log('\nFound instance with `like`: ' +  util.inspect(result));

                Post.find({where: {title: {nlike: 'M%'}}}, function(err, result) {
                    console.log('\nFound instance with `like`: ' +  util.inspect(result));
                });
            });
        });
    });
};

output

sakibs-mac:postgresql-90 ssh$ node .
Web server listening at: http://0.0.0.0:3000
Browse your REST API at http://0.0.0.0:3000/explorer

Automigrate completed

Created instance: [ { title: 'Hello World', id: 1 },
  { title: 'hello world', id: 2 },
  { title: 'My Post', id: 3 },
  { title: 'my post', id: 4 } ]

Found instance with `like`: [ { title: 'hello world', id: 2 } ]

Found instance with `like`: [ { title: 'Hello World', id: 1 },
  { title: 'hello world', id: 2 },
  { title: 'my post', id: 4 } ]

Hopefully this answers your question. Closing this issue as resolved. Feel free to reopen if needed.