I’m getting Exception of “Invalid Where Clause” in Saving and Retrieving Data from Table (“Offer_Details”).
I’m using “Admin_Email” Column as WhereClause in My Query.
Admin_Email is the Email of Current_User.
// METHOD FOR GETTING TABLE RECORDS
public void GET_DATA()
{ //INITIALIZING GETTER, SETTER CLASSS Offer_Details offer_details = new Offer_Details();
Progress_Dialog.SHOW_DIALOG(getActivity(), “PLEASE WAIT ! GETTING YOUR OFFERS…”);
String email = null;
BackendlessUser user = Backendless.UserService.CurrentUser(); if( user != null ) { email = user.getEmail(); }
WhereClause = "Admin_Email = " + email;
BackendlessDataQuery query = new BackendlessDataQuery();
query.setWhereClause(WhereClause);
offer_details.findAsync(query, new AsyncCallback<BackendlessCollection<Offer_Details>>() {
@Override
public void handleResponse(BackendlessCollection<Offer_Details> collection) {
Details_Array = new ArrayList<Offer_Details>();
for (Offer_Details details : collection.getData()) {
Details_Array.add(details);
}
Progress_Dialog.CANCEL_DIALOG();
adapter = new Posted_Offers_Adapter(getActivity(), Details_Array);
list.setAdapter(adapter);
}
@Override
public void handleFault(BackendlessFault backendlessFault)
{
Progress_Dialog.CANCEL_DIALOG();
Toast.makeText(getActivity(), String.valueOf(backendlessFault), Toast.LENGTH_LONG).show();
}
});
}
// GETTER, SETTER CLASS
import com.backendless.Backendless;
import com.backendless.BackendlessCollection;
import com.backendless.BackendlessUser;
import com.backendless.async.callback.AsyncCallback;
import com.backendless.geo.GeoPoint;
import com.backendless.persistence.BackendlessDataQuery;
public class Offer_Details
{
private Integer Floor_Number;
private Boolean Under_Review;
private java.util.Date Offer_Start_Date;
private String Offer_Title;
private String Market_Name;
private String Admin_Email;
private Integer DisCount_Price;
private Boolean Published;
private java.util.Date Offer_End_Date;
private String Offer_Description;
private String Shop_Name;
private Integer Shop_Number;
private java.util.Date updated;
private String ownerId;
private String Store_Image_Path_B;
private String Store_Image_Path_A;
private Integer Actual_Price;
private String Shop_Address;
private String objectId;
private String Store_Image_Path_C;
private java.util.Date created;
public Integer getFloor_Number()
{
return Floor_Number;
}
public void setFloor_Number( Integer Floor_Number )
{
this.Floor_Number = Floor_Number;
}
public Boolean getUnder_Review()
{
return Under_Review;
}
public void setUnder_Review( Boolean Under_Review )
{
this.Under_Review = Under_Review;
}
public java.util.Date getOffer_Start_Date()
{
return Offer_Start_Date;
}
public void setOffer_Start_Date( java.util.Date Offer_Start_Date )
{
this.Offer_Start_Date = Offer_Start_Date;
}
public String getOffer_Title()
{
return Offer_Title;
}
public void setOffer_Title( String Offer_Title )
{
this.Offer_Title = Offer_Title;
}
public String getMarket_Name()
{
return Market_Name;
}
public void setMarket_Name( String Market_Name )
{
this.Market_Name = Market_Name;
}
public String getAdmin_Email()
{
return Admin_Email;
}
public void setAdmin_Email( String Admin_Email )
{
this.Admin_Email = Admin_Email;
}
public Integer getDisCount_Price()
{
return DisCount_Price;
}
public void setDisCount_Price( Integer DisCount_Price )
{
this.DisCount_Price = DisCount_Price;
}
public Boolean getPublished()
{
return Published;
}
public void setPublished( Boolean Published )
{
this.Published = Published;
}
public java.util.Date getOffer_End_Date()
{
return Offer_End_Date;
}
public void setOffer_End_Date( java.util.Date Offer_End_Date )
{
this.Offer_End_Date = Offer_End_Date;
}
public String getOffer_Description()
{
return Offer_Description;
}
public void setOffer_Description( String Offer_Description )
{
this.Offer_Description = Offer_Description;
}
public String getShop_Name()
{
return Shop_Name;
}
public void setShop_Name( String Shop_Name )
{
this.Shop_Name = Shop_Name;
}
public Integer getShop_Number()
{
return Shop_Number;
}
public void setShop_Number( Integer Shop_Number )
{
this.Shop_Number = Shop_Number;
}
public java.util.Date getUpdated()
{
return updated;
}
public String getOwnerId()
{
return ownerId;
}
public String getStore_Image_Path_B()
{
return Store_Image_Path_B;
}
public void setStore_Image_Path_B( String Store_Image_Path_B )
{
this.Store_Image_Path_B = Store_Image_Path_B;
}
public String getStore_Image_Path_A()
{
return Store_Image_Path_A;
}
public void setStore_Image_Path_A( String Store_Image_Path_A )
{
this.Store_Image_Path_A = Store_Image_Path_A;
}
public Integer getActual_Price()
{
return Actual_Price;
}
public void setActual_Price( Integer Actual_Price )
{
this.Actual_Price = Actual_Price;
}
public String getShop_Address()
{
return Shop_Address;
}
public void setShop_Address( String Shop_Address )
{
this.Shop_Address = Shop_Address;
}
public String getObjectId()
{
return objectId;
}
public String getStore_Image_Path_C()
{
return Store_Image_Path_C;
}
public void setStore_Image_Path_C( String Store_Image_Path_C )
{
this.Store_Image_Path_C = Store_Image_Path_C;
}
public java.util.Date getCreated()
{
return created;
}
public Offer_Details save()
{
return Backendless.Data.of( Offer_Details.class ).save( this );
}
public void saveAsync( AsyncCallback<Offer_Details> callback )
{
Backendless.Data.of( Offer_Details.class ).save( this, callback );
}
public Long remove()
{
return Backendless.Data.of( Offer_Details.class ).remove( this );
}
public void removeAsync( AsyncCallback<Long> callback )
{
Backendless.Data.of( Offer_Details.class ).remove( this, callback );
}
public static Offer_Details findById( String id )
{
return Backendless.Data.of( Offer_Details.class ).findById( id );
}
public static void findByIdAsync( String id, AsyncCallback<Offer_Details> callback )
{
Backendless.Data.of( Offer_Details.class ).findById( id, callback );
}
public static Offer_Details findFirst()
{
return Backendless.Data.of( Offer_Details.class ).findFirst();
}
public static void findFirstAsync( AsyncCallback<Offer_Details> callback )
{
Backendless.Data.of( Offer_Details.class ).findFirst( callback );
}
public static Offer_Details findLast()
{
return Backendless.Data.of( Offer_Details.class ).findLast();
}
public static void findLastAsync( AsyncCallback<Offer_Details> callback )
{
Backendless.Data.of( Offer_Details.class ).findLast( callback );
}
public static BackendlessCollection<Offer_Details> find( BackendlessDataQuery query )
{
return Backendless.Data.of( Offer_Details.class ).find( query );
}
public static void findAsync( BackendlessDataQuery query, AsyncCallback<BackendlessCollection<Offer_Details>> callback )
{
Backendless.Data.of( Offer_Details.class ).find( query, callback );
}
}