Transaction: 3qbWm8u...92Ad

{ "function_name": "feed_test", "code": "", "schema": "CREATE VIEW\n moderated_posts as\nSELECT\n *\nFROM\n dataplatform_near_social_feed.posts p\nWHERE\n NOT EXISTS (\n SELECT\n *\n FROM\n dataplatform_near_moderation.moderation_decisions d\n WHERE\n p.account_id = d.moderated_account_id\n AND (\n d.moderated_path IS NULL\n OR (\n d.moderated_path = '/post/main'\n AND d.moderated_blockheight = p.block_height\n )\n )\n );\n\nCREATE VIEW\n moderated_comments as\nSELECT\n *\nFROM\n dataplatform_near_social_feed.comments p\nWHERE\n NOT EXISTS (\n SELECT\n *\n FROM\n dataplatform_near_moderation.moderation_decisions d\n WHERE\n p.account_id = d.moderated_account_id\n AND (\n d.moderated_path IS NULL\n OR (\n d.moderated_path = '/post/comment'\n AND d.moderated_blockheight = p.block_height\n )\n )\n );\n", "start_block_height": null, "filter_json": "{\"indexer_rule_kind\":\"Action\",\"matching_rule\":{\"rule\":\"ACTION_ANY\",\"affected_account_id\":\"social.near\",\"status\":\"SUCCESS\"}}" }