query in a single column

General
1

how can we query in a single column which keyword to use for pointing to a column maybe it’ll be something like WhereClause = “Column == ‘nameColumn’” ???

2 
columnname = <value>

if the column type is String, then you put value into single quotes:

columnname = '<value>'

For example:

name = 'Joe'
3

hello mark

maybe am not able to explain what exactly i was asking about in my question :

right now when am querying the query’s scope is in whole class i want to query in a single columnar example if their’s a table Contact
and in contact table there’s two columns name and number then how can i query only in name column , querying in only necessary column will be efficient

so like in sql we can select which columns to query can we do anything similar in backendless like

select column1 where column1 = ‘value’ ???

thanks

billion

4

You want the result returned by the backend containing only one column?

5

hey mark ,

ultimately yes but am focusing on search , i want to query only in a single column because if we have more than 100 columns and on a particular time , user wants only a single Column’s data then the search should query only that single column , say that we have a table of countries and there is total 216 columns if user wants the data of US only than i want to query only in US column it’ll be more efficient than searching through whole table ? do you get it what am explaining ? am talking about something similar to “select” Statement in SQL

thanks

billion

6

Look here in the documentation: https://backendless.com/documentation/data/rest/data_search_and_query.htm
The request has “props” field in which you define which columns you want to retrieve.