Home Analytics

Use OData Table filter with @UserId

Jan_SchulzJan_Schulz Customer Adept IT Monkey ✭✭


is it possible to use the OData Table filter with the @UserId Token? Or how we can filter all Computer Custom Items to the logged in user?




  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭

    Hi @Jan_Schulz

    By the way, great to see you using the OData widgets, they can be very powerful once you know how!!

    You can use @UserId just like in SQL queries. Add it to the filter string.

    $filter=HardwareAssetHasPrimaryUser_BaseManagedEntityId eq @UserId


  • Jan_SchulzJan_Schulz Customer Adept IT Monkey ✭✭

    Hi @Geoff_Ross,

    yes, i think this could be very interesting for our Dashboards. :-)

    I tested your solution but i dont get any result in the ODataTable. My filter is:

    The user has one Relationship.

Sign In or Register to comment.