Are you able to hide a row on a table on a Confluence page without deleting it?

[Kristen Pennell]

Are you able to hide a row on a table on a Confluence page without deleting it?

I am trying to hide a row as I don't want to delete it. Is there a way to do this? Mainly i want to keep the number sequence intact for the rows as they have been referenced elsewhere but I no longer need to show the content of that row. Thanks! 

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Kristen Pennell,

You can try to do it with the help of Table Filter macro of Table Filter and Chart for Confluence app.

 

Katerina
Stiltsoft

[Kristen Pennell]

This is exactly what I needed thank you so much!! 

[Emily Berg]

Hi @Katerina Rudkovskaya _Stiltsoft_ ,

Could you provide a solution within the source code to remove this from the table?  I.e. a table transformer query to remove rows with a matching value?

Thanks!

Emily

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Emily Berg

Please see the example below:

The SQL query:

SELECT * FROM T*
WHERE T1.'Status'<>"Cancelled"

Katerina
Stiltsoft

[Emily Berg]

@Katerina Rudkovskaya _Stiltsoft_ 

Awesome, thank you!!  I was trying to use WHERE T1.'Status' NOT "Cancelled".  I appreciate the fast response!

Emily