Feature Request: RANDOMFROMQUERY

[brandon-toner]

Idea: Like RANDOMBLOCKMENTION, but for a more specific query.

Why I want this:

• To return "random idea (#I) related to {area}", or "random question (#Q) related to {area}"

I'm also interested if you know of another way to accomplish the same result.

Thanks!

[dvargas92495]

With Query Builder extension, you could define a query and specify random settings.

The <%QUERYBUILDER%> command then returns whatever is configured, but I sense once you have it set up on Query Builder itself, it will be sufficient.

[brandon-toner]

Great — I'll check that out!

[brandon-toner]

OK I figured out the query logic... could I use the Smartblock command to trigger the random output on this query and place the block reference when the command was triggered?

Desired workflow:

• Place cursor on DNP
• "jj Random Pharmacy Idea" to trigger SB Workflow
• random query result is block referenced on the page

[dvargas92495]

yea, if you give this query builder instance an alias on the top right (e.g. Pharmacies), then you should be able to do:

<%QUERYBUILDER:Pharmacies%>

[brandon-toner]

Wowwwww. Ok awesome! This is great.