How to replace a SOQL query with a string?

Question

Any idea how to convert a query into a string?

P.S. no need to copy the list, just query and return, e.g. return (List<AggregateResult>)Database.query(query); — sfdcfox, Jan 20, 2022 at 15:34
Why did you remove most of your question? The idea of this site is that others can find your question and learn from it. Removing most of your question makes that impossible — Kasper, Jan 23, 2022 at 2:40

user1067017 · Accepted Answer · 2022-01-20 15:39:43Z

5

Instead of for (List<AggregateResult> agg: query) you should have for (List<AggregateResult> agg: Database.query(query)).

You can find additional detail regarding Dynamic SOQL here.

Best regards!

answered Jan 20, 2022 at 15:30

user1067017

9397 silver badges21 bronze badges

Add a comment |

1 Answer 1