How do I retrieve all db records for user bill.clinton from the 'UserProfile' collection. I have the current user '_id' saved into the 'myID' LSV.
The UserProfile collection has the following records:
first_name, last_name, dob, ssnumber, phone_number. etc
I have a page with input fields for all of the records named: 'UpdatePage'
on page load, the list service or query service runs and it display the last row on the collection; not the actual record for the currently login user: bill.clinton. It does show the bill.clinton _id, but it shows the last user in the collection, e.g. bruce.lee's data.
How can I fix this so the query service actually show the data for the current user?
Mike