Filtering values in a relational field... Hot

by Ryan Spradlin on June 25, 2015

There are lots of ways currently to filter the values shows in a relational field. Typically these require a dependency and another relational field by essentially creating a cross join between values between two auxiliary tables related to the same primary table as well as each other. This works fine when you have the three table triangle setup or when you don't mind all values begin filtered the same for an entire workflow. However, it would be nice to see the potential for filtering these relational records extended beyond dependencies. For example, between related primary tables. We have a Change Management application that has a relational field pointed at the CI records in our CMDB application. In many instances, we would like to be able to filter the list of CIs available in the relational field depending on the CI type, the state it might be in; the list of possible filters is endless. In theory, I'd like to see (in Composer) the filtering properties of a relational field have a similar interface as that of an embedded report. I'd like to create a listing report against my primary or auxiliary table, get the reference link for that report, and then have that populate the list of items returned in my relational field. The upside to this would be... 1: I can control the values returned in any way I want without having to manage a dependency or have additional aux tables. 2: The filtering would not be dependent on the workflow. 3: I could control the presentation of the results, rather than relying on the value display format (which for us changes depending on the context we are viewing the item in .

  • Please login to view any attachments.

  • Already have an account? or Create an account
    Hi,
    is it released already?

    Regards,
    Marek
    Marek Wilczewski Commented by Marek Wilczewski April 29, 2018
    Top 500 Reviewer  -  

    Hi,
    is it released already?

    Regards,
    Marek

    We were unable to deliver this in SBM 11.2. Deferring to 2HCY'17 release.
    David J. Easter Commented by David J. Easter December 19, 2016
    #1 Reviewer  -  

    We were unable to deliver this in SBM 11.2. Deferring to 2HCY'17 release.

    How about a Where Clause on the Relational Field Options Values. Have fields other than Title present, when providing the Application and Table information giving the Composer the ability to base the relational field selection on another field being on/off similar to how Active/Inactive works with the lists. E.g. AUX table for Locations.(title) also has fields entity fields APPDEV(binary), PMO(binary), etc. and based on the Values of these limit the lists.
    Devra Komendanchik Commented by Devra Komendanchik October 20, 2016
    Top 500 Reviewer  -  

    How about a Where Clause on the Relational Field Options Values. Have fields other than Title present, when providing the Application and Table information giving the Composer the ability to base the relational field selection on another field being on/off similar to how Active/Inactive works with the lists. E.g. AUX table for Locations.(title) also has fields entity fields APPDEV(binary), PMO(binary), etc. and based on the Values of these limit the lists.

    We'll put this under consideration for the 2HCY'16 release.
    David J. Easter Commented by David J. Easter February 09, 2016
    #1 Reviewer  -  

    We'll put this under consideration for the 2HCY'16 release.

    May I add that, while relational grid approach has it's value, its biggest drawback is that it is based on report meaning that users must have view and report privileges to target data which is not always desirable.
    Gordan Mirkovic Commented by Gordan Mirkovic November 10, 2015
    Top 100 Reviewer  -  

    May I add that, while relational grid approach has it's value, its biggest drawback is that it is based on report meaning that users must have view and report privileges to target data which is not always desirable.

     
    View all user comments
     

PrintEmail

Recent Tweets