Problem
Attachments in Quotes can increase the size of a database which may impair performance. Overtime, you may want to delete attachments to quotes, but based on certain criteria.
Solution
The scripts attached will delete attachments in quotes:
...
| View file |
|---|
| name | Delete Document Binary Based Converted to Sales Order - QO_Documents.sql |
|---|
| height | 250 |
|---|
|
Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | J7UG |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ("document","quotes","attachments") and type = "page" and space = "J7UG" |
|---|
| labels | Document attachments Quotes |
|---|
|
...