Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Advertisement Create a free account

Has the format changed for nesting Roll Queries?

1637758062
Chris D.
Pro
Sheet Author
API Scripter
I had a query that I wanted to make into a nested query. (bad idea) I had this in my html in a button statement.                        value="!Earthdawn~ charID: @{character_id}~ ?{What Function|Attune,TuneMatrix: Spell: @{SP_RowID}|Create a pseudo matrix & Attune,TuneMatrix: Share: @{SP_RowID}}" Which asks a dropdown with two options, Attune and Create a pseudo matrix and Attune. It worked fine.  Now I thought that all I had to do (and all the documentation I can find still says to do this) was add a 2nd query and then replace all the } | and "," with the html replacements.                          value="!Earthdawn~ charID: @{character_id}~ ?{What Function|Attune,TuneMatrix: Spell|Create a pseudo matrix & Attune,TuneMatrix: Share: ?{whatever|Standard,Std|Enhanced,Enh}}: @{SP_RowID}" However it did not work and I kept getting all the 2nd queries options added to the first with other errors. Finally I found that what works is to also escape all the & so that it looks like as follows.                          value="!Earthdawn~ charID: @{character_id}~ ?{What Function|Attune,TuneMatrix: Spell|Create a pseudo matrix & Attune,TuneMatrix: Share: ?{whatever|Standard,Std|Enhanced,Enh}}: @{SP_RowID}" I guess this is not so much of a question as a WTF!  Did this change? When? Why is the documentation still saying the old way.  Or is it just me?
1637777444
Andreas J.
Forum Champion
Sheet Author
Translator
It should still be on dev for testing. Have you tried your sheet on Dev server and seen if it behaves differently?
1637780010
Chris D.
Pro
Sheet Author
API Scripter
Sorry, I have no idea what you mean  by "it" should still be on dev for testing.  In any case, I did my original testing on the custom sheet sandbox of the production server. I just tried in on the dev server and it behaves the exact same. 
1637789683
GiGs
Pro
Sheet Author
API Scripter
I havent following how nested queries work in character sheets, but I remember there was an issue that roll20 was applying an extra level of parsing, so html entities needed to be nested twice.
1637794054

Edited 1637794087
Andreas J.
Forum Champion
Sheet Author
Translator
Chris D. said: Sorry, I have no idea what you mean&nbsp; by "it" should still be on dev for testing. You where talking about changes to nested queries, and I was, too, talking about nested queries: <a href="https://app.roll20.net/forum/post/10260308/now-on-dev-server-roll-query-improvements" rel="nofollow">https://app.roll20.net/forum/post/10260308/now-on-dev-server-roll-query-improvements</a>
1637865577
Chris D.
Pro
Sheet Author
API Scripter
Oh, yes! Thanks!&nbsp; &nbsp;I forgot that had whole episode happened! The test and the revert. Or rather I had some vague memory something happened but not what, and I only searched back the release notes 2 or 3 months, not 4.&nbsp; In any case, on both the production and dev sandboxes the line (as part of an html button statement) value="!Stuff ?{What Function|Attune,TuneMatrix: Spell|Create a pseudo matrix Attune,TuneMatrix: Share: ?{whatever|Standard,Std|Enhanced,Enh|Armored,Arm|Shared,Sha}}: @{SP_RowID}" produces a dropdown like&nbsp; Which is to say the queries do not nest, they are all part of one big query.&nbsp; The exact same thing happens if I only encode it to what used to be expected (change ","&nbsp; "}" and "|" to &amp;#44; etc.)&nbsp; It now seems to need an additional level of encryption to&nbsp; &amp;amp;#44; In order to get it to work (where the last 4 options are only a subquery to the Create option), on both the Production and Dev sandboxes I need to use the following. value="!Stuff ?{What Function|Attune,TuneMatrix: Spell|Create a pseudo matrix Attune,TuneMatrix: Share: ?{whatever&amp;amp;#124;Standard&amp;amp;#44;Std&amp;amp;#124;Enhanced&amp;amp;#44;Enh&amp;amp;#124;Armored&amp;amp;#44;Arm&amp;amp;#124;Shared&amp;amp;#44;Sha&amp;amp;rbrace;}: @{SP_RowID}" Which seems to be more / different encryption than before.&nbsp;
1637874975

Edited 1637874997
vÍnce
Pro
Sheet Author
This was brought up previously... <a href="https://app.roll20.net/forum/permalink/10071671/" rel="nofollow">https://app.roll20.net/forum/permalink/10071671/</a> and the Devs were supposed to be working it out. (ie the macro release and rollback)&nbsp; I think we're still waiting on a solution.
1637877158

Edited 1637877264
Andreas J.
Forum Champion
Sheet Author
Translator
and I only searched back the release notes 2 or 3 months, not 4. Some time ago I started a changelog for sheet stuff, half of the time changes aren't mentioned in the changelog or release notes. <a href="https://wiki.roll20.net/BCS/Updates" rel="nofollow">https://wiki.roll20.net/BCS/Updates</a> Oh yeah and what Vince pointed out was something listed on <a href="https://wiki.roll20.net/BCS/Bugs#CSE" rel="nofollow">https://wiki.roll20.net/BCS/Bugs#CSE</a>