Is It Possible to Provide Filtering Conditions to Views?

One option is to duplicate the view in your graph extension. Just copy the Transactions view definition from SOOrderEntry.cs and give the view a different name. Add in the extra criteria and then your new grid can pull it’s values from your new view.

Yes, absolutely. You just need to include the DAC extension name instead of the original table name. For instance, possibly:

public SelectFrom<SOLine>.
    Where<SOLine.orderType.IsEqual<SOOrder.orderType.FromCurrent>.
        And<SOLine.orderNbr.IsEqual<SOOrder.orderNbr.FromCurrent>>.
        And<SOLineExt.usrOtherField.IsEqual<something>>>.View SolineView;

Could you post your code for the data view and also the custom DAC field?

I assume you’ve checked the database to verify the field you are querying actually has the value you expect?

Hi, I hope you’re doing well,

Maybe you can try to implement a view delegate, instead of a select statement.

If I understood the requirement correctly, You’re creating a new grid for selected SOLines, right?

If yes, then you can try and implement another view + delegate;
 

public SelectFrom<SOLine>.View SelectedTransactions;

public virtual IEnumerable selectedTransactions()
{
  foreach(SOLine line in Base.Transactions.Select().RowCast<SOLine>().ToList().Where(x => x.GetExtension<Ext>()?.UsrSelect == true))
{
  yield return line;
}
}

Something like this.

Or if it’s not the one that you want, Can you try doing this on your current view
 

public PXSelect<
            SOLine,
            Where<SOLine.orderType, Equal<Current<SOOrder.orderType>>,
                And<SOLine.orderNbr, Equal<Current<SOOrder.orderNbr>>, And<Current<SOLineExt.usrSelect>, Equal<True>>>>>
            SolineView;

Add Current on your SOLineExt.usrSelect

Hope this helps.

Hi @Atiq were you able to find a solution? Thank you!

Try using the view’s Cache.Updated to get the selected records

When the user selects the checkbox on the line it will add the record to the Updated list on the view’s cache.  You can just iterate that list for your process.

eg if you want to grab the selected lines from the SalesOrder Details into a list for processing...

List<SOLine> materials = Base.Transactions.Cache.Updated.RowCast<SOLine>().ToList();