Hi,
I have added a table to display customer information from an MSSQL database. I have setup a Multiple Records Query type.
When I try to bind the table to the query, as soon as I click on the “Make Repeat Children” Property, the sample records disappear. And no records are displayed even after adding the server connect expression.
If I enter 5 or 10 number values in the expression field, the sample rows are repeated as many times.
I have another table on the page and it is working correctly. This table has less than 10 records to display from the database.
I am not sure whether there is an issue due to the number of records. The table that is not working has ~8k records and is running as a View in the database.
I’d appreciate any suggestions to resolve this issue.
Thanks.
Hi,
Have you tried creating the table by using the Bootstrap 4 Table Generator?
Then selecting the query in the generator should handle the repeats etc. automatically.
I find it easier to set up a repeating table that way and then adjust any headers/formatting afterwards.
Do your table records render fine in the browser?
Hi Philip,
Thanks for the suggestion.
I created another table by using the BS4 Table Generator. It is only showing the column headers. The table rows are not displaying any records.
Hi @Teodor, Yes, the table records are rending correctly in the browser.
Are you filtering your database query somehow?
The Query Type is Multiple Records with no condition or sorting.
Perhaps some screen shots or code snippets might help…
Are you sure that if you wait like 5 or 10 seconds the data does not appear?
Are there any errors reported at the bottom left side of Wappler window? 8k records are a lot, probably it takes some time for design view to render them.
I have attached a couple of screen shots - showing database query setup, two tables - top table showing the data correctly from the database (a different query), bottom table setup as BS4 Table Generator, showing just the column headers and browser output from the query.
The records don’t display even after a lengthy period of time. I have changed the query type to Paged Records to limit it to 25 records to check if the issue is related to number of records being returned in the query. I haven’t setup any offset for the time being to display any pagination.
Just a thought (i’m sure you’ve checked though), in case the generator isn’t working properly (and because i can’t see in the screenshot) but have you checked the dynamic values for the table cells?
It might be worth adding the dynamic attribute ‘Inner Text’ and selecting the column yourself from the repeat query.
I have tried everything I can think of - custom query, paged query, multiple / single record, data bindings to different table components - no success.
I am going to create a new project and see whether the same queries can run correctly with various data bindings. At least this will eliminate any issue that might have crept in inadvertently in the current project.
There must be something wrong on your page. I just tested with a table with 10k records, it takes a few seconds to render all the records, but it repeats my static content pretty well:
I suggest you to try recreating this on a blank page to see if it works fine.
I have resolved the issue with tables not displaying the records correctly even when I had the correct data bindings.
There seems to be a bug in the “Select Server Action” under Server Connect Data element. After binding the query under Select Server Action, when the file is saved, the following code line changes in the html file.
Note the letters “m.au” that have been automatically added as prefix in the url. When I remove this prefix, the tables start displaying the records correctly.
<dmx-serverconnect id="serverconnect3" url="m.au/dmxConnect/api/inventory/inventory_main.aspx"></dmx-serverconnect>
The following screen shot shows addition of “m.au” in the serverconnect3 code line when html file was saved. This only happens when the page is saved after adding the serverconnect binding. Once I delete this prefix, the code is not altered during any subsequent save function.
Not sure i understand what do you mean and what/where gets added.
When posting code please wrap it in three backticks so it can be displayed properly:
I have edited the previous post to show the code correctly. Sorry, I was not across the code formatting options.
The characters m.au are added to the url automatically when html file is saved for the first time after adding Server Connect data element on the page.
My project is setup with ASP.NET as the Server Model and IIS as the Handler. This code is added at the start of body tag in html file.
In the code example below, id="serverconnect3" is showing additional characters m.au in the url property. The queries for table data bindings do not execute until I delete these characters from the url. Any subsequent file saves do not add these characters.
<body is="dmx-app" id="products">
<dmx-serverconnect id="serverconnect1" url="/dmxConnect/api/customer/customer_records.aspx"></dmx-serverconnect>
<dmx-serverconnect id="serverconnect2" url="/dmxConnect/api/staff/staff_records.aspx"></dmx-serverconnect>
<dmx-serverconnect id="serverconnect3" url="m.au/dmxConnect/api/inventory/inventory_main.aspx"></dmx-serverconnect>
...
...
</body>
I do not whether this is by design or a bug. I am running Wappler v3.0.1 on MacOS.
Are you sure your site settings/target are properly setup?
If the m.au gets added probably this is some subfolder you are working on?
The Web Server URL and FTP Server are correctly setup.
It looks like m.au are the last 3 characters of the folder name where I am saving the project files. The folder name matches the website address and it ends with .com.au.
The subfolder name contains 26 characters and the complete file path for the project folder is more than 100 characters long. Could that be an issue here?
@Teodor, I have the same issue - card columns disappear in the Editor when Server connect expression is selected in the Repeat properties.
I set up Card Columns to display data from Postgres database with multiple records query.
After clicking on the Make Repeat Children Property cards will instantly disappear in the editor, but will work in the browser.
As it was mentioned before, If you enter any number values (1, 5 …etc) in the expression field, the sample cards are repeated in the editor as it should. But not with Server connect property.
<div class="card-columns" is="dmx-repeat" id="repeat4" dmx-bind:repeat="userprofile.data.posts">
<div class="card">
<img class="card-img-top" alt="Card image cap" dmx-bind:src="image">
<div class="card-body">
<p class="card-text" dmx-text="content"></p>
<a href="#" class="btn btn-primary">Go somewhere</a>
</div>
</div>
</div>
OS info
- Operating System : Mac OSX 19.5.0
- Wappler Version : 3.1.0
- Project: Node js.
Thanks.
Well, does your data source return any data at all? Or is it filtered somehow?