There is a requirement to retrieve only move transactions, which can be identified by the value of AMBatch.docType. If AMBatch.docType = 'M', it indicates a move transaction. How to write it in fluent BQL?
I used the following BQL query, but it contains an error. How can I correct it?
.Where<AMBatch.docType.IsEqual<'M'>
Answer
How to filter using fluent BQL
Best answer by noorula77
.Where<AMBatch.docType.IsEqual<MoveDocType>>
// Define the constant class (put this outside your query)
public class MoveDocType : PX.Data.BQL.BqlString.Constant<MoveDocType>
{
public MoveDocType() : base("M") { }
}
+1
.Where<AMBatch.docType.IsEqual<@P.AsString>.View.Select(PXGraph, ‘M’);
~ Phil
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.