You’re offline. This is a read only version of the page.
79
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.
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.
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.
Share
Report
All responses (
Answers (
{% fetchxml tickets %}
// put fetch here
{% endfetchxml %}
{% if tickets.results.entities.size > 0 %}
{% for result in tickets.results.entities %}
{{ result.name }}
{% endfor %}
{% endif %}
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.
Can you give more details of the requirement? Sounds a bit strange one to me
#1
Fubar
69
Super User 2025 Season 1
#2
oliver.rodrigues
49
Most Valuable Professional
#3
Jon Unzueta
43
