Stash
ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6
Back to this add-on's main page
View Other Add-ons From Mark Croxton
Stash Variable in a Query Tag Parameter
Support Request
John de Beer
|
Posted: 05 December 2020 10:48 AM |
|
|
|
Is there a way to use a stash variable as a search parameter with a query tag? Something like:
{exp:stash:set parse_tags=“yes” parse_conditionals=“yes”}
<—Find some user by username.—>
{exp:query sql=“SELECT member_id, group_id FROM exp_members WHERE username = ‘something’ “}
{stash:member_id}{member_id}{/stash:member_id}
{stash:group_id}{group_id}{/stash:group_id}
{/exp:query}
<—Find A Member Group with group_id != {stash:group_id}{group_id}{/stash:group_id}—>
{exp:query sql=“SELECT group_id FROM exp_member_groups WHERE group_id != WHAT? “}
Do stuff
{/exp:query}
{/exp:stash:set}
Any suggestions appfreciated
|
|
|
John de Beer
|
Posted: 05 December 2020 11:02 AM |
# 1
|
|
|
It’s OK Mark - I figured it out, using something like ‘{exp:stash:my_var}’ as the parameter.
|
|
|
John de Beer
|
Posted: 05 December 2020 12:13 PM |
# 2
|
|
|
I was wrong - did not work, even with parse=“inward”. Would appreciate a hint, even of not possible to do this - thanks
|
|
|