The following query returns the prices of an item with ALL the different price definitions, however I only want it to display the “main” price and not any of the other definitions
I assume the bit ive highlighted in red is what is causing the output to display ALL price definitions, what do i need to change ALL to to only display a certain price definition and not all of them
The output currently looks like this, all the ones with £1.00 next to them are a second price definition, i just want to display the other prices
Ive managed to work through and combine the SQL id help with previously and some GQL that @QMcKay helped with and I can now bring up a product information box with product name, price and Stock Level, without the need to create a new ticket and add a product
What i need help with now is:
Adding the portions with price (from the script above by changing the .All to whatever it is to display just the one price definition)
Q mentioned in another post that by using GQL we can bring up the values if the product custom tags, if you could show me how to do that for one custom tag ill be able to recreate it for the others
