Hi Backendless Team.
I am using Load Grouped Table objects block to retrieve price date from db that is sorted by Product and then by store.
Each price entry has one product id and one store id through relation. When i try to retrieve prices for a list of products against list of stores, i get nicely grouped data, but sometimes i am not getting price info for some store, so then i compose new query to search again in the prices table, but for each store i did not find the price i use that stores alternative store list.
If in the first case query is simply:
products IN (‘stringified ļist of products’) AND store IN (‘stringified list of stores’)
then in 2 run, i could have different store lists that i check against so query is slightly different:
(products IN (‘stringified ļist of products’) AND store IN (‘stringified list of stores ABC’)) OR (products IN (‘stringified ļist of products’) AND store IN (‘stringified list of stores DEF’))
with this one initially it looks like alos nicely grouped data, but if i inspectindetails, i see 2 issues:
- I am getting empty item returned:
In initial search if i don’t find matching price i don’t have price item returned at atll, as expected, but here something is already not right.
then the 2nd issue: - while GroupedBy Product and Store id’s seems to be correct (at least the ones i would expect there:
The actual price Item is for product that should be grouped in other product group:
This is how the load grouped table object block looks like:
Initialy Group page size was set to 1 so that i would retrieve just one price item for each product, (i.e. not all the stores in list needed to return prices) but then noticed that empty item, and increased to investigate further.
And this is printed where clause for reference:
20:42:54.983 | PrintWhereClause | DEBUG | (product IN ('19D79B28-BF3B-4749-9BBC-700D22CD268A','60F23BB8-3575-4039-9F65-68C1CCDA12E3') AND store IN ('B98BB911-71F6-4D17-A18C-98B2EABDB2CC','C5EEA00F-9C81-4848-9334-6495B0125694','33634785-B73A-4BB1-A4FA-7B32CB4DC96C','74736BF9-D1DB-4EB2-97F7-1D6F50B2BA27','8771DA92-351F-4CA1-A4CE-D6145B59828C','B3BAD9E4-7943-4090-8448-A09730280A59','69DEF594-7CDA-4AAD-94DE-FBEC595B29CC','4C0BA96F-D3B9-47E0-AAB8-C46F774D6444','93E995FA-749E-4778-BD32-F2682ABBB0BB','6F3FBB4E-FC8A-463C-8D20-70D62CF03EF1','74CF1CB9-138E-4FB4-A847-EF05C0CA95CB','B2EFCD1D-C32D-44DB-B1EF-77054DE92373','CDB63403-B7C3-4434-87FC-28729D078B74','0E83AF07-00CE-48F2-A023-7C33C001A510','E970460D-D279-4AB0-BEAF-DDBDA36EDE74','BA5E4C31-DE3A-4AB7-A2D4-32BA801C3FB1','97D56048-FD2D-45DC-94D7-96C9014063DA','1D3A8CE5-0A4D-4287-A6B4-DAF17810573F','E74D029B-1688-4F3F-8C1A-8FCDE438C2FE','1CB0ECB8-867D-421B-A37C-113C67EF56F0','6D59C99F-AAA2-415C-B233-F53D91D733AA','F55EAE1B-04F4-4C83-B3D4-1698D24E8EBC','88909933-0FEA-4CB9-935D-101378F4C115','5A3BC318-BE3A-4DE6-AD29-62C976E2B19E')) OR (product IN ('19D79B28-BF3B-4749-9BBC-700D22CD268A','60F23BB8-3575-4039-9F65-68C1CCDA12E3') AND store IN ('6A704A84-D8A2-44A9-96CE-C97AEEAC627A','74736BF9-D1DB-4EB2-97F7-1D6F50B2BA27','33634785-B73A-4BB1-A4FA-7B32CB4DC96C','8771DA92-351F-4CA1-A4CE-D6145B59828C','C5EEA00F-9C81-4848-9334-6495B0125694','B3BAD9E4-7943-4090-8448-A09730280A59','4C0BA96F-D3B9-47E0-AAB8-C46F774D6444','69DEF594-7CDA-4AAD-94DE-FBEC595B29CC','93E995FA-749E-4778-BD32-F2682ABBB0BB','6F3FBB4E-FC8A-463C-8D20-70D62CF03EF1','74CF1CB9-138E-4FB4-A847-EF05C0CA95CB','B2EFCD1D-C32D-44DB-B1EF-77054DE92373','CDB63403-B7C3-4434-87FC-28729D078B74','0E83AF07-00CE-48F2-A023-7C33C001A510','E970460D-D279-4AB0-BEAF-DDBDA36EDE74','BA5E4C31-DE3A-4AB7-A2D4-32BA801C3FB1','97D56048-FD2D-45DC-94D7-96C9014063DA','1D3A8CE5-0A4D-4287-A6B4-DAF17810573F','E74D029B-1688-4F3F-8C1A-8FCDE438C2FE','1CB0ECB8-867D-421B-A37C-113C67EF56F0','6D59C99F-AAA2-415C-B233-F53D91D733AA','F55EAE1B-04F4-4C83-B3D4-1698D24E8EBC','88909933-0FEA-4CB9-935D-101378F4C115','5A3BC318-BE3A-4DE6-AD29-62C976E2B19E')) AND created > 1725561774983