multiable line print reg

Dear all ,

Please see my fetch querry,

Select inventTrans
where inventTrans.InventTransId == salesline.InventTransId
join dimtable
where dimtable.inventDimId == inventTrans.inventDimId
join prodTable
where prodTable.SalesBatchId == dimtable.inventBatchId
join seedProcessLine
where seedProcessLine.ProdId == prodTable.ProdId
join seedProcessMixBlendTable
where seedProcessMixBlendTable.InventBatchId == seedProcessLine.InputBatch
join seedProcessMixBlendLine
where seedProcessMixBlendLine.MixingBlendingId == seedProcessMixBlendTable.MixingBlendingId;
{
mixinglot1 = seedProcessMixBlendLine.InventBatchId;
}

in that seedProcessMixBlendline having multiple lines of datas, but now it print any one line data only, so i need all lines datas from that seedProcessMixBlendline. pls clarify my doubt

Why you are selecting InventTrans, InventDim here? Do you require any data from those table? It will be difficult to answer this without knowing the exact purpose and table structures.

Actually i am new client , Kindly see my full fetch, please update u r advice

public boolean fetch()
{
boolean first = true;

SeedProcessMixBlendTable seedProcessMixBlendTable;
SeedProcessMixBlendLine seedProcessMixBlendLine;
SeedProcessLine seedProcessLine;
ProdTable prodTable;
InventDim dimtable;
InventTrans inventTrans;

;
query = this.query();
queryRun = new QueryRun(this);
while (queryRun.next())
{
SalesTable = queryRun.get(tablenum(SalesTable));
SalesLine = queryRun.get(tablenum(SalesLine));
dcno = SalesLine.SalesId;
dcdate = InventTrans::findtrid(salesline.InventTransId).DatePhysical;
Crop = CropTable::find(InventTable::find(salesline.ItemId).CropCode).Name;
variety = InventTrans::findtrid(salesline.InventTransId).ItemId;
seedclass = SeedClassTable::find(Inventtable::find(salesline.ItemId).SeedClassCode).SeedClassDesc;
lotno = InventDim::finddimid(InventTrans::findtrid(Salesline.InventTransId).inventDimId).inventBatchId;
lotqty = SeedProcessLine::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).ToBeProcessQty;
transqty = SeedProcessLine::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).ToBeProcessQty;
packsize = SeedProcessPackingTable::find
(SeedProcessTable::find(ProdTable::findsalesbatchid
(InventDim::finddimid(InventTrans::findtrid
(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).PackingId).Description;
nooftag = SeedProcessTable::findByProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).NetQty;
fromno = SeedProcessPackingDetails::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).PktStartingNo;
tono = SeedProcessPackingDetails::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).PktStartingNo;
farmerid = MixingLotTable::find(SeedProcessLine::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).InputBatch).AccountNum;
farmerid1 = QCLotMaster::findBatchid(SeedProcessLine::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).InputBatch).FarmerCode;
Farmername = VendTable::find(MixingLotTable::find(SeedProcessLine::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).InputBatch).AccountNum).Name;
Farmername1= VendTable::find(QCLotMaster::findBatchid(SeedProcessLine::findProdId(ProdTable::findsalesbatchid
(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).InputBatch).FarmerCode).Name;
// Testdate = GCOthers::find(GPSowing::findqclotno(
// QCLotMaster::findBatchid(SeedProcessLine::findProdId(ProdTable::findsalesbatchid(InventDim::finddimid(InventTrans::findtrid(SalesLine.InventTransId
// ).inventDimId).inventBatchId).ProdId).InputBatch).QCLotNumber).LabTestReportNo).TestDate;
// Testdate1 = GCOthers::find(GPSowing::findlotno(QCLotMaster::findFarmerid(
// MixingLotTable::find(SeedProcessLine::findProdId(
// ProdTable::findsalesbatchid(InventDim::finddimid(
// InventTrans::findtrid(SalesLine.InventTransId).inventDimId).inventBatchId).ProdId).InputBatch).AccountNum).RefLotNo).LabTestReportNo).TestDate;

villagename= VillageTable::find(DirPartyAddress::findAddress(VendTable::find(farmerid1), AddressType::Invoice).VillageId).VillageName;
villagename1= VillageTable::find(DirPartyAddress::findAddress(VendTable::find(farmerid), AddressType::Invoice).VillageId).VillageName;

taluk = VillageTable::find(DirPartyAddress::findAddress(VendTable::find(farmerid1), AddressType::Invoice).VillageId).TalukName;
taluk1 = VillageTable::find(DirPartyAddress::findAddress(VendTable::find(farmerid), AddressType::Invoice).VillageId).TalukName;

dist = AddressCounty::finddistid(VillageTable::find(DirPartyAddress::findAddress(VendTable::find(farmerid), AddressType::Invoice).VillageId).AddressCountyId).Name;
dist1 = AddressCounty::finddistid(VillageTable::find(DirPartyAddress::findAddress(VendTable::find(farmerid1), AddressType::Invoice).VillageId).AddressCountyId).Name;

Select inventTrans
where inventTrans.InventTransId == salesline.InventTransId
join dimtable
where dimtable.inventDimId == inventTrans.inventDimId
join prodTable
where prodTable.SalesBatchId == dimtable.inventBatchId
join seedProcessLine
where seedProcessLine.ProdId == prodTable.ProdId
join seedProcessMixBlendTable
where seedProcessMixBlendTable.InventBatchId == seedProcessLine.InputBatch;
{
mixinglot = seedProcessLine.InputBatch;
}

Select inventTrans
where inventTrans.InventTransId == salesline.InventTransId
join dimtable
where dimtable.inventDimId == inventTrans.inventDimId
join prodTable
where prodTable.SalesBatchId == dimtable.inventBatchId
join seedProcessLine
where seedProcessLine.ProdId == prodTable.ProdId
join seedProcessMixBlendTable
where seedProcessMixBlendTable.InventBatchId == seedProcessLine.InputBatch
join seedProcessMixBlendLine
where seedProcessMixBlendLine.MixingBlendingId == seedProcessMixBlendTable.MixingBlendingId;
{
mixinglot1 = seedProcessMixBlendLine.InventBatchId;
}

element.send(SalesTable);
element.send(SalesLine);
element.execute(1);

}
return true;
}