In a report I use FABookBalance.BookID field. According to its definition it is an integer type, when I print it in the report it displays the FABook.BookCode field’s value. It is string type. But FABook table did not contains in the table schema of the report. I need to add a filter based on FABookBalance.BookID.
Following screenshot shows the data exist in both of tables
Following is FABookBalance.BookID field definition
public abstract class bookID : PX.Data.BQL.BqlInt.Field<bookID> { }
protected Int32? _BookID;
PXDBInt(IsKey = true)]
PXDefault()]
PXSelector(typeof(Search2<FABook.bookID,
InnerJoin<FABookSettings, On<FABookSettings.bookID, Equal<FABook.bookID>>>,
Where<FABookSettings.assetID, Equal<Current<FixedAsset.classID>>>>),
SubstituteKey = typeof(FABook.bookCode),
DescriptionField = typeof(FABook.description), CacheGlobal = true)]
PXUIField(DisplayName = "Book")]
public virtual Int32? BookID
{
get
{
return this._BookID;
}
set
{
this._BookID = value;
}
}
I need to filter only the rows which satisfy FABookBalance.BookID equals 2 condition.