I have been trying to build a simple project based on the jobposts example.
What I would like to have happen is simply that users can view all of the job posts but only add, edit, and delete their own.
For startes, I only made just a couple of modifications to the default project.
I have added a UserID to the jobsjobs table that is then joined to the Username field in the jobsusers table (Left Outer Join).
On the security tab for the jobsjobs table, under Advanced Security Settings, I select "Users can see other users data; can edit their own data" and I link the Users Table "Username" to the Main Table "UserID".
I then login is a particular user and add a couple of records to the database.
I have the edit and inline edit options enabled for the jobjobs table.
When I go to the jobsjobs_list.php page when logged in as a particular user, I would expect to see all of the job postings, but only see the edit and inline edit capability show up for the ones that I own as the current user. But, it does not work this way. Instead, I don't any edit or inline edit links available for any of the records, only the view link. Also, if I select a particular record with the square checkbox field and click on the "edit selected" link above the jobposts listing, nothing happens regardless of whether I own the record or not.
Is this how it is supposed to work? I would hope that the edit (and inline edit) would be enabled for the records belonging to the current user. Is this a bug? I do notice that if I change the Advanced security setting to either of the other two modes "Users can see and edit other users data" or "Users can see and edit their own data data only", then the screen will display with the edit links enabled, but this is not the behavior that I want because I don't want a user to be able to edit other postings that aren't his/hers and I don't want to restrict the view list to only his records. (I know that I can create an additional customview that only shows the logged in users own records for clean up purposes).
I noticed the type of behavior that I desire does seem to be somewhat demonstrated in the Classified example, but I'm not sure if this is only because custom code is making it work that way as opposed to the default Security Settings dialog.
The example jobposts application is about 80% of the way there for the application that I want to create, but just trying to add a few of the additional security requirements has been proving a bit difficult.
I look forward to some assistance on the above security questions.
Thanks.
