Searching for a user by the "location" field

[kfirba]

Hey!

We are using the Postgress database driver to store our data.
When we imported all users, we used the "location" field to store the user's id.

What I need now is a way to get nodebb's user id by the "location" field. What I want is to reverse-sync the ids back to our main DB.

I've tried to hunt around the source code, but couldn't find a way to do it. Is there any way I can achieve that?

Thanks!

[JJSagan]

I don't have an answer for you...
However, I did note that you are using PG. To that end, make sure to update the driver:
https://community.nodebb.org/topic/13480/redactor-error-handler-postgresql-error-on-8000-characters-message