使用MongoDB展示数据问题：用户个人提交内容无法正常显示

Hey Darrell, I’ve run into similar issues before—let’s walk through the key details you can share to pinpoint why the user’s items are showing up as an empty array when viewing their submissions individually.

Here’s what would help debug this:

• Backend query logic for user-specific items
  Share the code (SQL query, ORM call, etc.) that fetches items linked to a specific user. For example, are you filtering items using the correct user ID field? Maybe the query is accidentally using user_name instead of user_id, or there’s a typo in the WHERE clause. Also check if there’s any extra filtering (like status = 'approved') that might exclude items visible in the general list.

• Frontend API request details
  Show the full request your frontend sends when loading a user’s submissions—include the URL, query parameters (or request body), and the exact response from the backend. You can grab this from your browser’s DevTools > Network tab. For example: Did you pass the correct user ID in the request? Is the backend returning an empty array even when you expect data, or is the frontend mishandling the response?

• Frontend data handling code
  Share how you’re processing the API response. For instance, are you storing the items in the right state variable? Maybe you’re accidentally overwriting the items array with an empty value after fetching, or the component is trying to render data before the API call completes (though you mentioned console.log shows user data, so this is less likely—but worth checking).

• Database schema relationships
  Confirm the link between your users and items tables. Does the items table have a valid foreign key pointing to the users table’s primary key? Are there any orphaned items (items with a user ID that doesn’t exist in the users table) that might be excluded?

• Comparison with the working general list
  How does the query for the general item list differ from the user-specific one? The general list works, so comparing the two can highlight missing conditions or incorrect parameters in the user-specific query.

Once you share these details, it’ll be much easier to spot where the breakdown is happening!

内容的提问来源于stack exchange，提问作者Darrell