ENUM

OrderTask_WhereGroup_Fields

Where group options for OrderTask. Matches when any field in the array is met

link GraphQL Schema definition

  • enum OrderTask_WhereGroup_Fields {
  • # Only return order tasks that have the shift date
  • shift_date
  • # Composite key of order, task and shift index to link to ffa_order_task (old
  • # table)
  • order_task_shift
  • # Unique order ID.
  • order_id
  • # The description of an order.
  • order_description
  • # Job number for an order.
  • order_job_number
  • # Unique task ID.
  • task_id
  • # Task name.
  • task_name
  • # Order type.
  • order_type
  • # Owner of the order that the order task is linked to
  • order_owner
  • # Status of the order the order task is linked to
  • order_status
  • # Status id of the order the order task is linked to
  • order_status_id
  • # Supplier of the order the order task is linked to
  • order_supplier
  • # tags of order the order task is linked to
  • order_tags
  • # if true, return only orderTasks that are linked to active order
  • only_active_orders
  • # Client of the order the order task is linked to
  • client_id
  • # Project of the order the order task is linked to
  • project_id
  • # True to get only orderTasks with a project linked to it's Order, False to get
  • # orderTasks with NO project linked to it's Order
  • has_project
  • # True to get only orderTasks with an active project linked to it's Order
  • has_active_project
  • # Returns order tasks when date is between order start and end date.
  • order_date
  • # Returns orderTasks that have order with a start_date less than or equal to given
  • # date, useful for range intersection
  • order_start_date_lte
  • # Returns orderTasks that have order with end_date greater than or equal to given
  • # date, useful for range intersection
  • order_end_date_gte
  • # Filters order tasks that have orders with an unfulfilled task date in given
  • # range. An unfulfilled task date that has allocated workers < qty OR if task
  • # asset required - allocated assets < 1
  • unfulfilled_in_range
  • }