Issue when querying items with name

Question

question

ycb asked May 17, '21 ycb commented May 18, '21

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

10 |2000

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 Deactivated answered May 17, '21 ycb commented May 18, '21

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

1

10 |2000

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

ycb commented · May 18, 2021 at 09:28 AM

the best workaround it to set projection like this :

String[] projection = {InventoryContract.Item._ID,InventoryContract.Item.UUID, InventoryContract.Item.NAME, InventoryContract.Item.ALTERNATE_NAME, InventoryContract.Item.CODE, InventoryContract.Item.COST, InventoryContract.Item.DEFAULT_TAX_RATES,InventoryContract.Item.HIDDEN, InventoryContract.Item.IS_REVENUE,InventoryContract.Item.ITEM_GROUP_UUID, InventoryContract.Item.MODIFIED_TIME, InventoryContract.Item.PRICE, InventoryContract.Item.PRICE_TYPE,
        InventoryContract.Item.PRICE_WITHOUT_VAT, InventoryContract.Item.SKU, InventoryContract.Item.UNIT_NAME};
Uri uri = InventoryContract.Item.contentUriWithAccount(CloverAccount.getAccount(getActivity()));
String where = "name LIKE '%coca%'";
CursorLoader loader = new CursorLoader(getContext(), uri,
        projection, where, null, null);

1 ·

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

ycb answered May 17, '21 ycb commented May 17, '21

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

2

10 |2000

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

David Marginian ♦♦ commented · May 17, 2021 at 01:18 PM

As you can see from the query, a join is being made on item_menu_item, which I assume is new. Because both item_menu_item and item have a "name" column your where clause is resulting in an ambigous query. I am not sure if this is something we recently changed or what but if it is we shouldn't be breaking backwards compat, however, I am not sure what our options are in this case. I am checking with the team that made this change to get more information.

1 ·

ycb David Marginian ♦♦ commented · May 17, 2021 at 02:05 PM

ok, please notify me here when there is news about the issue.

0 ·

question