public class MobileServiceTable.MobileServiceQuery
extends java.lang.Object
Modifier and Type | Method and Description |
---|---|
MobileServiceTable.MobileServiceQuery |
add()
Add operator.
|
MobileServiceTable.MobileServiceQuery |
add(MobileServiceTable.MobileServiceQuery otherQuery)
Add operator.
|
MobileServiceTable.MobileServiceQuery |
and()
Conditional and.
|
MobileServiceTable.MobileServiceQuery |
and(MobileServiceTable.MobileServiceQuery otherQuery)
Conditional and.
|
MobileServiceTable.MobileServiceQuery |
ceiling(MobileServiceTable.MobileServiceQuery otherQuery)
The smallest integral value greater than or equal to the parameter
value.
|
MobileServiceTable.MobileServiceQuery |
concat(MobileServiceTable.MobileServiceQuery str1,
MobileServiceTable.MobileServiceQuery str2)
String value which is the first and second parameter values merged
together with the first parameter value coming first in the result.
|
MobileServiceTable.MobileServiceQuery |
day(MobileServiceTable.MobileServiceQuery otherQuery)
The day component value of the parameter value.
|
MobileServiceTable.MobileServiceQuery |
div()
Divide operator.
|
MobileServiceTable.MobileServiceQuery |
div(MobileServiceTable.MobileServiceQuery otherQuery)
Divide operator.
|
MobileServiceTable.MobileServiceQuery |
endsWith(MobileServiceTable.MobileServiceQuery field,
MobileServiceTable.MobileServiceQuery end)
Whether the end of the first parameter value matches the second
parameter value.
|
MobileServiceTable.MobileServiceQuery |
eq()
Equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
eq(boolean booleanValue)
Equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
eq(MobileServiceTable.MobileServiceQuery otherQuery)
Equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
eq(java.lang.Number numberValue)
Equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
eq(java.lang.String stringValue)
Equal comparison operator.
|
<E> void |
execute(java.lang.Class<E> clazz,
TableQueryCallback<E> callback)
Executes the query
|
void |
execute(TableJsonQueryCallback callback)
Executes the query and returns the JSON with the results
|
MobileServiceTable.MobileServiceQuery |
field(java.lang.String fieldName)
Specifies the field to use
|
MobileServiceTable.MobileServiceQuery |
floor(MobileServiceTable.MobileServiceQuery otherQuery)
The largest integral value less than or equal to the parameter value.
|
MobileServiceTable.MobileServiceQuery |
ge()
Greater than or equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
ge(MobileServiceTable.MobileServiceQuery otherQuery)
Greater than or equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
ge(java.lang.Number numberValue)
Greater than or equal comparison operator.
|
java.lang.String |
getQueryText()
Returns the main text of the query
|
java.lang.String |
getRowSetModifiers()
Returns the string representation of the rowset's modifiers
|
MobileServiceTable.MobileServiceQuery |
gt()
Greater than comparison operator.
|
MobileServiceTable.MobileServiceQuery |
gt(MobileServiceTable.MobileServiceQuery otherQuery)
Greater than comparison operator.
|
MobileServiceTable.MobileServiceQuery |
gt(java.lang.Number numberValue)
Greater than comparison operator.
|
MobileServiceTable.MobileServiceQuery |
hour(MobileServiceTable.MobileServiceQuery otherQuery)
The hour component value of the parameter value.
|
MobileServiceTable.MobileServiceQuery |
includeInlineCount()
The inlinecount property specifies whether or not to retrieve a
property with the number of records returned.
|
MobileServiceTable.MobileServiceQuery |
indexOf(MobileServiceTable.MobileServiceQuery haystack,
MobileServiceTable.MobileServiceQuery needle)
Index of the first occurrence of the second parameter value in the
first parameter value or -1 otherwise.
|
MobileServiceTable.MobileServiceQuery |
le()
Less than or equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
le(MobileServiceTable.MobileServiceQuery otherQuery)
Less than or equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
le(java.lang.Number numberValue)
Less than or equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
lt()
Less than comparison operator.
|
MobileServiceTable.MobileServiceQuery |
lt(MobileServiceTable.MobileServiceQuery otherQuery)
Less than comparison operator.
|
MobileServiceTable.MobileServiceQuery |
lt(java.lang.Number numberValue)
Less than comparison operator.
|
MobileServiceTable.MobileServiceQuery |
minute(MobileServiceTable.MobileServiceQuery otherQuery)
The minute component value of the parameter value.
|
MobileServiceTable.MobileServiceQuery |
mod()
Reminder (or modulo) operator.
|
MobileServiceTable.MobileServiceQuery |
mod(MobileServiceTable.MobileServiceQuery otherQuery)
Reminder (or modulo) operator.
|
MobileServiceTable.MobileServiceQuery |
month(MobileServiceTable.MobileServiceQuery otherQuery)
The month component value of the parameter value.
|
MobileServiceTable.MobileServiceQuery |
mul()
Multiply operator.
|
MobileServiceTable.MobileServiceQuery |
mul(MobileServiceTable.MobileServiceQuery otherQuery)
Multiply operator.
|
MobileServiceTable.MobileServiceQuery |
neq()
Not equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
neq(boolean booleanValue)
Not equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
neq(MobileServiceTable.MobileServiceQuery otherQuery)
Not equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
neq(java.lang.Number numberValue)
Not equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
neq(java.lang.String stringValue)
Not equal comparison operator.
|
MobileServiceTable.MobileServiceQuery |
not()
Logical not.
|
MobileServiceTable.MobileServiceQuery |
not(boolean booleanValue)
Logical not.
|
MobileServiceTable.MobileServiceQuery |
not(MobileServiceTable.MobileServiceQuery otherQuery)
Logical not.
|
MobileServiceTable.MobileServiceQuery |
or()
Conditional or.
|
MobileServiceTable.MobileServiceQuery |
or(MobileServiceTable.MobileServiceQuery otherQuery)
Conditional or.
|
MobileServiceTable.MobileServiceQuery |
orderBy(java.lang.String field,
QueryOrder order)
Adds a new order by statement
|
MobileServiceTable.MobileServiceQuery |
replace(MobileServiceTable.MobileServiceQuery str,
MobileServiceTable.MobileServiceQuery find,
MobileServiceTable.MobileServiceQuery replace)
Finds the second string parameter in the first parameter string value
and replaces it with the third parameter value.
|
MobileServiceTable.MobileServiceQuery |
round(MobileServiceTable.MobileServiceQuery otherQuery)
The nearest integral value to the parameter value.
|
MobileServiceTable.MobileServiceQuery |
second(MobileServiceTable.MobileServiceQuery otherQuery)
The second component value of the parameter value.
|
MobileServiceTable.MobileServiceQuery |
select(java.lang.String... fields)
Specifies the fields to retrieve
|
void |
setQueryText(java.lang.String queryText)
Sets the main text of the query
|
MobileServiceTable.MobileServiceQuery |
skip(int skip)
Sets the number of records to skip over a given number of elements in
a sequence and then return the remainder.
|
MobileServiceTable.MobileServiceQuery |
startsWith(MobileServiceTable.MobileServiceQuery field,
MobileServiceTable.MobileServiceQuery start)
Whether the beginning of the first parameter values matches the
second parameter value.
|
MobileServiceTable.MobileServiceQuery |
sub()
Subtract operator.
|
MobileServiceTable.MobileServiceQuery |
sub(MobileServiceTable.MobileServiceQuery otherQuery)
Subtract operator.
|
MobileServiceTable.MobileServiceQuery |
substring(MobileServiceTable.MobileServiceQuery str,
MobileServiceTable.MobileServiceQuery pos)
String value starting at the character index specified by the second
parameter value in the first parameter string value.
|
MobileServiceTable.MobileServiceQuery |
substring(MobileServiceTable.MobileServiceQuery str,
MobileServiceTable.MobileServiceQuery pos,
MobileServiceTable.MobileServiceQuery length)
String value starting at the character index specified by the second
parameter value in the first parameter string value.
|
MobileServiceTable.MobileServiceQuery |
subStringOf(MobileServiceTable.MobileServiceQuery str1,
MobileServiceTable.MobileServiceQuery str2)
Whether the second parameter string value occurs in the first
parameter string value.
|
MobileServiceTable.MobileServiceQuery |
top(int top)
Sets the number of records to return
|
java.lang.String |
toString()
Returns the string representation of the query
|
MobileServiceTable.MobileServiceQuery |
val(boolean val)
Specifies a boolean value
|
MobileServiceTable.MobileServiceQuery |
val(java.lang.Number number)
Specifies a numeric value
|
MobileServiceTable.MobileServiceQuery |
val(java.lang.String s)
Specifies a string value
|
MobileServiceTable.MobileServiceQuery |
year(MobileServiceTable.MobileServiceQuery otherQuery)
The year component value of the parameter value.
|
public java.lang.String getQueryText()
public void setQueryText(java.lang.String queryText)
queryText
- The text to setpublic java.lang.String toString()
toString
in class java.lang.Object
public java.lang.String getRowSetModifiers() throws java.io.UnsupportedEncodingException
java.io.UnsupportedEncodingException
public <E> void execute(java.lang.Class<E> clazz, TableQueryCallback<E> callback)
clazz
- The class used to deserialize the rowscallback
- Callback to invoke when the operation is completedpublic void execute(TableJsonQueryCallback callback)
clazz
- The class used to deserialize the rowscallback
- Callback to invoke when the operation is completedpublic MobileServiceTable.MobileServiceQuery orderBy(java.lang.String field, QueryOrder order)
field
- FieldNameorder
- Sorting orderpublic MobileServiceTable.MobileServiceQuery top(int top)
top
- Number of records to returnpublic MobileServiceTable.MobileServiceQuery skip(int skip)
skip
- public MobileServiceTable.MobileServiceQuery includeInlineCount()
public MobileServiceTable.MobileServiceQuery select(java.lang.String... fields)
fields
- Names of the fields to retrievepublic MobileServiceTable.MobileServiceQuery field(java.lang.String fieldName)
fieldName
- The field to usepublic MobileServiceTable.MobileServiceQuery val(java.lang.Number number)
number
- The numeric value to usepublic MobileServiceTable.MobileServiceQuery val(boolean val)
number
- The boolean value to usepublic MobileServiceTable.MobileServiceQuery val(java.lang.String s)
number
- The string value to usepublic MobileServiceTable.MobileServiceQuery and()
public MobileServiceTable.MobileServiceQuery and(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery or()
public MobileServiceTable.MobileServiceQuery or(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery not()
public MobileServiceTable.MobileServiceQuery not(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery not(boolean booleanValue)
booleanValue
- public MobileServiceTable.MobileServiceQuery ge()
public MobileServiceTable.MobileServiceQuery ge(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery ge(java.lang.Number numberValue)
numberValue
- public MobileServiceTable.MobileServiceQuery le()
public MobileServiceTable.MobileServiceQuery le(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery le(java.lang.Number numberValue)
otherQuery
- public MobileServiceTable.MobileServiceQuery gt()
public MobileServiceTable.MobileServiceQuery gt(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery gt(java.lang.Number numberValue)
numberValue
- public MobileServiceTable.MobileServiceQuery lt()
public MobileServiceTable.MobileServiceQuery lt(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery lt(java.lang.Number numberValue)
numberValue
- public MobileServiceTable.MobileServiceQuery eq()
public MobileServiceTable.MobileServiceQuery eq(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery eq(java.lang.Number numberValue)
numberValue
- public MobileServiceTable.MobileServiceQuery eq(boolean booleanValue)
booleanValue
- public MobileServiceTable.MobileServiceQuery eq(java.lang.String stringValue)
stringValue
- public MobileServiceTable.MobileServiceQuery neq()
public MobileServiceTable.MobileServiceQuery neq(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery neq(java.lang.Number numberValue)
numberValue
- public MobileServiceTable.MobileServiceQuery neq(boolean booleanValue)
booleanValue
- public MobileServiceTable.MobileServiceQuery neq(java.lang.String stringValue)
stringValue
- public MobileServiceTable.MobileServiceQuery add()
public MobileServiceTable.MobileServiceQuery add(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery sub()
public MobileServiceTable.MobileServiceQuery sub(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery mul()
public MobileServiceTable.MobileServiceQuery mul(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery div()
public MobileServiceTable.MobileServiceQuery div(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery mod()
public MobileServiceTable.MobileServiceQuery mod(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery year(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery month(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery day(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery hour(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery minute(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery second(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery floor(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery ceiling(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery round(MobileServiceTable.MobileServiceQuery otherQuery)
otherQuery
- public MobileServiceTable.MobileServiceQuery startsWith(MobileServiceTable.MobileServiceQuery field, MobileServiceTable.MobileServiceQuery start)
field
- The field to evaluatestart
- Start valuepublic MobileServiceTable.MobileServiceQuery endsWith(MobileServiceTable.MobileServiceQuery field, MobileServiceTable.MobileServiceQuery end)
field
- The field to evaluateend
- End valuepublic MobileServiceTable.MobileServiceQuery subStringOf(MobileServiceTable.MobileServiceQuery str1, MobileServiceTable.MobileServiceQuery str2)
str1
- First stringstr2
- Second stringpublic MobileServiceTable.MobileServiceQuery concat(MobileServiceTable.MobileServiceQuery str1, MobileServiceTable.MobileServiceQuery str2)
str1
- First stringstr2
- Second stringpublic MobileServiceTable.MobileServiceQuery indexOf(MobileServiceTable.MobileServiceQuery haystack, MobileServiceTable.MobileServiceQuery needle)
haystack
- String contentneedle
- Value to search forpublic MobileServiceTable.MobileServiceQuery substring(MobileServiceTable.MobileServiceQuery str, MobileServiceTable.MobileServiceQuery pos)
str
- String contentpos
- Starting positionpublic MobileServiceTable.MobileServiceQuery substring(MobileServiceTable.MobileServiceQuery str, MobileServiceTable.MobileServiceQuery pos, MobileServiceTable.MobileServiceQuery length)
str
- String contentpos
- Starting positionlength
- Lengthpublic MobileServiceTable.MobileServiceQuery replace(MobileServiceTable.MobileServiceQuery str, MobileServiceTable.MobileServiceQuery find, MobileServiceTable.MobileServiceQuery replace)
str
- String contentfind
- Search valuereplace
- Replace value