Forum Discussion
Helper IIIInformation that disappears with “display items without data”
Helper IIIHi Ankur04 ,
You can see it in my screenshots; I should have the information from the second table with just the third line showing discounts and all the information filled in, but for the lines without discounts, the amount information is missing:
For all my orders without discounts, the information in the amount columns is missing, even though it’s present in the `order` table, like `ORDER_NUMBER` and others, which I’m able to retrieve correctly.
Resolver IIHi matdub40 ,
This is the expected behaviour, the order '996992' and 'wetsuits' combination only has discount and other details. so other row with different combination of data will be showing blank.
if you need to achieve some requirement then please provide sample data and expected output.
you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated!
Thanks,
Ankur
- matdub40
No, this is not the expected behavior.
I took another example: for lines without discount, the amount information is missing, even though all the order numbers come from the same table:
If I delete the items from the discount table, I get them.
I'd like exactly the same table as I have in one, but with the order amounts without discount.