Issue when querying items with name

Question

question

ycb asked May 17 2021 at 11:23 AM ycb commented May 18 2021 at 9:28 AM

Issue when querying items with name

Hi,
I use InventoryContact to load items like this:

Uri uri = InventoryContract.Item.contentUriWithAccount(CloverAccount.getAccount(getActivity()));
String where = "name LIKE '%coca%'"
CursorLoader loader = new CursorLoader(getActivity(), uri,
                            null, where, null, null);

it was working fine, but recently it crashes

Caused by: android.database.sqlite.SQLiteException: ambiguous column name: name (code 1): , while compiling: SELECT price_without_vat, item_menu_item.description AS menu_description, alternate_name, default_tax_rates, code, cost, taxable, item_group_uuid, hidden, count, uuid, unit_name, modified_time, item_menu_item.enabled AS menu_enabled, price, item_menu_item.name AS menu_name, item_menu_item.reason_code AS menu_reason_code, item.name AS name, price_type, item._id AS _id, sku, is_revenue, item_menu_item.image_filename AS menu_image_filename, color_code FROM item LEFT OUTER JOIN item_menu_item ON item.uuid=item_menu_item.item_uuid WHERE ((name LIKE '%coca%'))

do you have any fix for this?

Inventory

HTML Editor

Tab to the formatting toolbar with Alt/Option + F10. If inside toolbar, press ESC to return to editor. Hint: Notify or tag a user in this post by typing @username.

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Welcome to the
Clover Developer Community

Answer 1 · 2021-05-17T11:44:02Z

David Marginian answered May 17 2021 at 11:44 AM ycb commented May 18 2021 at 9:28 AM

Can you try updating your where to "item.name LIKE '%coca%'" for now and I will look into this in more detail.

1

Answer 2 · 2021-05-17T13:11:06Z

ycb answered May 17 2021 at 1:11 PM ycb commented May 17 2021 at 2:05 PM

yes, this works,
but it is not a good thing. to put static table name 'item'.

2

question