prevent browser row from displaying.

[Jatsad]

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.

 

[mrobles]

Use WHERE in your query to select the desired records

 

[Jatsad]

Use WHERE in your query to select the desired records

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.

 

[Cringer]

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.

 

[RealHeavyDude]

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.

 

[Jatsad]

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.