SUMMER SALE - USE DMXSUMMER19 PROMO CODE FOR UP TO 51% OFF. Valid only until July 24th!

DMXzone App Connect Data Formatter Manual

March 14, 2017
Show or Hide Elements on Your Page, When a Query Returns no Results
Show or Hide Elements on Your Page, When a Query Returns no Results

With this movie we will show you how to use the conditional formats of DMXzone App Connect Data Formatter in order to show or hide elements on your page when your query returns no results.

Step by Step

We inserted a dynamic table on our page. It returns records from our database query. We only wish to show the table, when the query returns results. We also inserted a div container with a warning message inside, which should be displayed only when the query returns no results. Select the table (1), click the add dynamic attribute button (2) and under display, select show (3).

Click the dynamic data button in order to select a condition (1). Under the server connect component, open data and select the query you want to check (2). Click the formatter button (3).

Right click the selected expression (1) and under conditional, select has items (2). When you're done, click select (3).

Click select.

Then, click select in order to apply the condition.

And we are done. The table will only be displayed if our query returns results. Now, click the container, which you want to show, when the query returns no results (1), add dynamic attribute (2) and under display, select hide (3).

Click the dynamic data button in order to select a condition (1). Under the server connect component, select your query (2) and click the formatter button (3).

Right-click the selected expression (1) and under conditional, select has items (2). When you're done, click select (3).

Click select.

And click select in order to apply the condition. The container will be hidden, when the query returns results and will be displayed, when no results are returned.

We've setup our query to return no results. You can see the dynamic table is hidden, while the notification div is displayed on our page. That's how easy it is to use the conditional formats, included in DMXzone App Connect Data Formatter, in order to show or hide elements on your page, when your query returns no results.