I am using query object in class using report data provider, i want to insert in temp table but temp is empty using this code:
Query query;
QueryBuildDataSource qbds;
QueryBuildRange range;
QueryRun queryrun;
query=new Query();
qbds=query.addDataSource(tableNum(InventSalesOrderView));
range=qbds.addRange(fieldNum(InventSalesOrderView,createdBy1));
//range.value(creation_user);
queryrun=new QueryRun(query);
while (queryrun.next()){
inventTMP.dataAreaId=salesview.dataAreaId;
inventTMP.type="Sales Order";
inventTMP.type_id=salesview.SalesId;
inventTMP.packing_id=salesview.PackingSlipId;
inventTMP.item_id=salesview.ItemId;
inventTMP.item_name=salesview.Name;
inventTMP.qty=salesview.Qty;
inventTMP.invent_location=salesview.InventLocationId;
inventTMP.created_by=salesview.createdBy1;
inventTMP.created_date_time=salesview.createdDateTime1;
tinventTMP.ransaction_date=salesview.DeliveryDate;
this.insert_Tmp_Table();
}
*This post is locked for comments
I have the same question (0)
