Unanswered

Show records which are not assigned to logged in user

(0) Share

Report

Posted on by xxYYxx

Hi all,

for the logged in user I want to display all records of a list which are not assigned to this user.
The user comes from the related contact table.

I have build the other way around (show all records where the logged in user is assigned as a contact) with access type "Contact access" and a table permission but this wont held for this usecase.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you give more details of the requirement? Sounds a bit strange one to me

Was this reply helpful? Yes No
xxYYxx 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure. I have a table which is called applications and has a relation to the standard contact table.
So an application could be assigned to a specific user.
The requirement is, that the logged in user sees in a list, which application is not assigned to him.

Was this reply helpful? Yes No
GWham1 on at

Like
a
(0)

Report
Copy link

Link copied!
Sounds like a little bit of an obscure one!

Have you tried to use Advanced Find / Query to get the results you want? If you can do that - then I suggest using FetchXML in a web template to display the results on your portal page. Reminder: you will need to create a table permission for the tables you are querying.

Here is an example to get you started.

{% fetchxml tickets %} // put fetch here {% endfetchxml %} {% if tickets.results.entities.size > 0 %} {% for result in tickets.results.entities %} {{ result.name }} {% endfor %} {% endif %}

Was this reply helpful? Yes No
Fubar 8,505 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You would need Global permission on the Table in question, and then create a View where the criteria is contact lookup field does not equal a contact (any contact - the portal will substitute in the current logged in user), or if only after unassigned the lookup field does not contain data - and then only use those views on the List.

However, adding a Global permission may play havoc with your contact scoped permission depending on what else you may be doing.

Was this reply helpful? Yes No