1 likeA couple of things could be the issue: - SQL queries are case sensitive whereas native FM finds are not case sensitive. So if the _id_assigment is not numeric that can cause a discrepancy. - if you use PSoS to do the query but the user has not committed the record yet then server does not know about it and will return the results minus the user's record. So always do a commit before the SQL query.
1 likeHave you considered it might be your data that's the issue? Or the $_id_assignment variable? I'd recommend simplifying the query so you can run some tests in the data viewer and/or in a test script. In said script, I'd create the query in a variable (e.g., $query) so I can see it in the data viewer.
This leaderboard is set to Los Angeles/GMT-07:00