Home Analytics

Use OData Table filter with @UserId

Jan_SchulzJan_Schulz Customer Adept IT Monkey ✭✭

Hi,

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?

regards,

Jan

Answers

  • Geoff_RossGeoff_Ross Cireson Consultant O.G.

    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
    

    Geoff

  • 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.