Hi Team,
Have come across a glitch when using a UI Builder backendless table, if you use whereclause logic and then try use the search function you get errors as follow.
sdk.js:16 Uncaught (in promise) p: Where clause ‘(ownerId = ‘127A500D-4A03-4CD5-8AB3-F2E6EEB53DAA’) AND (Registration like ‘%Ford%’ or ID like ‘%Ford%’ or Odometer like ‘%Ford%’ or Make like ‘%Ford%’ or Model like ‘%Ford%’ or Year like ‘%Ford%’ or VIN like ‘%Ford%’ or Engine_Number like ‘%Ford%’ or Tare like ‘%Ford%’ or Tank_Capacity like ‘%Ford%’ or Service_Interval like ‘%Ford%’ or Service_Warning_Duration_in_KM like ‘%Ford%’ or Can Max Pedal like ‘%Ford%’ or Can Max RPM like ‘%Ford%’ or Can Max Speed like ‘%Ford%’ or Can Max Temp like ‘%Ford%’ or Instalment like ‘%Ford%’ or Depreciation like ‘%Ford%’ or Insurance_Premium like ‘%Ford%’ or Tracking like ‘%Ford%’ or Annual_License_Fee like ‘%Ford%’ or Fixed_Maintenance_Plan_Cost like ‘%Ford%’ or Fixed_Monthly_Sundry_Cost like ‘%Ford%’ or Warehouse like ‘%Ford%’ or Commission_Rate like ‘%Ford%’ or Ideal_Fuel_Consumption like ‘%Ford%’ or Ideal_Rate_Per_Km like ‘%Ford%’ or Ideal_Rate_Per_Tonne like ‘%Ford%’ or Maintenance_Plan_Rate_per_Km like ‘%Ford%’ or Monthly_Mileage_Target like ‘%Ford%’ or Monthly_Profit_Target like ‘%Ford%’ or Monthly_Tonnage_Target like ‘%Ford%’ or Payload_Override like ‘%Ford%’ or Price like ‘%Ford%’)’ is invalid
at k (https://victorrose.backendless.app/api/files/ui-builder/library/sdk/sdk.js:16:672307)
this is obviously just going through each of the table item properties however it return an invalid whereclause.
Is there a work around that you have come across.
Kind Regards,
Raymond