Agile Developer

Fillgrid Issue - Da...
 
Notifications
Clear all

[Solved] Fillgrid Issue - Data Replacement with Double Quotes

2 Posts
2 Users
0 Reactions
316 Views
Posts: 609
Topic starter
(@banupriya)
Noble Member
Joined: 2 years ago

An issue regarding Fillgrid where values are being replaced with double quotes. This occurs specifically in the Fillgrid SQL when utilizing the ALL condition enclosed within curly brackets, resulting in the final output being replaced with double quotes. For your reference, have attached the TraceLog files.


1 Reply
Posts: 602
Admin
(@axpertsupport)
Honorable Member
Joined: 2 years ago

Please find the product team comments: The issue is inclause ( {stritemid*}) parameter causing issue, so suggested to Ashok kumar try this parameter as :stritemid, this is working fine.

Issue Query: SELECT rn, sno, itemcode, itemname,stocklocation, stocksublocation,batch,silo,stockqty, pono,requiredqty, stockallocated, company,itemid,locationid,sublocationid FROM table(FIFO_PACKMATERAIL ( :companyid , :issue_date, ({stritemid*}) , ({strpono*}) )) PM Order By rn,sno,itemcode,stocklocation,stocksublocation,batch,silo Changed query: SELECT rn, sno, itemcode, itemname,stocklocation, stocksublocation,batch,silo,stockqty, pono,requiredqty, stockallocated, company,itemid,locationid,sublocationid FROM table(FIFO_PACKMATERAIL ( :companyid , :issue_date, :stritemid , :strpono ) ) PM Order By rn,sno,itemcode,stocklocation,stocksublocation,batch,silo


Reply
Share: