dbeaver / dbeaver/dbeaver

Export task with filename pattern ${title} not working

Open
#23,190 2 comments 0 reactions 0 assignees View on GitHub
xf:datatransfer xf:sql editor
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

I have a task that do export from a few query. The export csv filename is not as expected.

Each query is base on a CTE statement and some left join. I expected the export csv will use the base table for ${table}, which is not the case and I got something like `_WITH_contact_AS_SELECT_FROM_SELECT_ROW_NUMBER_OVER_PARTITION_BY_`. After some issue and stackoverflow post look up, I find out that ${title} maybe a solution for me.

My problem is after I add `-- title: contact` as the top of my query, the ${title} will result in empty string in the file name. Am I using it correctly? Does it matter if I do the export via a Task or Script ?
```
-- title: contact
WITH contact AS (
SELECT * FROM
(
SELECT *
...
```

![image](https://github.com/dbeaver/dbeaver/assets/29765078/62bec997-0ddf-4fc5-a196-3aae5d65e94e)

Ref:
https://github.com/dbeaver/dbeaver/issues/16893
https://github.com/dbeaver/dbeaver/issues/8033
https://github.com/dbeaver/dbeaver/pull/16990
https://github.com/dbeaver/dbeaver/issues/2407

### DBeaver Version

Community Edition Version 24.0.0.202403091004

### Operating System

Windows 10 Enterprise

### Database and driver

Driver name: Trino

### Steps to reproduce

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.