Slate Instance | TUV |
Requestor | Rebecca Russo |
TTS Staff | Helen Williams |
1/9/2024 | |
Status | PENDING REPLY |
Summary Description | When testing out the interview scheduling form using their test account, Rebecca was getting a message that said she was eligible to register for a timeslot. |
Event template: https://vet.admissions.tufts.edu/manage/event/form?id=1d03fa12-e9d9-46a4-b9d1-9252b38ad9df
There are conditions added to the event registration form within the event teplate. The filters for that logic are:
Rebecca was using her test account (173539353) which had three application records. I wondered if the way the filters are currently set up were targeting only the Rank 1 application, so I ran a query to look at how her test applications were ranked:
The DVM First Year Student app was actually Rank 3. My suspicion is that the way the filters are currently applied, it is creating one to one joins and by default pulling back the Rank 1 application, which is not always going to be in the correct bin. So I needed the filter to account for all applications, not just the Rank 1 app.
So I went back to the access conditions on the form and updated the filter to join to Application (renamed Interview Application) then joined that to Person. Then I did a subquery join from Person > Applications (one to many) and a join to Workflow Records: Applications, and the filter for the bin:
I created my own test account and added three different applications, and even though I added the DVM First Year application first, once I added two more I was back to seeing DVM First Year application as Rank 3.
I tested my own access to the form using an incognito browser and my new test credentials, and first tried with just the one DVM First Year application without changing the filters, and I was able to get in. Then I added two more applications to my account, updated the filters, and was still able to get in.
I contacted Rebecca and asked her to try again and am currently awaiting her response.
0 Comments