Page Comparison

At the end of every Challenge, we aim to collect writeups from all participating users/teams, in which they will provide information about their submission(s). Currently, writeups are collected as Synapse Projects (sample template here), and we ask the participants to include information such as their methodologies, external data sources (if any), and source code and/or Docker images. Typically, writeups are *required* in every Challenge, in order to be considered for “top performer” eligibility and other incentives, including byline authorship.

...

Once you are satisfied that the writeup workflow is to your expectations, remember to open the queue to the Challenge participants!

You can do so by updating its Sharing Settings so that the Participants team has Can submit permissions.

...

SELECT 
  s.id AS id, 
  s.createdOn AS createdOn, 
  s.submitterid AS submitterid, 
  s.status AS status, 
  (score columns),
  w.entityid AS writeup, 
  w.archived AS archived_writeup 
FROM syn123 s 
  JOIN syn456 w
  ON (s.submitterid = w.submitterid)
WHERE s.status = 'ACCEPTED'
  AND w.status = 'ACCEPTED'

This query will join the SubmissionView for submissions (s) with the SubmissionView for writeups (w), using the submitterids from both Views as the index. Rows are filtered to only include valid submissions from both Views (*.status = 'ACCEPTED') – this clause is optional and can be removed if desired.

...