INPUT_OBJECT

OpptyProductRelationFilterInput

Filter conditions for OpptyProductRelation records. Conditions on different fields are combined with AND; use OR, AND and NOT for other combinations.

link GraphQL Schema definition

  • input OpptyProductRelationFilterInput {
  • # Matches records that meet at least one of the listed filters.
  • OR: [OpptyProductRelationFilterInput!]
  • # Matches records that meet all of the listed filters.
  • AND: [OpptyProductRelationFilterInput!]
  • # Matches records that do not meet this filter.
  • NOT: OpptyProductRelationFilterInput
  • # Search term matched against the fields that the global search covers for this
  • # entity.
  • globalSearchQuery: String
  • # Unique identifier of entity.
  • id: EntityFilterStringField
  • # Specifies if the entity is considered deleted.
  • isDeleted: Boolean
  • # Last modification time.
  • modified: EntityFilterDateTimeField
  • # Creation time.
  • created: EntityFilterDateTimeField
  • # Total amount of the line item (price * quantity, with discounts applied).
  • amount: EntityFilterNumberField
  • # Free-form note describing this line item.
  • comment: EntityFilterStringField
  • # Id of the currency exchange rate list used to convert this line item, inherited
  • # from the parent opportunity or quote.
  • currencyExchangeRatesListId: EntityFilterStringField
  • # Id of the online form field in which the respondent selected this product, or
  • # empty when the line item did not come from a form submission.
  • onlineFormFieldId: EntityFilterStringField
  • # Id of the online form submission this line item came from, or empty when it was
  • # not created through a form.
  • onlineFormId: EntityFilterStringField
  • # Id of the opportunity.
  • opptyId: EntityFilterStringField
  • # Id of the line-item type.
  • opptyProductRelationTypeId: EntityFilterStringField
  • # Id of the paired line item.
  • pairedOpptyProductRelationId: EntityFilterStringField
  • # Per-unit price of the line item. Defaults to the product price from the price
  • # list when not supplied explicitly.
  • price: EntityFilterNumberField
  • # Id of the product on this line item. Set on create; cannot be changed
  • # afterwards.
  • productId: EntityFilterStringField
  • # Number of product units on this line item.
  • quantity: EntityFilterNumberField
  • # Id of the quote this line item belongs to. Mutually exclusive with opptyId.
  • quoteId: EntityFilterStringField
  • # Identifier of the product section this line belongs to (see the productSections
  • # JSON layout on the parent opportunity or quote).
  • sectionId: EntityFilterStringField
  • # Display order of the line item within its section. Maintained automatically when
  • # lines are added or moved.
  • sortOrder: EntityFilterNumberField
  • # Revision when entity was lastly changed.
  • revision: EntityFilterNumberField
  • # Absolute monetary discount applied to this line item versus the price-list
  • # price. Read-only; computed by Coevera.
  • discountValue: Float
  • # Percentage discount applied to this line item versus the price-list price.
  • # Read-only; computed by Coevera.
  • discountPercentage: Float
  • # Conditions on custom fields, each identified by its api name. All listed
  • # conditions must match.
  • withCustom: [CustomField!]
  • # Currency exchange rate list used to convert this line item, inherited from the
  • # parent opportunity or quote. Matches records where a related record meets these
  • # conditions.
  • currencyExchangeRatesList: CurrencyExchangeRatesListFilterInput
  • # Online form field that produced this line item, or empty when not applicable.
  • # Matches records where a related record meets these conditions.
  • onlineFormField: FieldFilterInput
  • # Online form this line item came from when the related opportunity was created
  • # through a form submission, or empty otherwise. Matches records where a related
  • # record meets these conditions.
  • onlineForm: OnlineFormFilterInput
  • # Opportunity this line item belongs to. Set on create; mutually exclusive with
  • # quote. Matches records where a related record meets these conditions.
  • oppty: OpportunityFilterInput
  • # Line-item type that drives the form layout for this product line. Resolved from
  • # the product type on create. Matches records where a related record meets these
  • # conditions.
  • opptyProductRelationType: OpptyProductRelationTypeFilterInput
  • # Counterpart line item on the paired record (e.g. matching line on the active
  • # quote when this line is on the opportunity, or vice versa). Empty when there is
  • # no pairing. Matches records where a related record meets these conditions.
  • pairedOpptyProductRelation: OpptyProductRelationFilterInput
  • # Product on this line item. Set on create; cannot be changed afterwards. Matches
  • # records where a related record meets these conditions.
  • product: ProductFilterInput
  • # Quote this line item belongs to. Set on create; mutually exclusive with
  • # opportunity. Matches records where a related record meets these conditions.
  • quote: QuoteFilterInput
  • # Per-line revenue schedule splitting the line amount across periods. Available
  • # only when revenue scheduling is configured at product-amount level. Matches
  • # records where a related record meets these conditions.
  • revenueSchedule: OpptyProductRelationRevenueScheduleFilterInput
  • }