Where the attachment files are stored?

That is correct. If the documents are stored in an FTP server or on file shares, of course they need to be access differently. The information on where the documents are can be found in the edm_file_tab table, together with the edm_location_tab table.

Good luck!

Hi @Mathias Dahl 

I have a small question regarding this.
Yes we can get the FTP/Shared location path using edm_file_tab and edm_location_tab but is there a projection action/function that we can use to actually get the file as a base64 encoded text from this path.

Thanks,
Dananjaya Misso

No. You can only get the raw bytes. We have that in many projections.

Hi  @Mathias Dahl 

can you maybe name a few that we can use.

So far I found this →

/projection/v1/CreateAndImportDocument.svc/EdmFileSet(DocClass='QM_PRD_QD',DocNo='1009030',DocSheet='1',DocRev='A1',DocType='ORIGINAL',FileNo=1)/FileData

but for some reason I am getting the below error →
 

Thank you.
/Dananjaya Misso

What's your interpretation of the error message there?

Hi @Mathias Dahl,

I believe the reason was the user that I invoke the rest endpoint does not belong to a person group of the connected access template

 

Thanks,
Dananjaya Misso.​​​​​​

That could indeed be the case, thanks for reporting back!

What I was aiming for is that the message clearly says (in my view) that the user who try to download the document does not have View access. Why that is the case we cannot see without looking at the document you try to download. Only there will you see the real access for a certain user.

Was it the same user that created the document that tried to download it? If yes, then I would say there might be a bug in there.

As for what projections that can download a document, I suggest using the projection behind the document attachment section (DocumentHome in Apps 10 and DocReferenceObjectAttachmentHandling in IFS Cloud).

Let us know if you have any further questions.

Thanks!

Hello, 

please how can I find out which part_no has the attachment? Through Oracle SQL, because in Master Part → Parts I want to display how many attachments has certain part_no, but in edm_file_storage_tab I cant find part_no or any other relevant information, which can I connect with Parts module.

Thanks

DocMan Attachments to Objects is not File Data, so it is not stored in edm_file_storage_tab.

It is defined using a Combination of lu_name and Key_REF in DOC_REFERENCE_OBJECT

By filtering on lu_name = ‘PartCatalog’ (Master Part), the KeyRefs will tell you which Part any sort of document that is attached to a given Master Part.

when I filter in LU_NAME PartCatalog, there is only 3 part_no, but in IFS in module Parts there are hundreds of part_no, why?

There are several different part LUs in IFS. You can use the page information in IFS to learn which one is used in that page. You can also do a SELECT DISTINCT on the lu_name column to find them all.

Perhaps I misunderstood the question there. Just because there are many parts doesn't mean they all have a document connection. Only the connections you can see in the application will be listed in this table.

In Part Catalog table I have 15000 part_no ,but in DOC_REFERENCE_OBJECT under Lu_name Part_Catalog only 3. I want to add this CF, which is located in Mater Part → Parts. In debug console it says that MediaItemConnected has mandatory value false and I cant also find it in tatabase, there is no possibility to add this as CF?

​@Ed22 

> In Part Catalog table I have 15000 part_no ,but in DOC_REFERENCE_OBJECT under Lu_name Part_Catalog only 3.

That means that there are 3 part-document connections in the system. That is, three parts have one document each, or one part have three documents, or…

I don't know how to create a CF that shows if there is media (not the same as a "document" in IFS) connected to the part, but if you want to try doing it, you should not use doc_reference_object_tab, you need to use media_library_tab. Similar concept.

in media_library_tabl i cant find information if some part_no has some attachment or not

​@Ed22 

> in media_library_tabl i cant find information if some part_no has some attachment or not

You can, in the same way as in the DocReferenceObject example earlier. Use the LuName and KeyRef attributes.

​@Ed22 ,

I had a somewhat similar requirement. see if this provides you with any insights.

• Custom column attachments exist Yes/No

/Suresh Bandara

For example, when I want to use this API: IFSAPP.MEDIA_LIBRARY_API.Get_Library_Id_From_Key_Ref('PartCatalog', 'PART_NO=11111^') in InventoryPartInStock entity, but I have many PART_NO how can I set up properly?