User List for requisition transaction how would I display only requisition locations for the logged

srocke

I have the below code for a list on requisitiontransaction business class but when employees view I only want them to see their requesting locations. I have tried various instance selections and visible when but can't seem to get the filters to work. Below is the code for the list. Any help would be much appreciated.

RequisitionTransactions is a List
    title is untranslatable:"DepartmentalUsageReport"
    Display Fields
        Company
        RequestingLocation
        FromCompanyLocation.FromLocation
        Item
            link is Item.ItemDashboard
       DerivedItemDescription
            sort order is Set4
                is default
               Subtotal By
       Company
     RequestingLocation
     DerivedItemDescription2
     TransactionDate
     RequisitionTransaction.RequisitionDocumentType
     RequisitionTransaction.Requisition
           link is RequisitionRel.RequisitionDashboard
     RequisitionTransaction.RequisitionLine
           link is MyRequisitionLineRel.LineDashboard
     ItemType
     Quantity
           total
     StockUOM
     UnitCost
     LineExtendedAmount
           label is "LineExtendedAmount"
           total
     RequisitionRel.RequisitionLineDistributionRel.DistributionAccount
           label is "Account"
open action is restricted
restrict action Create

andy

I suppose you could create a relation from RequsitionTransaction to RequesterRequestingLocation where Requester equals the current Requester and then use that in your Instance Selection. Performance might be sluggish though. 

Something like...

CurrentRequesterLocationsRel 
one-to-one relation to RequesterRequestingLocation

    Field Mapping uses symbolic key

        related.Company            = Company

        related.Requester          = actor.agent(Employee).Employee.Requester.Requester

        related.RequestingLocation = RequestingLocation

Instance Selection

        where(RequestingLocation = CurrentRequesterLocationsRel.RequestingLocation)