For some projects it is interesting to store all data including files to the database so we can run such instances in docker and share the database. This way it would be possible to store the data in the business repo, even as we seen in https://answers.axonivy.com/questions/1779/how-can-i-persist-a-file-as-blob it is not always efficient. But we would not need to index the base64 conent of the file in elastic. Is it possible?

asked 24.09 at 02:58

adamf's gravatar image

adamf
1113614
accept rate: 25%

edited 24.09 at 05:02


There are ways that elasticsearch does not index some fields, but they are still in the source and go over the wire and are saved in the elastic search. So there is nothing at the moment which does really exclude some fields form the json which goes to the elasticsearch.

For me the easiest way would be if you store the files in our own table in the database and just reference it form the BusinessData.

link

answered 24.09 at 04:14

Christian%20Strebel's gravatar image

Christian St... ♦
3.2k21236
accept rate: 89%

you could define if a field should be indexed or not: https://www.elastic.co/guide/en/elasticsearch/reference/current/enabled.html

as a semi solution ;)

link

answered 24.09 at 04:09

skilchenmann's gravatar image

skilchenmann
1418819
accept rate: 33%

Yes but they are still in the source json and so also stored by elastic search...

(24.09 at 04:14) Christian St... ♦ Christian%20Strebel's gravatar image

Thank you for the answers. I have a similar Impression that we should use the database persistence https://developer.axonivy.com/doc/7.0.11/DesignerGuideHtml/ivy.datamodeling.html#ivy-persistence for the document and create a DocumentService that get a path from elastic and return the blob from the database. And that would be similar to existing solutions using the disk as storage.

(24.09 at 04:57) adamf adamf's gravatar image

I strongly recommend to not store files in business data. It was never intended for it!

(25.09 at 14:24) Alex Suter ♦♦ Alex%20Suter's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×30
×19
×17
×14
×7

Asked: 24.09 at 02:58

Seen: 93 times

Last updated: 25.09 at 14:24