BSP file storage. Attached files. Benefits of the Attached File Management add-on

There are different opinions on this matter. There are undoubted pros and cons to one or the other option. There are also storage options in external databases and some others.

It all depends on whether you have a 1C programmer on your staff and how much money you are willing to invest in optimizing the performance of your information base.

However, if you think about it, the user must choose where and how the necessary files should be stored. For example, images for products are in the information base, since this provides the fastest access and opening of images. And various documents sent by e-mail are on disk, since the speed of access to them is not so critical, but sometimes their size is not small. However, you can decide on the need for one or another option yourself. This depends on various conditions and the best option is selected individually.

How to store and in what order is up to you. And we help realize additional opportunities in this matter.

This development allows you almost unlimited options for managing attached files.

Some time ago, one of the clients contacted us about the following problems with the UT 11 database: brakes began to be felt during operation, disk space “evaporated” quickly, the database increased significantly in volume in a fairly short period of time.

A small survey of the database showed that the main problem is the large volume of attached files. The client used a standard subsystem for working with e-mail, conducting intensive document flow in it, with many price lists, contracts and other auxiliary files. It was decided to add the possibility of distributed file storage. The range of files required for storage in the information base and “minor” files - the storage of which in the database is not critical - has been determined. Standard solutions do not allow such a distribution.

The result was tangible:

• database size decreased from 350 GB to 75 GB;
• working in the database has become more comfortable;
• the space on the system's fast disk has practically stopped shrinking;
• daily backups have decreased in size and are created faster.

In addition to the purely “visual” effect, there was also an economic one: the separation made it possible to use the “fast” system server disk more rationally, increasing its performance and service life without purchasing a more capacious one (which was initially proposed), and storing all “minor data” on a “regular” and much cheaper drive.

The presented development has a second edition and allows you to manage attached files using saved settings automatically, using a routine task.

To use processing Not required change the configuration.

Processing will work in any 1C 8.3 configuration, built on the basis of BSP 2 and having a built-in “Attached files” subsystem.

To test functionality on your database, it is recommended to first use the demo version.

Processing capabilities:

• Generating a report on the current position of attached files
• Creation of almost any number of selection settings
• Detailed settings down to one specific file
• Possibility of performing any selection in “manual mode”
• Ability to perform automatic distribution according to selected settings
• "Rollback" of changes made at any time (back to the database or to disk)

Usage.

Important! The processing is intended for use from the "Additional reports and processing" reference book.

1. The main processing form contains a settings table.

“User” is the user of the information base under which the settings made will be saved.

Each setting can be turned on and off directly in the table, with one click on the corresponding cell.

The "Report" button from the main form displays a report on the current status and position of attached files in the context of the owner's directory. Indicating the file size.

The "Perform processing" button moves files according to the table settings, with the "Use" checkbox enabled. Settings are processed in sequence according to the table; settings can be moved.

2. Clicking the add button opens a configuration form, according to which the files will be processed in the future.

2.1 Example of user settings:

This setting processes all email attachments for the user "Ivanov".

2.2 Example of settings by file type and size:

This setting is used to process attachments for customer complaints.

The files are moved to the directory on the disk specified in the "Storage volume" attribute.

3. Settings are made in the access control system implemented through the 1C Enterprise platform.

When setting up, you can limit the list of objects (directories) for which this setting is performed:

If the list is not indicated, then the setting is performed for all infobase objects containing attached files.

Important! To move volume files, this house must be previously or during the setup process created in the infobase!

4. Generating a report from a setting and processing files is performed ONLY in relation to this setting.

The report will show a selection of files according to the configured selection, and processing will move them according to the settings.

5. For processing, it is possible to create a routine task:

The scheduled task will automatically perform the movement according to the settings made and enabled at a time that is convenient for you.

Published processing versions:

Demonstration. This version is free and has the following limitations:

• Closed code
• Lack of technical support and version updates
• There is no functionality to move files

It is possible to generate reports and save settings.

Basic. This version comes with a minimum cost and has the following limitations:

• Closed code
• Lack of technical support (only version updates within 30 days after purchase)

Otherwise, there are no restrictions; the functionality corresponds to the “older” versions.

Versions Standard And Professional are open source, identical in functionality and differ only in extended support for the version Professional.

Purchasing additional technical support is only possible for those who have already purchased the development.

Purchasing additional technical support allows you to upgrade your current version. For example, purchasing technical support for those who purchased Basic version, allows you to convert to version Standard.

Extended technical support- assistance in installation and configuration upon request, implementation of additional requirements (customization) to the customer’s base according to requirements in an amount of no more than 12 working hours within a year after purchase.

Infostart LLC guarantees you a 100% refund if the program does not correspond to the declared functionality from the description. The money can be returned in full if you request this within 14 days from the date the money is received in our account.

The program has been so proven to work that we can give such a guarantee with complete confidence. We want all our customers to be satisfied with their purchase.

Instructions

If you need to attach a file to a letter composed using a program installed on your computer (for example, Outlook Express or The Bat), then everything is very simple. After writing the text of the message, drag the file onto the text of the letter - this is quite enough to attach it to the message. You will see an attached file icon - you can send an email with an attachment.

If you use a residential email client, you can attach an attachment in another way - after writing a message, click the corresponding button in the top row. When you hover your mouse over it, the “attach file” prompt pops up. A dialog box will open in which you need to select the file prepared for sending and click the “Open” button. The attached attachment icon, as in the first option, will appear in the body of the letter - the message with the attachment is ready to be sent.

And if you need to attach a file to a letter sent using any of the online mail services (for example, Mail.ru or Gmail.com), then you need to do this a little differently. After the text of the message is ready, you need to find the link to attach attachments to the letter. For example, in Gmail such a link is located below the field for entering the subject of the message, equipped with an image of a paperclip and the inscription “Attach file”. If you click it, an additional field will appear with a “Browse” button - click the button or this field itself and a window will open to select a file. Find the file you want to attach on your computer and click the “Open” button. If you have more than one file that should be sent with this letter, use the link to attach the next file. For example, in Gmail it appears below the file you just attached and says “Attach another file.” The steps to attach a second attachment (and, if necessary, a third, etc.) are no different from attaching the first. After the process of uploading files to the mail service server is completed, all you have to do is send a message.

Most of the most famous films are translated and provided only with a Russian soundtrack. However, if you want to watch a movie with original audio to learn a language or improve it, you can connect additional tracks to the video file using the appropriate software.

You will need

• - VLC Media Player

Instructions

First you need to find a suitable sound track. There are many foreign resources that have a corresponding database of various translations in the form of audio files in mp3, aac or ac3 format.

You don't have to add this track to a video file, and simply run a separate movie and a separate sound through two players. In the video window, it is enough to turn on silent mode, but it is unlikely that you will be able to achieve completely synchronous sound.

Some players have the corresponding functionality and allow you to add track directly into the movie, synchronizing the duration of audio and video. To do this, you can use VLC Media player, which must be downloaded from the developer’s official website.

Install the program and use it to open the film you need to translate. Right-click on the video file and select “File” - “Open with...” - “VLC”, or simply click on the created player shortcut on the desktop. Go to “Audio” - “Audio Track”. This menu displays translations attached to the video file.

Select “Media” - “Open file with parameters” or press the key combination Ctrl, Shift and O. In the window that opens, click on the “Add” button, specify the path to the movie file and click “Open”.

Highlight “Show advanced options”, and then “Play a media file in parallel”. Click "Browse" and in the pop-up window click the "Add" button again. If you need to add a subtitle file, then check the box next to “Use subtitle file”. Then click on the “Browse” button and specify the path to the downloaded subtitle file.srt. In the same way, specify the path to the audio track and press the “Play” button.

The audio track is attached. Go to the “Audio” - “Audio Tracks” tab, where select the second item that appears “Track 2”.

Sources:

• VLC Official Website
• like me audio tracks in the film

A database is a collection of data that is organized according to certain rules and is stored in the computer's memory. It characterizes the current state of a specific subject area.

You will need

• - computer;
• - server;
• - Sql database.

Instructions

Go to SQL Server Management Studio to connect base data, then go to Object Explorer and connect to an instance of MicrosoftSQL Server Database Engine, expand it. Call the context menu on the “Databases” node. Click on the "Attach" command.

Last time we added the ability to backup data to our configuration. In today's example, let's try to figure out how using the BSP you can easily organize the attachment of files to configuration objects. Agree, this problem arises very often in practice. Often a customer needs to save an image of a product in a database. Another common task would be to save scanned contracts or documents related to a particular counterparty. There can be quite a lot of tasks. Now we’ll see how to solve them.

First, let's create a directory to which we will attach an image or several. Let this be the directory “Yura_Counterparties” from the BSP demo database, copy the directory _DemoNomenclatureAttachedFiles and rename it to Yura_CounterpartiesAttachedFiles, after which we will create in the Directory Yura_Counterparties the attribute “Scanned Agreement” to which we will assign the type “Jura_CounterpartiesAttachedFiles”

Now we need to edit the general command Attached Files TO Object, we will indicate in the type of object parameters and our directory Yura_Counterparties.

After these steps, our directory element should look something like this

(pay attention to the “Go” item; you can read more about general commands in my article about the managed interface).

But if we try to attach any file, we will get an error. In order for it not to occur, we need to indicate our new directory Yura_CounterpartiesAttachedFiles in the “Attached Files” information register in the “Attached File” dimension type.

By the way, I almost forgot, the type of the “File Owner” attribute of the directory “Yura_CounterpartiesAttachedFiles” should be “Directory.Yura_Counterparties” as in the screenshot.

After all these manipulations, we will be able to attach any files in any quantities to our directory.

But let's also use the code with which you can select and display one of the attached files on the screen. To do this, we will use the “Scanned Contract” requisite. Let’s create a directory element form, add the “Picture Address” attribute to it and drag it onto the form, specifying “picture field” as the type.

To display a picture, we need one function, GetNavigationLinkImage, as well as code for the WhenCreatingOnServer and WhenReadingOnServer procedures.

The full listing looks like this:

& On the Server Without Context Function GetNavigationLinkPictures(PictureFile, FormIdentifier) ​​Return AttachedFiles. GetFileData(ImageFile, FormIdentifier) ​​. ReferenceFileBinaryData; EndFunction &OnServerProcedureWhenCreatingOnServer(Failure, StandardProcessing) If Not ValueFilled(Object.Ref) Then If Not Object. Scanned Contract. Empty() Then PictureAddress = GetPictureNavigationLink(Object. ScannedContract, UniqueIdentifier) ​​ElsePictureAddress = " " ; Endless; endIf; EndProcedure &OnServer Procedure WhenReadingOnServer(CurrentObject) If Not CurrentObject. Scanned Contract. Empty() Then ImageAddress = GetImageNavigationLink(CurrentObject. ScannedAgreement, UniqueIdentifier) ​​ElseImageAddress = " " ; Endless; End of Procedure & On Client Procedure Scanned Contract On Change (Element) If Not Object. Scanned Contract. Empty() Then PictureAddress = GetPictureNavigationLink(Object. ScannedContract, UniqueIdentifier) ​​ElsePictureAddress = " " ; Endless; EndProcedure & OnClient Procedure ScannedContractStartSelection(Element, SelectionData, StandardProcessing) StandardProcessing = False; AttachedFilesClient. OpenFileSelectionForm(Object. Link, Elements. Scanned Agreement) ; EndProcedure

As a result, we will be able to display one of the pictures attached to the directory on the form. Unfortunately, viewing of files of other formats is not yet possible. But if you visit “Attached files” and try to double-click to open them, the program responsible for

• Disadvantage of storing files in the 1C program database - the size of the database grows and it begins to work slower, which complicates the work.
• Disadvantage of storing files on a PC hard drive - files take longer to open for viewing, there is a possibility of losing individual files.

The question arises - how to eliminate the disadvantages of the first and second methods, while maintaining their advantages? The solution is to selectively store files in the database and on the hard drive.

Solution demonstration:

How does the "manage attached files" processing work?

The solution allows you to store files selectively on your hard drive or in the database:

• Files that are used frequently - will be saved in the database;
• Files that are rarely used will be saved on the hard drive.

Files are distributed automatically or manually using specified filters : file size, creation date, extension, file name and current storage location.

Benefits of the Attached File Management add-on

• No need to make changes to the 1C program
  Files are processed using an external tool, which eliminates difficulties during subsequent program updates
• Saving your or staff time

Setting up the add-on will take no more than 5 minutes, after which processing and distribution of files can occur automatically

• Wide selection of filters applied to files

You can configure the distribution of files by size, creation date, extension, name or current storage location.

• High speed of information base operation

Since only frequently opened files will now be stored in the database, this will free up space in it and allow it to work faster

• Quickly open “in demand” files

Any files saved in the database can be found and opened in a few seconds. Less current files will not be sent to the hard drive.

• Low price

Individual development with similar functions would cost at least 10 times more. You can buy a ready-made solution and save a lot!

Processing capabilities

"Manage attached files"

• Generating a report on the current position of attached files;
• Creating an impressive number of selection settings;
• Detailed settings down to one specific file;
• Possibility of distributing files in “manual mode”;
• Possibility of automatic distribution of files according to selected filters;
• The ability to “return” the necessary files back to the database or to disk.

Compatibility

Processing will work in any 1C 8.3 configuration, built on the basis of BSP 2 and having a built-in

subsystem “Attached files”. There is NO configuration change required to use processing.

To check the functionality of the add-on on your database,

test the demo version*!

*The free version is closed source and does not allow you to move files

How to use processing?

Important! The processing is intended for use from the "Additional reports and processing" reference book.

The main processing form contains indicators of the current status of attached files*:

* When opening processing for the first time, you must update the status information!

Indicators can be:

• Move randomly
• Arrange in a convenient sequence
• Delete if there is no need to display

The main settings form allows you to manage file processing settings:

Each setting can be turned on or off directly in the table, with one click on the corresponding cell. Settings table terminology:

"User" - infobase user under whom the settings will be saved.

“Report” button - displays a report on the current status and position of attached files, indicating the file size.

Button “Perform processing” - moves files according to the table settings, with the “Use” function enabled. Settings are processed according to the sequence in the table; settings can be moved.

The add button opens a configuration form according to which the files will be processed in the future.

Detailed settings instructions can be found here:

Differences between the paid and free versions

Free demo version allows you to generate reports and save settings, but has some limitations:

• closed code
• only 2 indicators about file status
• lack of technical support and version updates
• there is no functionality for moving files

"Professional" version is paid and has the following advantages:

• open source
• 6 months of updates
• 1 month technical support*.

*Technical support includes assistance in installing and configuring the add-on (if necessary), as well as implementing additional requirements individually for the customer’s base (no more than 12 working hours within a year after purchase).

At the end of the technical support period, it can be extended for a fee.

Results from one of our clients

after using the development

• The database size has decreased from 350 GB to 75 GB;
• Working in the database has become more comfortable;
• The space on the system's fast disk has practically stopped shrinking;
• Daily backups have decreased in size and are created faster.

In addition, our add-on helped the client save money: separation made it possible to use the system server disk more rationally, increasing its performance and service life without purchasing a more capacious disk (which was originally planned).

Try the free development version now

or order a full-fledged product “Manage attached files”

without limitation in possibilities!

Reasons to buy

The cost of development and support is much less than custom development.

All wishes are considered and implemented within the framework of support.

Advantages

The solution does not require any configuration changes.

Works out of the box.

Requires simple minimal setup.

Comparison of versions

The current version is not tied to BSP 2.2 or 2.4, it works in both.

Money back guarantee

Infostart LLC guarantees you a 100% refund if the program does not correspond to the declared functionality from the description. The money can be returned in full if you request this within 14 days from the date the money is received in our account.

The program has been so proven to work that we can give such a guarantee with complete confidence. We want all our customers to be satisfied with their purchase.

Below we will continue to analyze the subsystems in the BSP configuration.

A subsystem for storing, loading and conveniently organizing an enterprise's production calendar. The subsystem also allows you to obtain data such as the number of working days until a certain date, etc.

22. Contact information

A subsystem for storing and displaying contact information on directory forms. As a rule, it is used in directories: contractors, individuals, organizations, etc. The subsystem is connected to the “Address Classifier” subsystem.

23. Control of dynamic configuration updates

Designed to notify users about configuration changes. If the configuration is changed, it prompts you to restart the session at some intervals.

24. User reminders

The subsystem is designed to set personal reminders regarding any system object and notify the user at the appointed time.

25. Setting the order of elements

Designed to configure the order of directory elements or the Up and Down buttons in . If the object is subordinate, then the numbering of elements is carried out within the owner. If the directory is hierarchical, then the numbering of elements is performed within the parent.

26. Program settings

The “Program Settings” subsystem provides settings panels for all library subsystems located in the “Setup and Administration” section of the command interface.

27. Data exchange

The “Data Exchange” subsystem is designed to perform data exchange between different configurations using exchange rules and without using exchange rules, as well as to organize data exchange in a distributed information base. The exchange bears little resemblance to the previous version of the BSP. Data exchange is supported between configurations running in the service model, as well as between configurations running in the service model and in local mode. Rules, as usual, must be created in the “Data Conversion” configuration.

For the basics of setting up data exchange in 1C using the “1C Data Conversion” configuration, see the example in the video:

28. Messaging

The Messaging subsystem is designed to integrate heterogeneous information systems on the 1C:Enterprise platform through messaging. The subsystem should be used when the data link is unreliable. The subsystem is not a replacement for data exchange technology, web services technology and external connection. New functionality in BSP.

Get 267 video lessons on 1C for free:

29. Updating the information security version

Used in all standard solutions. Not much different from the previous version of the library of standard subsystems. “Updating the information security version” provides a program interface for executing handler procedures for initially filling and updating information base (IS) data when the configuration version changes, and also allows you to display a report on changes in the new configuration version.

30. Configuration update

The subsystem is designed to automatically configure the information base in 1C:Enterprise mode “on demand” or at a specified time in the future. We are talking about configurations. You can set up automatic configuration updates from your server.

31. Organizations

This reference is used in almost all configurations. It is very important that it be unified.

32. Sending SMS

The subsystem provides ready-made functionality for sending SMS messages using 1C tools. By default, the subsystem supports work with MTS and Beeline operators.

33.Performance evaluation

Designed for objective assessment of the integral performance of the system using the APDEX method. Using it, for example, you can find out how long it takes to process a certain document, and subsequently get statistics on the time.

34. Print

The subsystem is designed for printing layouts of spreadsheet documents and layouts of office documents (MS Word, OpenOffice).

35. Full text search

Designed to activate full-text search in the system. Contains a search interface and some routine operations for indexing text data.

36. Receiving files from the Internet

The “Receiving files from the Internet” subsystem adds a program interface to the configuration for receiving files from the Internet via HTTP, HTTPS and FTP protocols and saving the received files on the client, server or in temporary storage.

37. Users

The subsystem is designed to view and edit the list of users and external users of the system (elements of the Users and External Users directories), which are synchronized with the list of users of the information base.

38. Prefixation of objects

Designed for prefixing database objects. Prefixation of objects is carried out in the context of information bases and elements of the Organization directory.

39. Attached files

The Attached Files subsystem provides tools for working with attachment files attached to arbitrary information base objects of a reference type. File storage can be organized both in the information base and externally - in volumes (network resources).

40. Checking the legality of receiving updates

The “Checking the legality of receiving updates” subsystem allows you to request confirmation from the user that the update files were received legally. It can be used both before updating the infobase (after the update has already been applied to the database, but before the first launch), and immediately before updating the configuration using the “Configuration Update” subsystem.

41. Working with email messages

The “Working with email messages” subsystem adds to the configuration a program interface for sending email messages, as well as a user interface for supporting email accounts.

42. Working with files

The “Working with Files” subsystem is designed for collective editing of files of arbitrary format in a hierarchical folder structure. File storage can be organized either directly in the infobase or externally – in volumes (network resources). Along with the file, the history of its changes (file versions) can also be saved.

43. Distribution of reports

The “Report Distribution” subsystem allows you to configure the distribution of report options and reports from the “Additional reports and processing” subsystem. Mailings can be performed either on a schedule (if the program runs in client-server mode) or on demand.

44. Regular tasks

The “Routine tasks” subsystem allows you to edit the composition and schedule of routine tasks, view the history of execution of routine and background tasks, and also analyze errors during their execution. If the system is deployed in client-file mode, the administrator has the ability to configure the execution of routine tasks using the Configure processing of routine processing tasks Routine Tasks Console command.

45. Information security backup

The “IB Backup” subsystem allows you to back up the information base from the 1C Enterprise mode “on demand” or in accordance with a configured schedule. Also, using this subsystem, you can restore the information base from a backup copy.

46. ​​Properties

The “Properties” subsystem allows you to create and edit additional properties of arbitrary configuration objects in 1C:Enterprise mode. Objects with properties can be any objects of a reference type. The subsystem allows you to implement both one set of additional properties for all instances of objects of the same type, and several sets of properties for objects of the same type.

Additional properties of objects are divided into two categories:

● additional details;

● additional information.

47. Subordination structure

The “Subordination Structure” subsystem provides the ability to display a report on the parent and child documents of the current document, as well as their relationships, from the document form.

48. Access Control

The “Access Control” subsystem allows you to configure user rights for arbitrary information base data elements (elements of directories, documents, register entries, business processes, tasks, etc.). It is possible to restrict rights both for individual types of metadata objects and at the level of records of one object type. In addition, for individual infobase objects, it is possible to individually configure access rights, similar to operating system file folders.

49. Results management

The subsystem “Management of totals and aggregates” provides tools for administering totals and aggregates of information base registers. The subsystem allows you to perform both standard administrative operations and gives access to all the features:

● enable/disable the use of totals and aggregates;

● separation of results;

● setting the period and recalculating the results;

● rebuilding and updating of units;

● calculation of optimal units.

50. File functions

The “File Functions” subsystem has no independent application value. It includes general file functionality (functions, common forms, etc.) used by subsystems that depend on it (such as “Working with Files,” “Attached Files,” “Supplied Data”).

51. Individuals

The “Individuals” subsystem is designed to unify the names of metadata objects common to standard configurations. Contains only metadata object definitions and their basic implementation.

52. Electronic digital signature

1. Create a directory for storing attached files. To do this, copy the directory into the configuration as a template _DemoProjectsAttachedFiles from the demo configuration and give it a name using the template:

<Префикс>Attached Files,

Where<Префикс>– name of the metadata object for which attached files are configured. For example, for the Nomenclature directory, the directory with files should be called NomenclatureAttachedFiles. Set a synonym, for example: Attached files (Nomenclature).

2. At the props FileOwner set the type to “object with files”. For example, DirectoryLink.Nomenclature.

3. Include in defined types AttachedFile(links) and AttachedFileObject(objects) directory created in step 1. For example, DirectoryLink.NomenclatureAttachedFiles.

4. Expand the composition of defined types Owner of Attached Files(links) and OwnerAttachedFilesObject(objects other than documents) by adding the “object with files” type to it. For example, DirectoryLink.Nomenclature.

5. Expand the range of types of the Source property of the subscription Override the ResultingForm of the AttachedFile, including in it the type - directory with files created in step 1. For example, DirectoryManager.NomenclatureAttachedFiles.

6. Expand the types of the Subscription Source property Set Mark for Deleting Attached Files and Documents, including the type “object with files” (documents only). For example, DocumentObject.Invoice for Payment to Buyer.

7. If, when interactively copying an object containing attached files, you need to automatically copy them to a new object, then in the object form you must:

● add a key parameter to the form parameters Copy Value the same type as the object itself;

● in a form module into a procedure WhenRecordingOnServer paste the following code:

AttachedFiles.WhenRecordingOnServer(Failure, CurrentObject, RecordingParameters, Parameters);

Print (Ctrl+P)

In this article I describe a very interesting and simple change in the mechanism of attached files of the “Working with Files” subsystem of the library of standard subsystems, which I had to do to fulfill the employer’s technical specifications.

The attachment file mechanism provides the ability to store free-format files directly associated with data. For example, for Nomenclature, you can store a detailed description of the product, scanned instructions for using the product, or a photograph of it in the attached file. and for individuals, for example, you can store various types of documents.

The technical task was to be able to process various types of files attached to the Order document. For this purpose, in the employer configuration, written on the basis of BSP 2.4, I had to add the enumeration File Types , and in the directory OrderAttached Files – props File type type of listing file types (see Figure 1).

Fig 1 Directory details OrderAttachedFiles

To work with directories such as attached files like “ OrderAttachedFiles ” there are 2 forms of processing “Working with files” of the standard subsystem: Form Attached Files and shape AttachedFile (see Fig 2)

Fig. 2 Processing forms “Working with files” of the library of standard subsystems

However, in these two forms of processing WorkWithFiles it is not possible to work with added props File type directory OrderAttachedFiles and I had to make some small simple changes in these forms:

In the request body of a dynamic list form Attached Files I have added a line as shown in fig. 3

Fig 3 Request for a dynamic list in the Attached Files form

Then, at the end of the procedure body SetupDynamicList I added 3 lines of code:

&OnServer Procedure SetupDynamicList() // ....... procedure body // Sanchez If FileStorage DirectoryName= "OrderAttachedFiles" Then List.QueryText= strReplace( List.QueryText,"HOW EditsUser", "HOW EditsUser, | Files.FileType AS FileType"); endIf; EndProcedure

I also had to make changes to the form AttachedFile, so that it is possible to edit the added details File type. These changes are shown in Figure 4