Hmmm, cant see why filter would effect it, what are you filtering to?
Because I only wnat to display those tags when you click in HALF Order Tag Button
Otherwise (and as defualt) Half pizzas are not shown…
Thanks!!!
G.
Arr, I see, cause your not using a 50/50 half half product.
Hmmmm.
I would suggest dropping some ask question actions in there to see where its failing.
Ie, its not reading the tag value or something else.
Guessing you double checked that without the filter it worked ok for you?
yes, but I also have not defined that as a filter or anywhere else…
I am using my previous TAG (METADE)… I I take out the filter it works great!!!
Thanks!!!
G.
And when you add a half tag what does the show message show?
If you have a filter defined it displays 0
- and the correct order price
if you dont have a filter defined it displays the correct tag price
- the correct order price
Thanks!!!
G.
Stop staying thanks every time LOL
No need hehe
Am strugling to replicate, where is METADE coming from? what is it, thought it was tag category but isnt…
Got it, sorry, prefix
This looks like a bug with prefix on order tag.
Although saying that Im sure I saw this mentioned before actually.
Makes sence kinda as prefix would be used for say, no, extra, instead of and so on which values dont really work for.
Would tag category work for you?
And define the format as Half: {0}
so it still prefixes the tag with Half or METADE: in your case?
OR have a half half portion on the pizza and map the half half tags only to that portion?
I would have to change ALL my flows, since this works great and it is really simple!!!
Thanks!!!
G.
Tag Category was I believe added for this scenario so would probably be better suited…
Hmmmmm…
Maybe we can bypass the blank prefixed tag price by getting the tag value directly via SQL
Give me a min to look at database and how tags are stored…
Ok, am going to write on the fly so might not work first time…
Can you drop [:OrderTagName] in your show message and let me know whether it returns just the tag or the prefix and tag?
GREAT IDEA!!! did not think about that!!!
just a minute
G. (without thanks LOL!!!)
You can say thanks on that one for the great idea
Hoping it returns just the tag name without prefix but got suspicion it will include prefix but can overcome that.
So for my sample SQL would be along the lines of;
SELECT [Price]
FROM [OrderTags]
WHERE [Name] = 'American' and [Filter] = '50/50'
Obviously these values are fixed but heading in right direction
Sorry, it should be [:OrderTagValue]
My bad, that is the tag name, we want tag value
If it just returns the half topping tag name this script should do it;
function filteredHalfPizzaTagPrice(halfTagName) {
var qry = "SELECT [Price] FROM [OrderTags] WHERE [Name] = '"+halfTagName+"' and [Filter] = 'Mitade'";
var tagPrice = sql.Query(qry).First;
return tagPrice
}
No, I gave the wrong [:], not just you, its neither of us knowing what we are doing LOL