3 Replies Latest reply: Oct 10, 2018 1:07 AM by bhawna Agrawal RSS

    Need help to write an expression logic

    bhawna Agrawal

      Hi All,

       

      I have a requirement where I had loaded a table using an excel file into app.The data loaded have below sample schema:

       

      UserLoginApp_Instance_nameApp_Instance_StatusCreation date







      ABCADprovisioned01-Oct-2018
      XYZLDAPProvisioned01-Oct-2018
      ABCLDAPProvisioned01-Oct-2018
      ABCExchangeProvisioned01-Oct-2018
      XYZExchangeRevoked01-Oct-2018

       

      This is a sample data where same user will have account for AD, LDAP and exchange where status for thee accounts could be provisioned or revoked.

       

      Now I have a requirement where I need to create a chart to identify where if user has all 3 accounts in provisioned state then return 'true' else 'false'. based on the return value chart will be created.

       

      Now here I am facing below challenges:

       

      1. How can I check all 3 rows for same user and verify the status of it.

      2. What is the appropriate place to write the expression for above requirement. Do i need to create a variable or custom Master Item. Not sure about it.

       

      Kindly help me on this.

       

      Thanks in advance.