Querying two collections on one MobileListItem

[Peter Viglietta]

User- Guy
Password - Guy

Click Messages once you log in

It should show the body of the message on the second label on each list item

[Peter Viglietta]

Sorry, the password is just 'guy', lowercase g

[Peter Viglietta]

Please follow these steps:

Pages
Message Threads page
Data
MessageThreads list service
Edit Mapping
Response tab
MTIdLabel Edit JS
See that the query is supposed to make it so that once the MessageThreads query runs and puts the MessageThreadID on that hidden label, it will take that ID and run the Messages query with it, and return the first (hopefully most recent) row from messages that has that MessageThreadID on it, and put it in the Last Subject label on mobile list item.
Save and Return, and view the DesignTab.
See visible labels Subject and Last Message, and invisible label MessageThreadID.
Test the app, log in with user 'guy', password 'guy' click Messages, and see that the LastMessage label is still not bringing in the Body field from Messages table.

Katya tested this out separately and got it to work, but I can't get it using the same code? Am I doing something wrong?

[Evgene Karachevtsev]

Hello Peter,

You have an error in service settings MisConnectDB_Messages_query_service_clone_1
On the Settings tab in the property Settings of this service you have None, and should be MisConnectDB_settings

[Peter Viglietta]

That was it! Thank you!!