1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

prevent browser row from displaying.

Discussion in 'Development' started by Jatsad, Feb 19, 2012.

  1. Jatsad

    Jatsad New Member

    Hello,

    I am trying to implement a filter on browser rows dependant on some condition.

    So if the condition is true a particular browser row will not display.

    The Row-Display trigger looks as if it's too late in the process.

    Does anyone know how to implement this?

    Thanks in advance.
     
  2.  
  3. mrobles

    mrobles Member

    Use WHERE in your query to select the desired records
     
  4. Jatsad

    Jatsad New Member

    So what you are saying is that this can only be achieved at the query stage.
    So if I have up to 8 filters that could possibly be applied, this all needs to be built into the query.
     
  5. Cringer

    Cringer ProgressTalk.com Moderator Staff Member

    There may be other ways but using filters, and dynamic queries is by far the best way IMO. 8 filters is nothing by the way.
     
  6. RealHeavyDude

    RealHeavyDude Well-Known Member

    The browse is a stupid visualization object - it just displays what the query is feeding it. Therefore the easiest way is to not have the particular row in your query. More so if your requirement is a security restriction (restrict particular users to see particular rows) - this should never be done in a visualization object.

    Apart from that you might succeed in the ROW-DISPLAY trigger - RETURN NO-APPLY when the row should not be displayed. But I have never tried that therefore I am not 100% positive whether it will work or not.

    Heavy Regards, RealHeavyDude.
     
  7. Jatsad

    Jatsad New Member

    Thanks everyone,

    I have managed to get it working by re-writing the query to not include the row at that stage.
    Bit complicated but working fine.
     

Share This Page