Best way to see all records assigned to a user?

Hi Kristjan Geir Mathiesen,

An advanced report would be one way to find this information. For example, a simple query such as the following could be used:

SELECT * FROM accounts
WHERE assigned_user_id = 'user_id_here' AND deleted = '0';

Another option is to create a row and columns report for each module you wish to check, setting the define filter show records assigned to the given user.

Best wishes,
Nathaniel

Hi Kristjan Geir Mathiesen,

An advanced report would be one way to find this information. For example, a simple query such as the following could be used:

SELECT * FROM accounts
WHERE assigned_user_id = 'user_id_here' AND deleted = '0';

Another option is to create a row and columns report for each module you wish to check, setting the define filter show records assigned to the given user.

Best wishes,
Nathaniel

Thanks Nathaniel Ray for this. I´m looking for all records assigned to a certain user to the row and columns report per module isn´t the nice overlook I want (tried it and it´s too cumbersome).

I can´t get this query to return any results. Not sure what I am doing wrong but also, how would a query for all modules look like (i.e. all records, regardless of module, assigned to a specific user)?

And is there a way to have a "run-time filter" function (like that of regular Reports) in Advanced Queries?

Thanks again,

KGM