SQL Queries

[mpmnu]

Hello,

I try to use an SQL query to export all the Information of recently closed tickets. To prevent exporting those already exported, I added a boolean to the article DB which should be set as soon as an article is exported and then used to filter the export. Is there a way to do this inside of the SQL Box or do i need to use some other way of adressing the database?

Greets

mpmnu

[crythias]

For your protection, you cannot make changes to data via the SQL box (essentially, DESCRIBE and SELECT are your primary allowed verbs)

[jojo]

you should not change the table structures provided.

The best woud be to cache or save the last ticket ID in your application