Is it correct to filter on ARInvoice using a statement like :
Where<ARInvoice.status.IsEqual<"Closed">>
?
Answer
Is is a correct statement?
Best answer by Vignesh Ponnusamy
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,
+5Hi
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,
#VP
+5Hey
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.
#VP
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.