Allow referencing prior macro variable in SQL variable to limit choices
Answered
Right now if you have more than one macro variable, you can not reference one variable's user input for the next variable. I want to be able to reference the users input on variable one to then limit the choices in variable 2 but am unable to do so without errors.
-
Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
(Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
Read more about the Feature Request process here
[Internal Id: 76088] -
Should this not be possible by using the @STORE values (these values persist across macros)... so ask for the input and store it in the @STORE (https://help.boyum-it.com/B1UP/macro-variables.html).
If this is not what you are requesting here, then please give a bit more context on what the scenario is and what you have so far that is giving you errors
-
Hi Rasmus,
No, I'm not requesting that I be able to use them in another macro UF, I'm requesting on the same macro where I have multiple macro variables that I be able to reference the value put in the different variables in the next variable with syntax like $[$BOY_42.0.0] for that specific macro variable field, but it doesn't work.
Here is an example:
Macro:
@STORE1 = '[%0]';
@STORE2 = '[%1];
Macro Variables SQL:
[%0] = SQL - SELECT T0.CardCode, T0.CardName from OCRD T0
[%1] = SQL - SELECT T0.Address FROM CRD1 T0 WHERE T0.CardCode = $[$BOY_42.0.0]
I need the second variable to reference the first to limit my SQL list for the second variable, but you can't use the syntax on the macro variable form in the SQL. It throws an error instead.
I also can't do this in 2 macros and use the @STORE1 in the Macro variable SQL of the second. It doesn't recognize that either.
-
Hmm, not 100% sure I totally follow what you try to do here, but it is a limitation that all [%x] variables need to be given up-front...
The only way I could see something perhaps working (again might have misunderstood) would be to ask for various over two Macroes then and chain them
Macro 1 (UF-001):
// Collect first set of values [%0], [%1], etc..
//Do Stuff
UF(UF-002); //Call Macro 2Macro 2 (UF-002):
// Collect second set of values [%0], [%1], etc..
//Do Stuff -
Hi Rasmus,
But you can't use STORE value in the UF-002 Macro Variable SQL. It doesn't work. And that is my problem. As a work around what I had to do was take Macro 1s user input value and place in a field, and then in Macro 2 reference that field as the syntax in my macro variable SQL statement. That is not ideal. I'd rather be able to reference it in one macro variable form popup instead of having to have multiple pop up windows that the user has to go through. Not efficient. And again...the store value doesn't work.
Please sign in to leave a comment.
Comments
5 comments