Forum | Appery.io

Hi,

I’m trying to query information of a created column in the Users collection using a saved local variable. Is it possible to query information of a created column directly on the Users Collection? Or do I need to create another collection with a pointer to Users?

Hello! Sure, it's possible - here is more information http://docs.appery.io/documentation/b... (User queries)

Thanks Maryna, but I don't see where this Database service has been created:

Could you please inform what exactly I should do?

I have all services created for the other collections, except for the Users.

I'm sorry I have figured it out already.

One more question:

I've made a test tying to use the following code to query this tipoUsuario column with a saved local variable:

return '{"tipoUsuario" : "'+value+'"}';

But nothing happens.

I've checked the local variable pointing the response to a Label on the UI and it's being saved correctly.

Thanks

Just one correction.

The code used in the where clause is:

return '{"_id" : "'+value+'"}';

Hello,

When you test the query service in Test tab - Were you getting results from the service?
Are the any errors in browser console when you test app?

Igor,

I got it.

Thank you!