My Products
Help
kashyap
PARTNER

How to get customer group name

by kashyap

Customer/Actor have customerPriceGroup1 and customerPriceGroup2.  We could not found in which table its relate it.


query GetCustomers($companyNo: Int = 4611115, $pageSize: Int = 10, $after: String) {
  useCompany(no: $companyNo) {
    associate(
      first: $pageSize
      after: $after
      filter: {
        createdDateTime: {_gte: "2023-01-01T10:00:00"},
        customerNo:{
          _gt: 0
        }
      }
    ) {
      totalCount
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      items {
        companyNo
        associateNo
        customerNo
        name
        addressLine1
        addressLine2
        addressLine3
        addressLine4
        postCode
        postalArea
        emailAddress
        phone
        mobilePhone
        privatePhone
        countryNo
        customerPriceGroup1
        country: joinup_Country {
          name
        }
        creditLimit
        creditDenied
        createdDate
        createdTime
        createdDateTime
      }
    }
  }
}

 

3 REPLIES 3
omelhus
PARTNER

by omelhus

These are text types in the text table. Check https://model.vbnxt.rocks/Associate#content to easily find what text type the different columns reference.

 

IMG_0024.jpeg

 

 

 

kashyap
PARTNER

by kashyap

This we know, but how we can joinup with Txt table?

omelhus
PARTNER

by omelhus

You can’t. You need two queries and stitch it afterwards.

 

I’ve suggested that Visma add a separate helper using data loader for this, but it did not get any traction.