Hi Everyone,
I am unable to binding the data in grid, I don’t know what’s going on .
Data view (Graph)
[PXFilterable]
public SelectFrom<FSEquipment>.
InnerJoin<FSSODet>.On<FSSODet.SMequipmentID.IsEqual<FSEquipment.SMequipmentID>>.
InnerJoin<FSServiceOrder>.On<FSServiceOrder.refNbr.IsEqual<FSSODet.refNbr>>.
Where<FSSODet.refNbr.IsEqual<PYServiceEquipHistory.refNbr.FromCurrent>.
And<FSSODet.SMequipmentID.IsEqual<PYServiceEquipHistory.equipmentID.FromCurrent>>>.
OrderBy<FSServiceOrder.orderDate.Desc>.View ServiceEquipmentView;
Where condition not working here..!
Data available in the database
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/057cbca4-e598-4b17-a824-b1481c0c9f38.png)
When we select the both fields data adding into the grid but it’s not working.
Please help me on this issue.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f9cb6b10-ff9c-4dd7-b3a6-c0cbad4f5029.png)
Thanks
Nageswararao.
Best answer by Naveen Boga
View original