1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. You may already get a lot of direct attention from Progress. But even so it is hard to bring that attention down into the trenches and get the word out to everyone in the cubicles. We feel that this conference is, by far, the best training opportunity available in the Progress community! We're all about helping you to maximize the OpenEdge technology that you actually have today while preparing you with the knowledge you will need for tomorrow's challenges.

    Register today at http://pugchallenge.org/register.html

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. mrobles

    mrobles Member

    Use WHERE in your query to select the desired records
  3. 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.
  4. 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.
  5. 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.
  6. 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.
Similar Threads
Forum Title Date
PSDN Community Discussion Forum Switch to prevent creation of a record on buffer copy Mar 10, 2014
PSDN Community Discussion Forum Possibility to prevent SHARE-LOCKs Feb 7, 2014
Progress Blog Breathe Easy: Tips for Preventing SQL Injection Attacks Jun 3, 2013
Database Admin preventing Large Webspeed Logfiles - what have I missed ? Aug 16, 2010
Development Preventing or creating action on END-KEY Oct 20, 2009

Share This Page