Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
SQL Page source with connected Table(s)
Options
View
Go to last post Go to first unread
Previous Topic Next Topic
Peter T.  
#1 Posted : Tuesday, July 30, 2024 10:21:57 AM(UTC)
Peter T.

Rank: Newbie

Groups: Registered
Joined: 4/30/2020(UTC)
Posts: 2
Italy
Location: Merano

Thanks: 1 times
Hi.

How I can manage the Top(100) clause in a page source with connected tables?

With an INNER JOIN sql statement the detail table are not a part of the main record.

Thanks, Peter
Back to top
WWW
bbv  
#2 Posted : Tuesday, July 30, 2024 10:44:07 AM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 498

Was thanked: 88 time(s) in 88 post(s)
There is currently no setting within the dialog to use TOP X, but we have added to our to-do for future versions

What you can do already now is to create a View which has TOP statement inside and then within the dialog add related tables to this view.
Back to top
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.