How to use raw where clause

[pramodlk]

I'm trying to figure out how to use raw where clause in feathers-sequelize

eg:
where TIME_TO_SEC(timediff(NOW(), last_viewed_at)) <=10

Sequelize seems like support for that (sequelize/sequelize#9410 (comment))

{where: Sequelize.literal('your special where clause here') }

How can we use this in feathers-sequelize ?

Thanks

[daffl]

This is what params.sequelize is intended to be used for.

[pramodlk]

@daffl Yes, I'm using params.sequelize. Below is my code block. I'm struggling to find a way to place raw where condition in this line where: { 'RAW WHERE CLAUSE HERE'},

app.service('tickets').hooks({
  before: {
    find(context) {
      const sequelizeClient = context.app.get('sequelizeClient');
      const { Message, TicketView, TicketStatus, User } = sequelizeClient.models;
      var userId = context.params.query.userId;

      context.params.sequelize = {
	   raw: false, 
	   include: [
	         	 { 
	       		  model: TicketView , 
	       		  as: 'viewedBy', 
	       		  where: {user_id: { $not:  userId } },
	       		  include: [
	        			 { 
	       				  model: User, 
	       				  as: 'user'
	        			 }
		        	] 
		          },
		          { 
		          model: TicketStatus , 
		          as: 'lastResolvedStatus', 
	       		  where: { 'RAW WHERE CLAUSE HERE'},
		          include: [
	               	                { 
				          model: User, 
				          as: 'user'
				         }
		                  ] 
		          },
		]
		};
	}
	}
  });

[daffl]

What exactly is the problem then? Has you tried testing the query in isolation?

[pramodlk]

Finally i was able to get that working. Thanks. I'm posting the working code, it might help someone having same problem

const Sequelize = require('sequelize');
...
...
...

app.service('tickets').hooks({
  before: {
    find(context) {
      const sequelizeClient = context.app.get('sequelizeClient');
      const { Message, TicketView, TicketStatus, User } = sequelizeClient.models;
      var userId = context.params.query.userId;

      context.params.sequelize = {
	   raw: false, 
	   include: [
	          { 
	       	  model: TicketView , 
	       	  as: 'viewedBy', 
	       	  where: {user_id: { $not:  userId } },
	       	  include: [
	        		 { 
	       			  model: User, 
	       			  as: 'user'
	        		 }
		       	] 
		       },
		      { 
		  model: TicketStatus , 
		  as: 'lastResolvedStatus', 
	       	  where: Sequelize.literal('TIME_TO_SEC(timediff(NOW(), last_viewed_at)) <=10'),
		  include: [
	          	 { 
			  model: User, 
			  as: 'user'
			  }
		          ] 
		          },
		]
		};
	}
	}
  });