Enter your Sandbox.rev3 query:


Ask questions like:

SELECT journey_asset.name, journey_stageasset.score FROM journey_asset LEFT OUTER JOIN journey_stageasset ON journey_asset.current_stage_asset_id = journey_stageasset.id WHERE journey_asset.deleted_at IS NULL AND journey_asset.journey_id = 8 AND NOT journey_asset.is_average AND journey_asset.is_active ORDER BY journey_stageasset.score DESC, journey_asset.id ASC LIMIT 3;
{'action': 'check-email', 'target': 'columns', 'column': 'B'}
{'action': 'focus', 'target': 'ribbon'}
SELECT journey_asset.name, journey_stageasset.score FROM journey_asset LEFT OUTER JOIN journey_stageasset ON journey_asset.current_stage_asset_id = journey_stageasset.id WHERE journey_asset.deleted_at IS NULL AND journey_asset.journey_id = 5 AND NOT journey_asset.is_average AND journey_asset.is_active ORDER BY journey_stageasset.score DESC, journey_asset.id ASC LIMIT 1;
SELECT DISTINCT ON (journey_stage.position) journey_asset.name AS asset_name, journey_stage.name AS phase_name, journey_stage.position + 1 AS phase_number, journey_stageasset.score FROM journey_asset LEFT OUTER JOIN journey_stageasset ON journey_asset.current_stage_asset_id = journey_stageasset.id LEFT OUTER JOIN journey_stage ON journey_stageasset.stage_id = journey_stage.id WHERE journey_asset.deleted_at IS NULL AND journey_asset.is_active AND NOT journey_asset.is_average AND journey_asset.journey_id = 12 ORDER BY journey_stage.position ASC, journey_stageasset.score ASC, journey_asset.id ASC;