SOS! How to add a restriction to a View on the support case screen in the Portal

@aaghaei Thanks for the tip 

This is how I resolved the issue.  I found something similar to this in the Acumatica Training code.

One thing that I had to do is use the UserID of the Contact table in the where clause and compare it to the current logged in userID.  For some reason, the ContactID of the AccessInfo was null.

(AccessInfo.contactID.FromCurrent)

I’ll play with pulling the contactID as your code suggests and maybe I can get it that way.

I’ve never done this type of coding in a project before.  This works, but feel free to suggest improvements.  It seems like I should not have to loop through and execute the query, but just pull a result set and return it.  But I guess I have to “yield” each row individually.

    public class SPCaseClosedInquiry_Extension : PXGraphExtension<SPCaseClosedInquiry>
    {
        protected virtual IEnumerable filteredItems()
        {

            BqlCommand query;

            query = new SelectFrom<CRCase>
            .LeftJoin<CRCaseClass>
                .On<CRCaseClass.caseClassID.IsEqual<CRCase.caseClassID>>
            .LeftJoin<Contract>
                .On<Contract.contractID.IsEqual<CRCase.contractID>>
            .LeftJoin<BAccount>
                .On<BAccount.bAccountID.IsEqual<CRCase.customerID>>
            .LeftJoin<CRCustomerClass>
                .On<CRCustomerClass.cRCustomerClassID.IsEqual<BAccount.classID>>
            .LeftJoin<Contact2>
                .On<CRCase.ownerID.IsEqual<Contact2.contactID>>
            .LeftJoin<Contact>
                .On<CRCase.contactID.IsEqual<Contact.contactID>>
            .LeftJoin<CRContactClass>
                .On<CRContactClass.classID.IsEqual<Contact.classID>>
            .Where<Brackets<MatchWithBAccountNotNull<CRCase.customerID>>
                .And<CRCase.isActive.IsEqual<False>>
                .And<Brackets<CRCaseClass.isInternal.IsEqual<False>
                    .Or<CRCaseClass.isInternal.IsNull>>>
                .And<Brackets<CRCustomerClass.isInternal.IsEqual<False>
                    .Or<CRCustomerClass.isInternal.IsNull>>>
                .And<Brackets<CRContactClass.isInternal.IsEqual<False>
                    .Or<CRContactClass.isInternal.IsNull>>
                .And<Contact.userID.IsEqual<AccessInfo.userID.FromCurrent>>>>();

            var view = new PXView(Base, true, query);

            foreach (PXResult<CRCase> item in view.SelectMulti(null))
            {
                yield return item;
            }