question

RitaPrajapati-4485 avatar image
0 Votes"
RitaPrajapati-4485 asked RitaPrajapati-4485 commented

Azure search blob storage field mapping

how can I search the datetime data from the blob storage, and show all of them as facet navigation .I am using the template github code from Azure search knowledge mining.

azure-blob-storageazure-cognitive-search
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@RitaPrajapati-4485 Thanks for asking question! Could you please confirm which datetime do you want to use? Is this a datetime in custom metadata or datetime of the file change date?
Let us know to help you better on this.

0 Votes 0 ·

Hi SnehaAgrawal, this is the datetimeoffset field I am trying to map in the blob index field. I have some files in the blob storage in container and those files have some datetime like 09/10/2021 or Novemver 5th 2021. I want to extract all those dates as facet

0 Votes 0 ·

1 Answer

SnehaAgrawal-MSFT avatar image
0 Votes"
SnehaAgrawal-MSFT answered RitaPrajapati-4485 commented

As its mentioned here that Standard blob metadata properties can be extracted into the fields as below: The blob indexer automatically creates internal field mappings for these blob metadata properties. You still have to add the fields you want to use the index definition, but you can omit creating field mappings in the indexer.

Use metadata_storage_last_modified (Edm.DateTimeOffset) and make it filterable and facetable: last modified timestamp for the blob. Azure Cognitive Search uses this timestamp to identify changed blobs, to avoid reindexing everything after the initial indexing.

hope this helps, let us know.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi SnehaAgrawal-MSFT , sorry for the confusion, I am trying to extract the datetime data inside the content in the files, not the last modified date of the files, is it possible to get the datetime information from inside the contents. like we can filter all people , organizations in content as facet , I want to be able to get all the dates in the content as facet

Thanks for you response

0 Votes 0 ·

If the timestamp is contained in the file, you would need to create a custom skill to parse the text and output this datetime.
This set of example custom skills might help.

https://github.com/Azure-Samples/azure-search-power-skills/tree/main/Text

Let us know.


0 Votes 0 ·

Thank you so much. let me try custom skill

0 Votes 0 ·