NazarenkoDenis

VAR l_from_variant_name = convert(regexp_match(order_items.variant_name, '\d{2,4}'), INT)
VAR l_from_props = convert(case( 
	not(is_empty(json_path(order_items.properties, "#(name=""Custom Length"").value"))), json_path(order_items.properties, "#(name=""Custom Length"").value"),
	not(is_empty(json_path(order_items.properties, "#(name=""Wunschlänge"").value"))), json_path(order_items.properties, "#(name=""Wunschlänge"").value"),
	not(is_empty(json_path(order_items.properties, "#(name=""Longueur sur mesure"").value"))), json_path(order_items.properties, "#(name=""Longueur sur mesure"").value"),
	not(is_empty(json_path(order_items.properties, "#(name=""Aangepaste lengte"").value"))), json_path(order_items.properties, "#(name=""Aangepaste lengte"").value"),
	not(is_empty(json_path(order_items.properties, "#(name=""Expédié après"").value"))), json_path(order_items.properties, "#(name=""Expédié après"").value"),
    not(is_empty(json_path(order_items.properties, "#(name=""Anpassad längd"").value"))), json_path(orde

NazarenkoDenis

{
  "tables": [
    {
      "lineageID": "07ac8872-abfa-4638-b419-2e20b6e366d6",
      "name": "order_events",
      "expression": "",
      "label": "",
      "isHidden": false,
      "columns": [
        {

NazarenkoDenis

{
	"tables": [
		{
			"lineageID": "a68424b6-219b-3c06-b476-18f3e53c7128",
			"columns": [
				{
					"lineageID": "d0f9a019-5cc9-496b-b439-4646641e5e4b",
					"name": "proper_first_name",
					"kind": "dimension",
					"dataType": "",

NazarenkoDenis

{"users":[{"id":101603246364,"first_name":"Denis","email":"den@omegacommerce.com","url":null,"im":null,"screen_name":null,"phone":null,"last_name":"Nazarenko","account_owner":true,"receive_announcements":1,"bio":null,"permissions":["applications","beacons","billing_application_charges","channels","content","content_entries_delete","content_entries_edit","content_entries_view","content_models_delete","content_models_edit","content_models_view","create_store_credit_account_transactions","custom_pixels_management","custom_pixels_view","customers","dashboard","delete_products","domains","draft_orders","create_and_edit_draft_orders","apply_discounts_to_draft_orders","mark_draft_orders_as_paid","set_payment_terms_for_draft_orders","delete_draft_orders","edit_orders","edit_private_apps","edit_product_cost","edit_product_price","edit_theme_code","gift_cards","links","locations","manage_delivery_settings","manage_inventory","manage_policies","manage_product_tags","manage_products","manage_store_credit_settings","manag

NazarenkoDenis

{
  "id": "57c5047e-0e3b-40ba-96b6-629a9fc58774",
  "title": "Orders Detail (Customized)",
  "group": "My Reports",
  "description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.",
  "tags": [
    "Orders",
    "Detailed"
  ],
  "hiddenFields": [],

NazarenkoDenis

{
	"explores": [
		{
			"lineageID": "1fe426dd-c1f3-3d7c-af6b-22b233fa9aa4",
			"relationships": [
				{
					"lineageID": "627512d3-b1fe-4024-a548-ebedcecd6258",
					"from": "fulfillment_items.order_id",
					"to": "orders.id"
				}

NazarenkoDenis

{
  "id": "da269037-f62f-4836-b17d-597aedd7b655",
  "title": "Orders Detail (Original Currency)",
  "group": "Orders",
  "description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.",
  "tags": [
    "Orders",
    "Detailed"
  ],
  "hiddenFields": [],

NazarenkoDenis

{
  "tables": [
    {
      "lineageID": "1f371d31-9c9b-35a7-aa8b-a58ee77911a0",
      "columns": [
        {
          "lineageID": "4a6c4bed-37b8-40de-92c0-448e93acc389",
          "name": "total_shipping_amount_presentment",
          "kind": "measure",
          "dataType": "",

NazarenkoDenis

{
  "id": "009400b7-e20e-41ad-a0ba-c0f3eee75cb8",
  "title": "pxq v4",
  "group": "My Reports",
  "description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.",
  "tags": [
    "Orders",
    "Detailed"
  ],
  "hiddenFields": [

NazarenkoDenis

{
  "id": "009400b7-e20e-41ad-a0ba-c0f3eee75cb8",
  "title": "pxq v4",
  "group": "My Reports",
  "description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.",
  "tags": [
    "Orders",
    "Detailed"
  ],
  "hiddenFields": [