Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved retrieve data from 2 tables

  1. How-to
0
Votes
Undo
  1. Aaron D'Hooghe
    Aaron D'Hooghe
  2. SnapDevelop
  3. Tuesday, 7 February 2023 14:42 PM UTC

Hi,

 

I have a datawindow which selects data from two different tabels(using a join) with a one to one relationship.

When i create a datastore with this datawindow, and I use the RetrieveAsync/RetrieveByPageAsync methode, I get the values of both tables in my datawindow.

In this case the "City" and "CntryCode" are properties from the second table.

But when i use the RetrieveByKeyAsync methode, only the data of the first table is given. The proprties of the second table are null.

Is there something extra i should add ?

Swagger.xml is being used by another process
Web API transaction management and multiple DWs up...
Responses (2)
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 08:48 AM UTC
  2. SnapDevelop
  3. # 1

Hi Aaron,

Please notice that the RetrieveByKey method uses the [Key] attributes applied to the model to generate a new SQL Select to query data from the table.

You need to use the Retrieve method to execute your original SQL Select to query data from multiple tables.

Regards, Logan

Comment
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 February 2023 14:58 PM UTC
  2. SnapDevelop
  3. # 2

Hi Aaron,

I couldn't find anything in the documentation that might describe this behavior so it's possible that it is a bug.
Please create a simple test case that reproduces this issue and submit it through our support portal

Regards,
Francisco

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.