Conditons filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 12:25 AM
Hello All,
i want to make a overview voor over lincense.
But i am stuck at the last conditon,
Can someone tell me where i can find this last condtion
Table:
[sys_user_has_role]
Conditions:
User.Active is True
and
User ID is not empty
and
Last login time in the past 365 days
and
Web Service Access only = false
and
Assigned Fulfiller role(s) mapped to this Product's entitled Applications
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 10:52 PM - edited 08-19-2024 10:53 PM
Hi @QuintenO ,
From the sys_user_has_role table, you should dot-walk to user where you can make the condition. Please see the query below. According to you last requirement " Assigned Fulfiller role(s) mapped to this Product's entitled Applications", Where do you have this requirement from? It doesn't really make any sense.
user.active=true^user.user_nameISNOTEMPTY^user.last_loginRELATIVEGT@dayofweek@ago@365^user.web_service_access_only=false
if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@QuintenO, were you able to replicate the last condition? I'm running into the same issue