GD
Gadget Developers•7mo ago
OllieEvans

Filter and sorting based off models relationship field?

I am essentially trying to build a table that has a combination of data from orders and orderlines. My issue however is filtering and sorting on fields from the orderline and fields from the order. Using the query below, as far as I'm aware I can only filter and sort on the top level orderLineItem fields and I cannot filter or sort on order fields? I've pulled these out into two separate queries, so I could filter and sort each and map the data back together again. However then I fall into pagination issues. I'm just wondering if I'm missing something obvious here please? I 'm considering using computed fields to add all the required order data to the orderline item but that seems messy and wrong. 
const [{data, fetching, error}, _refetch] = useFindMany(api.shopifyOrderLineItem, {
    select: {
      id: true,
      order: {
        id: true,
        name: true,
        shopifyCreatedAt: true,
        totalPriceSet: true,
        email: true,
        financialStatus: true,
      },
      fulfillmentStatus: true,
      currentQuantity: true,
      fulfillableQuantity: true,
    },
    filter: {
      sellingPlanGroupId: {
        isSet: true,
      },
    },
    sort: {
      order: {
        email: "Descending"
      }
    }
  });
const [{data, fetching, error}, _refetch] = useFindMany(api.shopifyOrderLineItem, {
    select: {
      id: true,
      order: {
        id: true,
        name: true,
        shopifyCreatedAt: true,
        totalPriceSet: true,
        email: true,
        financialStatus: true,
      },
      fulfillmentStatus: true,
      currentQuantity: true,
      fulfillableQuantity: true,
    },
    filter: {
      sellingPlanGroupId: {
        isSet: true,
      },
    },
    sort: {
      order: {
        email: "Descending"
      }
    }
  });
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?