Conditons filter

QuintenO
Tera Contributor

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

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

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/

PlatformPadawan
Tera Contributor

@QuintenO, were you able to replicate the last condition? I'm running into the same issue