2 Replies Latest reply on Feb 8, 2012 7:31 AM by d.vanlooij

    using variable in a portal tool

    d.vanlooij

      Title

      using variable in a portal tool

      Post

      Hi,

      I am building a tool for my company which in we are gathering all the issues from production.

      Now I want to make views which view a selection of these issues based on the department where the user works.

      Via a global variable in a script the department is set based on a table where the users are stated in.

      But how do I filter the portal tool based on this variable? If I set it in the filter of the portal tool there are no items shown.

      Altough I have several issues.

       

        • 1. Re: using variable in a portal tool
          philmodjunk

          Can you describe what you attempted in more detail? Including both the relationship and filter expression used for the portal?

          A portal filter reduces the set of related records shown in the portal.

          If you have a portal that shows these values:

          Apple
          Blueberry
          Orange

          and then add a portal expression:

          PortalTable::FruitName = Orange

          The list of related records will be reduced to:

          Orange

          • 2. Re: using variable in a portal tool
            d.vanlooij

            At log-in a script runs which sets a global variable with the productionline number.

            This variable isused throughout the system when the user makes a new record.

            I will test something and if I still have a problem I will let you know.

             

            thanx a lot.