nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Check if Wiki Markup is empty

TomTom2

Hi!

I have several pages using a Wiki Markup with a SQL statement inside (sql macro). Those sql queries are database checks I am performing.

Now, I want to create an overview of all the checks I am running within those subsites.
This overview should be a traffic light status layout which gives me green or red status lights based on if there is a result in the sql statement of the subsite or not.

What I have figured out is, that a possible soltution would be to have two sections on such a subsite:
1. the query itself
2. a check which returns {status:color=red|title=issues found} if the sql query returns any results and status:green if the query does not return any results.

Then I would be able to create an overview page containing a table and each row of this table contains the {status} syntax of a subsite (i think there is the possibility to show only a specific section of a page).

Does someone have an idea how this could work out?
How could I run a check against a Wiki Markup to figure out if it is empty or not?

Thanks in advance,
Tom

Accepted answers

Bob Swift

You could construct a similar query that is based on the count of rows returned and uses an SQL case statement or similar and returns the text you want to display. For example:

select case 
    when (select count(*) from test_address1 where last = 'Smith') &gt; 0 
    then '{status:color=red|title=issues found}' 
    else '{status:color=green|title=No issues!}' 
end

Use this on your summary page or, if you have to, put that data into metadata or something on the subsite page and bring it in using reporting macro or similar.

All comments

Bob Swift

You could construct a similar query that is based on the count of rows returned and uses an SQL case statement or similar and returns the text you want to display. For example:

select case 
    when (select count(*) from test_address1 where last = 'Smith') &gt; 0 
    then '{status:color=red|title=issues found}' 
    else '{status:color=green|title=No issues!}' 
end

Use this on your summary page or, if you have to, put that data into metadata or something on the subsite page and bring it in using reporting macro or similar.

TomTom2

Hi Bob, thanks for the quick response!

I actually had that, but it didnt work for me so I thought this is not possible.

My markup contains:

{sql:DataSource=datasource|output=html|table=false|macros=true}
select case
    when (SELECT 0) = 1
    then '{status:color=red|title=issues found}'
    else '{status:color=green|title=No issues!}'
end
{sql}

The result looks like this:

Am I missing any parameters here?

TomTom2

Hi Bob, thanks for the quick response!

I actually had that, but it didnt work for me so I thought this is not possible.

My markup contains:

{sql:DataSource=datasource|output=html|table=false|macros=true}
select case
    when (SELECT 0) = 1
    then '{status:color=red|title=issues found}'
    else '{status:color=green|title=No issues!}'
end
{sql}

The result looks like this:

Am I missing any parameters here?

TomTom2

Hi Bob, thanks for the quick response!

I actually had that, but it didnt work for me so I thought this is not possible.

My markup contains:

{sql:DataSource=datasource|output=html|table=false|macros=true}
select case
    when (SELECT 0) = 1
    then '{status:color=red|title=issues found}'
    else '{status:color=green|title=No issues!}'
end
{sql}

The result looks like this:

Am I missing any parameters here?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

sql

status

traffic-light

wiki

markup