Filtering Data Project

  • Resolved hporter18

    (@hporter18)


    2 years, 4 months ago

    Hi,

    I am using WP Data Access to create a web app to manage a Minor Hockey League. 

    I have a division table that stores the different divisions in the league (ie u13, u15, u17, etc).  I have one manager responsible for entering information for each division (creating teams, rosters, scoresheets, etc) , this association is stored in a DivisionManager table with a divisionID and a UserID (ID from wp-users table). The division manager should only be able to see data for their division.

    I am using a WP Data Access Project for the CRUD page for the Teams table.  So when the logged in user is a Division Manager for u15 (for example), I want the Teams page to load the list of all the teams for the U15 division on page load.  The divisionID is a foreign Key in the teams table.  Also, when entering a new team, I want the division lookup to only populate with U15. I am using a view for the form, but need to dynamically pass the divisionID somehow so that the correct data is loaded.

    How can this be accomplished with WP Data Access?

Viewing 1 replies (of 1 total)
  • Thread Starter hporter18

    (@hporter18)

    2 years, 4 months ago

    Was able to get it working using URL parameters and wpdadiehard , was using wpdadataproject initially. I suspect I’ll get the select lists working using your documentation on Dynamic conditional lookups.

Viewing 1 replies (of 1 total)

The topic ‘Filtering Data Project’ is closed to new replies.