47
edits
(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 | |||
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 | |||
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. |
edits