Sample for Candidate Presentation: Difference between revisions

Finished first section
(Added soql filtering section)
 
(Finished first section)
Line 5: Line 5:
3B Documents allows you to filter child repeatable sections by adding an SOQL query to the chosen section.
3B Documents allows you to filter child repeatable sections by adding an SOQL query to the chosen section.


 
==== Creating SOQL Filter ====
To do this, first click on the repeatable section within the document. This will show the SOQL input at the bottom:
To do this, first click on the repeatable section within the document. This will show the SOQL input at the bottom:
[[File:Screenshot 2023-12-06 at 11.53.08.png|left|thumb|642x642px|SOQL Query Input]]
[[File:Screenshot 2023-12-06 at 11.53.08.png|left|thumb|642x642px|SOQL Query Input]]
Line 21: Line 21:
</syntaxhighlight>''Choose a suitable name for the filter (something related to the repeatable section)''
</syntaxhighlight>''Choose a suitable name for the filter (something related to the repeatable section)''


 
The final query should look similar to this:<syntaxhighlight>
The final query should like similar to this:<syntaxhighlight>
Id IN ({params.education-filter})
Id IN ({params.education-filter})
</syntaxhighlight>
</syntaxhighlight>
Line 35: Line 34:




On the generated document, the repeatable section will only show records that have Id's contained within the Id's supplied via the URL parameters.
 
Make sure to click the save icon next the query input, and also save the document.
 
==== Adding URL Parameters Manually ====
 
 
The filter described above can be added to a document url manually like this:<syntaxhighlight>
&education-filter='123exampleId','456exampleId'
</syntaxhighlight>
 
 
This will result in the custom SOQL query looking like this:<syntaxhighlight>
Id IN ('123exampleId','456exampleId')
</syntaxhighlight>
 
 
On the generated document, the repeatable section will now only show records that have Id's contained within the custom SOQL query.
47

edits