# Regarding path.real **URL:** \ **Category:** Elasticsearch\ **Created:** [June 12, 2020, 8:53am UTC](https://discuss.elastic.co/t/regarding-path-real/236853 "2020-06-12T08:53:06Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![galvin1234](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@galvin1234](https://discuss.elastic.co/u/galvin1234)\ **Post date:** [June 12, 2020, 8:53am UTC](https://discuss.elastic.co/t/regarding-path-real/236853/1 "2020-06-12T08:53:06Z")
Hi I am using ElasticSearch and FSCrawler together. I have indexed a document directory with default of FSCrawler settings, no template applied no filter applied. simple standard configuration only. I have a simple query I want to search some text on documents but i would like retrieve result which match my criteria for fullFilePath i.e. UNC Path, I can see there is a property path.real, but that property is case sensitive. In my case i want path.real case insensitive. I am using windows environment. My object was to search some text only in specified/given file(s). filepath should be case insensitive. Feeing source.path.real or MyDoc.path.real is case sensitive, I am able to get result when filter matches with case sensitivity but the same below query didn't return result if filter is not matched with case sensitivity. I think it is executing the query first then it is assigning the value of MyDoc.path.real. overall my motto was either to search something in given file only or search something and then filter the fullfilepath as per my input, ``` var testResults = client.Search(selector => selector .Query(q => q .Bool(b => b .Should(s => s .Match(m => m .Field(f => f.content) .Query(query.ToLower()) //this is my local variable ) ) .Filter(fi => fi .Match(r => r .Field(f => f.path.real) .Query(fullFilePath.ToLower()) //this is my local variable ) ) ) ) ); ``` I am using NEST client, so i would prefer answer which compatible with NEST Client. Below if my default mapping for doing indexing on documents. {"MyDoc":{"mappings":{"dynamic\_templates":[{"raw\_as\_text":{"path\_match":"meta.raw.\*","mapping":{"fields":{"keyword":{"ignore\_above":256,"type":"keyword"}},"type":"text"}}}],"properties":{"attachment":{"type":"binary"},"attributes":{"properties":{"group":{"type":"keyword"},"owner":{"type":"keyword"},"permissions":{"type":"long"}}},"content":{"type":"text"},"file":{"properties":{"checksum":{"type":"keyword"},"content\_type":{"type":"keyword"},"created":{"type":"date","format":"dateOptionalTime"},"extension":{"type":"keyword"},"filename":{"type":"keyword","store":true},"filesize":{"type":"long"},"indexed\_chars":{"type":"long"},"indexing\_date":{"type":"date","format":"dateOptionalTime"},"last\_accessed":{"type":"date","format":"dateOptionalTime"},"last\_modified":{"type":"date","format":"dateOptionalTime"},"url":{"type":"keyword","index":false}}},"meta":{"properties":{"altitude":{"type":"text"},"author":{"type":"text"},"comments":{"type":"text"},"contributor":{"type":"text"},"coverage":{"type":"text"},"created":{"type":"date","format":"dateOptionalTime"},"creator\_tool":{"type":"keyword"},"date":{"type":"date","format":"dateOptionalTime"},"description":{"type":"text"},"format":{"type":"text"},"identifier":{"type":"text"},"keywords":{"type":"text"},"language":{"type":"keyword"},"latitude":{"type":"text"},"longitude":{"type":"text"},"metadata\_date":{"type":"date","format":"dateOptionalTime"},"modifier":{"type":"text"},"print\_date":{"type":"date","format":"dateOptionalTime"},"publisher":{"type":"text"},"rating":{"type":"byte"},"raw":{"properties":{"Content-Encoding":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Content-Type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Parsed-By":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"resourceName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"relation":{"type":"text"},"rights":{"type":"text"},"source":{"type":"text"},"title":{"type":"text"},"type":{"type":"text"}}},"path":{"properties":{"real":{"type":"keyword","fields":{"fulltext":{"type":"text"},"tree":{"type":"text","analyzer":"fscrawler\_path","fielddata":true}}},"root":{"type":"keyword"},"virtual":{"type":"keyword","fields":{"fulltext":{"type":"text"},"tree":{"type":"text","analyzer":"fscrawler\_path","fielddata":true}}}}}}}}} ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 12, 2020, 1:05pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/2 "2020-06-12T13:05:26Z")
`path.real` is indeed a `keyword`. If I'm not mistaken, at index time, 2 sub fields are generated: - `path.real.tree` - `path.real.fulltext` May be that could help you to solve your use case? Otherwise, you need to [change the mapping](https://fscrawler.readthedocs.io/en/latest/admin/fs/elasticsearch.html#creating-your-own-mapping-analyzers). ---
**Author:** ![galvin1234](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@galvin1234](https://discuss.elastic.co/u/galvin1234)\ **Post date:** [June 12, 2020, 2:53pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/3 "2020-06-12T14:53:56Z")
Yes path.real is keyword, by mapping itself we can identify it. but how to solve it. should I convert them to text ? I am new to ElasticSearch, so my question might be silly for you. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 12, 2020, 4:56pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/4 "2020-06-12T16:56:46Z")
I said that you can search within the 2 other fields I shared. That should work. ---
**Author:** ![galvin1234](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@galvin1234](https://discuss.elastic.co/u/galvin1234)\ **Post date:** [June 13, 2020, 11:06am UTC](https://discuss.elastic.co/t/regarding-path-real/236853/5 "2020-06-13T11:06:30Z")
Its my bad luck or my basic query....i am just a beginner.... I tried to modify my MyDoc class as below ``` public class MyDoc { public string content { get; set; } public ESPath path { get; set; } } public class ESPath { public string root { get; set; } public ESReal real { get; set; } } public class ESReal { public ESFields fields { get; set; } } public class ESFields { public string fulltext { get; set; } public ESTree tree { get; set; } } public class ESTree { public string analyzer { get; set; } public bool fielddata { get; set; } } ``` but it throws an exception while querying . Error : expected:'{', actual:'"\XYC\GT1\2091.pdf"', at offset:9406 I am sure somewhere i am making mistake, but i am not able to debug it, since i am MS guy and can understand only c# codes. I already tried to modify MyDoc class in various ways....but it only works when i declare reals as string.... Sorry to bother you but i am newbie. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 13, 2020, 12:28pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/6 "2020-06-13T12:28:40Z")
I'm not a C# dev so I'm afraid I can't help more without seeing pure elasticsearch queries. ---
**Author:** ![galvin1234](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@galvin1234](https://discuss.elastic.co/u/galvin1234)\ **Post date:** [June 13, 2020, 7:35pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/7 "2020-06-13T19:35:13Z")
Ok, Let me try in another way... I simply trying to search a text by GET api using fiddler... The response i am getting from fiddler is ```auto HTTP/1.1 200 OK content-type: application/json; charset=UTF-8 content-length: 2737 ``` ```auto { "took": 158, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 1, "relation": "eq" }, "max_score": 17.183006, "hits": [ { "_index": "mydoc", "_type": "_doc", "_id": "8c6d32b7c47f9b9c3c748069831c60da", "_score": 17.183006, "_source": { "content": "Free text search using ElasticSearch.\n", "meta": { "author": "abc, xyz", "date": "2020-06-09T10:35:00.000+00:00", "language": "en", "modifier": "abc, xyz", "publisher": "ABC", "created": "2020-06-09T10:34:00.000+00:00", "raw": { "date": "2020-06-09T04:35:00Z", "cp:revision": "1", "Total-Time": "1", "extended-properties:AppVersion": "16.0000", "meta:paragraph-count": "1", "meta:word-count": "7", "dc:creator": "abc, xyz", "extended-properties:Company": "ABC", "Word-Count": "7", "dcterms:created": "2020-06-09T04:34:00Z", "meta:line-count": "1", "dcterms:modified": "2020-06-09T04:35:00Z", "Last-Modified": "2020-06-09T04:35:00Z", "Last-Save-Date": "2020-06-09T04:35:00Z", "meta:character-count": "43", "Template": "Normal", "Line-Count": "1", "Paragraph-Count": "1", "meta:save-date": "2020-06-09T04:35:00Z", "meta:character-count-with-spaces": "49", "Application-Name": "Microsoft Office Word", "extended-properties:TotalTime": "1", "modified": "2020-06-09T04:35:00Z", "Content-Type": "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "X-Parsed-By": "org.apache.tika.parser.DefaultParser", "creator": "abc, xyz", "meta:author": "abc, xyz", "meta:creation-date": "2020-06-09T04:34:00Z", "extended-properties:Application": "Microsoft Office Word", "meta:last-author": "abc, xyz", "Creation-Date": "2020-06-09T04:34:00Z", "xmpTPg:NPages": "1", "resourceName": "ElasticSearch.docx", "Character-Count-With-Spaces": "49", "Last-Author": "abc, xyz", "Character Count": "43", "Page-Count": "1", "Revision-Number": "1", "Application-Version": "16.0000", "extended-properties:Template": "Normal", "extended-properties:DocSecurityString": "None", "Author": "äbc, xyz", "publisher": "ABC", "meta:page-count": "1", "dc:publisher": "ABC" } }, "file": { "extension": "docx", "content_type": "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "created": "2020-06-09T04:38:33.511+00:00", "last_modified": "2020-06-09T04:35:37.385+00:00", "last_accessed": "2020-06-09T04:38:33.511+00:00", "indexing_date": "2020-06-13T04:43:51.324+00:00", "filesize": 11451, "filename": "ElasticSearch.docx", "url": "file://\\\\ABC\\GTFiles\\ElasticSearchTests\\ElasticSearch.docx" }, "path": { "root": "d9754dc78afc186c778be87faffd22", "virtual": "/ElasticSearchTests/ElasticSearch.docx", "real": "\\\\ABC\\GTFiles\\ElasticSearchTests\\ElasticSearch.docx" }, "attributes": { "owner": "ABC\\axyz", "permissions": 0 } } } ] } } ``` Here i cannot see fulltext property.... what could be the reason... why fiddler is not show up the fulltext propery ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 13, 2020, 8:07pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/8 "2020-06-13T20:07:53Z")
It's not in the `_source` document but it's indexed. ---
**Author:** ![galvin1234](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@galvin1234](https://discuss.elastic.co/u/galvin1234)\ **Post date:** [June 13, 2020, 10:10pm UTC](https://discuss.elastic.co/t/regarding-path-real/236853/9 "2020-06-13T22:10:38Z")
Can you please give me an example In which I would like to search some text and wants results only for specified/filtered by filename along with full path without case sensitive. Suppose I indexed c:\abc directory with default mapping, and now I am trying to search some text which are available in file1 and file2 C:\abc\File1.txt C:\abc\File2.txt But I want to apply some criteria/filter/where clause by full path of filename so that it can only return result for File2. and it should not be case sensitive How would i do that using NEST client. ---
**Author:** ![galvin1234](https://avatars.discourse-cdn.com/v4/letter/g/c6cbf5/32.png) [@galvin1234](https://discuss.elastic.co/u/galvin1234)\ **Post date:** [June 15, 2020, 9:14am UTC](https://discuss.elastic.co/t/regarding-path-real/236853/10 "2020-06-15T09:14:36Z")
How to access path.real.fulltext this property using nest client ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 26, 2020, 8:59am UTC](https://discuss.elastic.co/t/regarding-path-real/236853/11 "2020-06-26T08:59:00Z")
> [@galvin1234](#): > > How to access path.real.fulltext You can run a search like: ```auto GET /_search?q=path.real.fulltext:file1 ``` > [@galvin1234](#): > > using nest client I don't know. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 24, 2020, 8:59am UTC](https://discuss.elastic.co/t/regarding-path-real/236853/12 "2020-07-24T08:59:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.