You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We are using numtel:mysql in my project. We have created a publication named searchResults. My issue is as follows:
The searchResults liveDb publication currently returns:
return liveDb.select(sqlQuery, [{table: 'pages_metrics'}, {table: 'pages'}, {table: 'domains'}] );
This means that the subscription is updated every time there is any change in any of those tables.
Instead, we only want it to update when a row in the pages_metrics table matching keywordId is updated or inserted. I didn't find anything regarding this. I have tried like this:
We are using numtel:mysql in my project. We have created a publication named searchResults. My issue is as follows:
The searchResults liveDb publication currently returns:
return liveDb.select(sqlQuery, [{table: 'pages_metrics'}, {table: 'pages'}, {table: 'domains'}] );
This means that the subscription is updated every time there is any change in any of those tables.
Instead, we only want it to update when a row in the pages_metrics table matching keywordId is updated or inserted. I didn't find anything regarding this. I have tried like this:
But still the issue is same.
How we are going to achieve this?
The text was updated successfully, but these errors were encountered: