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?
Yes, I see all the data in the frontend (browser), but not in the editor. Cards component disappears from the canvas.
rec
That’s not my question.
Is your data filtered somehow or not? For example - by the ID of the logged user?
Yep, It’s filtered by user page id. All users have unique page id property in the DB. If guest visits user page, he sees current user data.
Well, you don’t have your user logged into the design view, so the data returns zero records. That’s why the repeat region is empty …
1 Like
I see ) Any workaround?
I’ve just found workaround ) Thanks for the help!