Good Day All,
PHPRunner 6.2 Mssql 2008 Database
I have the following in my table :
ID Pickslip Product Serialno qrcode
1 1000 XGQ1000 23940
2 1000 XGQ1000 48392
3 1000 XGQ1000 35002
4 1000 XGQ1000 30049
5 1000 PGH1000 349543
6 1000 PGH1000 343434
7 1000 PGH1000 304859
8 2000 RTY9400 343433
9 2000 RTY9400 343553
10 3000 WRT6000 230230
I need to combine the same Product serial numbers into n single qr code with "'" in between each serial no.
Thus on the list page
Pickslip Product Serial no Qrcode
1000 XGQ1000 23940,48392,35002,30049
2000 PGH1000 349543,343434,304859
3000 WRT6000 230230
I have have the basics working.
List page with :
Qrcode for each line with single serial number.
ID Pickslip Product Serialno qrcode
1 1000 XGQ1000 23940
2 1000 XGQ1000 48392
3 1000 XGQ1000 35002
4 1000 XGQ1000 30049
5 1000 PGH1000 349543
6 1000 PGH1000 343434
7 1000 PGH1000 304859
8 2000 RTY9400 343433
9 2000 RTY9400 343553
10 3000 WRT6000 230230
I found this Sql Query and tried it
Select Main.Product,
Left(Main.OrderSerials,Len(Main.OrderSerials)-1) As "ConcatSerials"
From(Select distinct ST2.Product,
(Select ST1.serialno + ',' AS [text()]
From dbo.OrderDetails ST1
Where ST1.Product = ST2.Product
ORDER BY ST1.Product
For XML PATH ('')) [OrderSerials]
I do get the merged serial no by partno displayed correctly in Query Designer results but the field on the list page stays blank
arg1000 687568568,5765757,134134124,56786574
syn1000 653464,6645433,0945643
syn1500 67764676574,996433
syn1560 52452354235,3456363,65345634566,8788888
Any help or suggestions will be appreciated
Thank you
