...
amount och lefttouse får inte vara tomma (sätt till 0)
Hiddenfragment macro | ||
---|---|---|
| ||
BRP Internal SQL för export av värdekortselect valuecard.number as number, trim(product.name) as product, ceiling(amount) as amount, ceiling(leftToUse) as leftToUse, totalUnits, unitsLeft, validUntil, ifnull(receiver,'') as receiver, ifnull(group_concat(valuecard_cardnumber.cardnumber),'') as cardnumbers, ifnull(person.id,'') as customerExternalId from valuecard |