Hi @FarhanaM60
I faced the same issue before and did a workaround to resolve the issue. Please review the below code sample
foreach (CSAttributeGroup item in PXSelectReadonly<CSAttributeGroup,
Where<CSAttributeGroup.attributeID, Equal<Required<CSAttributeGroup.attributeID>>,
And<CSAttributeGroup.entityType, Equal<Required<CSAttributeGroup.entityType>>>>>.Select(this,”AttributeID”, "PX.Objects.IN.InventoryItem"))
{
INItemClass itemClass = PXSelectReadonly<INItemClass, Where<INItemClass.itemClassID, Equal<Required<INItemClass.itemClassID>>>>.Select(this,Convert.ToInt32(item.EntityClassID));
if (itemClass != null)
{
// Write your logic
}
}
hi,
thanks for the reply
but am using for the data view it should be data view
and also am using in Join Query
HI @FarhanaM60 I don’t think that is possible to convert the data type in the BQL Query of VIEW.
You can achieve this alternative way. Please find the details below.
- Create a SQL View for the above query.
- Create a DAC for this SQL View(this will be treated a table in Acumatica)
- Provide the Key fields in DAC
- By using this DAC, you can define a VIEW in your graph.
Hope this helps!!
Hi @FarhanaM60 ,
As @jinin mentioned place that logic in View delegate.
Another approach is creating projection DAC.Please go through below link for sample with this approach.
https://stackoverflow.com/questions/53275019/joining-table-using-pxselectjoin-using-cast-in-bql-statement