1、Configurable Joins:Back to the Future From the Basics to Building User PortalsVinnie RodriguezDynamic Campus IncCory TardieClarkson UniversityGetting Started with Configurable Joins Building Bridges to Easy WinsVinnie RodriguezSlate AnalystDynamic CampusWho Am I?-Worked in Slate for 5 years-Graduate

2、 Online at Jacksonville University-Undergrad at JU-Consulting with Dynamic CampusA Walk Down Memory LaneA quick look at local query basesA Quick Look at Local Query BasesA Quick Look at Local Query BasesProspectsProspects(Include opt-outs)ApplicationsProspects and ApplicantsPersons(remove opt-out ta

3、gged)PersonsApplicationsPersons(Joined to Rank 1 App)But First.Some requisite knowledge for Configurable Joins to make sense.One-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-One

4、Bridging IslandsWhat even is a join anyway?But How?Application AtollBridging IslandsApplication Atoll-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging IslandsYou Are HerePerson IslandApplication Atoll-Major-Start Term-Disciplinary History-Campus-Submission

5、 Status-Fails-Checklist ItemsBridging IslandsYou Are HerePerson IslandApplication Atoll-Name-Email-Birthdate-Sex at Birth-Citizenship-Visa Status-Religion-SSN-Anticipated Major-Coffee Preference-Shirt Size-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging I

6、slandsYou Are HerePerson IslandApplication Atoll-Name-Email-Birthdate-Sex at Birth-Citizenship-Visa Status-Religion-SSN-Anticipated Major-Coffee Preference-Shirt Size-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging IslandsJoin!You Are HerePerson IslandApp

7、lication Atoll-Name-Email-Birthdate-Sex at Birth-Citizenship-Visa Status-Religion-SSN-Anticipated Major-Coffee Preference-Shirt Size-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging IslandsJoin!You Are HereAddress Archipelago-Permanent Address-Permanent Ad

8、dress-Permanent Address-Mailing Address-Mailing AddressPerson IslandApplication Atoll-Name-Email-Birthdate-Sex at Birth-Citizenship-Visa Status-Religion-SSN-Anticipated Major-Coffee Preference-Shirt Size-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging Isl

9、andsJoin!You Are HereJoin!Address Archipelago-Permanent Address-Permanent Address-Permanent Address-Mailing Address-Mailing AddressImportant DistinctionsMaster vs Subquery JoinBase vs Subquery One to One()oWoody to AndyoApplication to PersonoTest to PersonoReference to ApplicationoChecklist to Perso

10、n/School/App One to Many()oAndy to the toysoPerson to ApplicationsoPerson to TestsoApplication to ReferencesoSingular to PluralPracticalApplicationThis is what you came to see,right?Portals!Clarkson University|Slate Summit 2023Faculty Portals with Clarkson30Cory TardieSlate IT AnalystClarkson Univer

11、sitycoryclarkson.edu31Create a portal for facultyAccess to view specific applicationsSearch featureAccess to applicant informationAbility to view specific interaction typesAdd certain interactionsAbility to email directlyMake it easy for the end userLimit what the user can see and doTask32Specific f

12、ields searchablePeopleSoft IDAcademic Plan/MajorCategoryTermRecent Past TermDecisionBinStudent Name ContainsAssignedSearch33Search Results34Application Profile35Email Directly36Text Directly37Interaction Detail38Methods&Views39UserInteractionInteraction DetailList of ApplicationsApplication Profile

13、TabLists of Prompts for SearchDecisionsMajorsPast TermTermBinsUsers-for the Assigned FilterQueries40CJ-User scopedPulling information on the User logged into the portalNo parametersProvided portal identity(u_JID_id=identity)portal identity or it is also:Queries-User41CJ-Interaction scopedPulling lis

14、t of interactionsBase Join to PersonFilter for the ones you want shownPerson parameterAdjusted portal identity(ac_JID_record=person)portal identity or it is also:Queries-Interaction42CJ-Interaction scopedPulling the specific interaction detailBase Join to PersonInteraction parameter Adjusted portal

15、identity(ac_JID_id=interaction)portal identity or it is also:Queries-Interaction Detail43CJ-Application scopedPulling the specific application and personal informationBase Join to PersonInteraction parameter Adjusted portal identity(a_JID_id=application)portal identity or it is also:Queries-Applicat

16、ion Profile Information44Subquery exports-1 to many Decisions ExampleQueries-Subquery Export Example45Additional Joins and filters but here is one example:Queries-Subquery Export Example 246Pulling the specific lists you want to show up in the drop down search optionsNode neededLiquid looping used o

17、n Default View for searchExports-value and idSome for id utilized value again and renamed it idFiltersNo parameters except on the List of Users one for the Assigned filter where I only wanted the Current Users name listedFilterGUID=identityQueries-Prompt List Queries for Search47CJ-Application scope

18、dNode-Liquid Loop on List of Applications ViewPulling the list for the searchParameters-one for each of the different search fieldsExample:Depending on your settings also may need a User oneFilterSearch FiltersAll Others limitingExamplesTest Record Does Not ExistActive PeriodTermsQueries-List of App

19、lications48Queries-Decision Subquery Filter Example49Liquid Looping for Select List Search FiltersText Search FiltersSearch50SearchCory TardieSlate IT AnalystClarkson Universitycoryclarkson.eduThank you!Vinnie RodriguezSlate AnalystDynamic CampusVinnie.R#SlateSummitEmail Text New Team Member Change in Program Name Update verbiageQuery Searching Local or Template Library?Updated code?What Questions Do You Have?What Questions Do You Have?