Hi Team,
Need know how to write bql query with order by and where part. Can someone help me?
My Sample
[PXFilterable]
public SelectFrom<HMRCVendorRegisterDetail>.OrderBy<Desc<HMRCVendorRegisterDetail.validTo>>.Where<HMRCVendorFilter.bAccountID.FromCurrent.IsNull.Or<HMRCVendorRegisterDetail.bAccountID.IsEqual<HMRCVendorFilter.bAccountID.FromCurrent>>>.View.ReadOnly DetailsView;
Best answer by Django
I searched through the Acumatica code for .OrderBy< and found this example:
public SelectFrom<ContactAccount>
.Where<
ContactAccount.bAccountID.IsEqual<CRLead.bAccountID.FromCurrent>
.And<ContactAccount.contactType.IsEqual<ContactTypesAttribute.person>>
>
.OrderBy<
ContactAccount.isPrimary.Desc,
ContactAccount.displayName.Asc
>
.View Link_SelectEntityForLink;
Your Where conditions should be before the OrderBy section.
SelectFrom<Table>.Where<WhereConditions>.OrderBy<Desc<Table.Field>>.View.ReadOnly DetailsView;
I searched through the Acumatica code for .OrderBy< and found this example:
public SelectFrom<ContactAccount>
.Where<
ContactAccount.bAccountID.IsEqual<CRLead.bAccountID.FromCurrent>
.And<ContactAccount.contactType.IsEqual<ContactTypesAttribute.person>>
>
.OrderBy<
ContactAccount.isPrimary.Desc,
ContactAccount.displayName.Asc
>
.View Link_SelectEntityForLink;
+19
public PXSelect<HMRCVendorRegisterDetail,Where<HMRCVendorFilter.bAccountID, IsNull, Or<HMRCVendorRegisterDetail.bAccountID, Equal<Current<HMRCVendorFilter.bAccountID>>>>,
OrderBy<Desc<HMRCVendorRegisterDetail.validTo>> DetailsView;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.