Question: When I try to apply "not\_analyzed" into my ES mapping it doesnt work.

I am using this package for ES in Laravel - [Elasticquent](https://github.com/adamfairholm/Elasticquent)

My mapping looks like:

```
'ad_title' => [
            'type' => 'string',
            'analyzer' => 'standard'
        ],
        'ad_type' => [
            'type' => 'integer',
            'index' => 'not_analyzed'
        ],
        'ad_type' => [
            'type' => 'integer',
            'index' => 'not_analyzed'
        ],
        'ad_state' => [
            'type' => 'integer',
            'index' => 'not_analyzed'
        ],

```

Afterwards I do an API get call to view the mapping and it will output:

```
"testindex": {
        "mappings": {
            "ad_ad": {
                "properties": {
                    "ad_city": {
                        "type": "integer"
                    },
                    "ad_id": {
                        "type": "long"
                    },
                    "ad_state": {
                        "type": "integer"
                    },
                    "ad_title": {
                        "type": "string",
                        "analyzer": "standard"
                    },
                    "ad_type": {
                        "type": "integer"
                    },

```

Note that not\_analyzed is missing.
I cant see any errors/warnings in my logs either.

Answer: 
You can do this using a PIVOT in your query

```
SELECT name, 
       [1], 
       [2], 
       [3], 
       [4], 
       [5],
       [6],
       [7],
       [8],
       [9],
       [10],
       [11],
       [12],
       [13],
       [14],
       [15],
       [16],
       [17],
       [18],
       [19], 
       [20], 
       [21], 
       [22], 
       [23], 
       [24], 
       [25], 
       [26], 
       [27], 
       [28], 
       [29], 
       [30], 
       [31],
       ([1] + [2] + [3] + [4] + [5] + [6] + [7] + [8] + [9] + [10] + [11] + [12] + [13] + [14] + [15] + [16] + [17] + [18] + [19] +  [20] + [21] + [22] + [23] + [24] + [25] + [26] + [27] + [28] + [29] + [30] + [31]) as total
FROM   
(
    SELECT Name, 
        id, 
        Datepart(day, [date]) day 
    FROM   item 
    WHERE  MONTH([date]) = 2 AND YEAR([date]) = 2015
) x 
PIVOT 
(
    count(id) 
    FOR day IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], [17], [18], [19],  [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31]) 
) p 

```
```
select convert(varchar,PaymentDate,103) AS date,
       DatePart(MONTH,PaymentDate) as month,
       CAST(SUM(Total_Amount) as INT) as Revenue 
from Tbl_Name 
where YEAR(PaymentDate) = YEAR(CURRENT_TIMESTAMP)
  AND MONTH(PaymentDate) = MONTH(CURRENT_TIMESTAMP) 
GROUP BY convert(varchar,PaymentDate,103),
         DatePart(MONTH,PaymentDate) 
order by date;

```