Is it correct to filter on ARInvoice using a statement like :
Where<ARInvoice.status.IsEqual<"Closed">>
?
Best answer by Vignesh Ponnusamy
View originalIs is a correct statement?
Userlevel 1
Userlevel 7
+4
Hi
You cannot use string like that, instead reuse the constant defined in the existing ARDocStatus class. Example below,
Where<ARInvoice.status.IsEqual<ARDocStatus.closed>Good Luck,
Userlevel 1
Thank you, Vignesh. that was helpful
Userlevel 1
what about ARInvoice Terms? is there any class in which the terms are defined?
Userlevel 7
+4
Hey
From a quick check I think the termsID is being fetched from the database. To be able to use a constant value you can create a BQL field, set the required value and use it the query. Below is an example,
public class custPrefix : PX.Data.BQL.BqlString.Constant<custPrefix>
{
public custPrefix() : base("%500%") { }
}Note: User the Bql data format similar to the TermID. Hope that helps.! Feel free to post back if you have any questions.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.