Troubleshooting
Last updated
Last updated
Have trouble getting your reactive query formula to work correctly? Here's a breakdown of how to troubleshoot and achieve the desired results:
Before conducting direct SOQL testing, use a Display Text element in your flow to reveal the exact value your formula produces. This will provide a crucial visual check.
Ask yourself: "Does this output make sense as something that could go after the WHERE clause in a SOQL query?"
For example, if your Display Text shows something like 'Name = 'John Doe' AND Account.Industry = 'Technology', you're on the right track! If it shows something jumbled or nonsensical, you'll need to revisit your formula.
This "sneak peek" helps you catch potential issues early on.
The most reliable way to validate your formula is to test it directly within a SOQL query. Think of your formula as the part that comes after the WHERE clause in a SOQL query (like the highlighted portion in the example below).
Success! If your SOQL query returns the expected results, congratulations! Your formula is likely correct.
Error? If Salesforce throws an error message, it means there's something wrong with the syntax or structure of your query. Carefully review your formula for any mistakes.
Let's say your formula looks like this:
To use this in a SOQL query, you'd modify it to:
SQL
Use code with caution.
If your SOQL query with the modified formula throws an error, your original formula might have a syntax issue.
Ensure the values you use in your test SOQL query are valid and exist in your Salesforce org.
By following these steps, you can effectively pinpoint and resolve issues with your reactive query formulas.
If your SOQL query works fine and the Display Text output looks correct, but your Avonni component filters still don't behave as expected, a more nuanced issue might be at play. In this case, please don't hesitate to contact our support team for assistance. We're here to help!
