Pricing of Pizza Half and Half

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.

1 Like

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.

1 Like

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 :stuck_out_tongue:
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 :wink:

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?

THANKS!!!
THANKS!!!
THANKS!!!
THANKS!!!
THANKS!!!
THANKS!!!

1 Like

I would have to change ALL my flows, since this works great and it is really simple!!!

Thanks!!!

G.

1 Like

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 :wink:

Give me a min to look at database and how tags are stored…

1 Like

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?

1 Like

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 :stuck_out_tongue:

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

well, I think WE may have found a small bug…

I selected “CARNE DE SOL”… :frowning:

Thanks!!!

G.

Sorry, it should be [:OrderTagValue]
My bad, that is the tag name, we want tag value :slight_smile:

you were right… no bug

just me… not knowing what I am doing…

buuuuu

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