query by dateLastModified

Forum for users and developers of Bullhorn's API service.

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
hannahmotionmill
User
Posts: 2
Joined: Fri Nov 27, 2020 8:05 am

query by dateLastModified

Post by hannahmotionmill »

Hello,

I'm having some issues with a search query to my JobOrder enitity by the dateLastModified. In my query I have dateLastModified:[1605873430000 TO *], but it seems to return all JobOrders regardless of the value in dateLastModified. dateAdded:[1605873430000 TO *] gives the same issue

For example:

Code: Select all

[data] => Array
        (
            [0] => Array
                (
                    [dateLastModified] => 1556733925000
                    [id] => 15
                    [_score] => 1
                )

            [1] => Array
                (
                    [dateLastModified] => 1236960000000
                    [id] => 12
                    [_score] => 1
                )

            [2] => Array
                (
                    [dateLastModified] => 1242662400000
                    [id] => 11
                    [_score] => 1
                )

            [3] => Array
                (
                    [dateLastModified] => 1236787200000
                    [id] => 14
                    [_score] => 1
                )

            [4] => Array
                (
                    [dateLastModified] => 1294765200000
                    [id] => 13
                    [_score] => 1
                )

            [5] => Array
                (
                    [dateLastModified] => 1404371432000
                    [id] => 16
                    [_score] => 1
                )

            [6] => Array
                (
                    [dateLastModified] => 1230656400000
                    [id] => 17
                    [_score] => 1
                )

            [7] => Array
                (
                    [dateLastModified] => 1243267200000
                    [id] => 18
                    [_score] => 1
                )

            [8] => Array
                (
                    [dateLastModified] => 1572968325000
                    [id] => 19
                    [_score] => 1
                )

            [9] => Array
                (
                    [dateLastModified] => 1404205433000
                    [id] => 20
                    [_score] => 1
                )
When I try to query dateLastModified:1556733925000 (as you can see that's the value for the first JobOrder) it return nothing:

Code: Select all

[total] => 0
    [start] => 0
    [count] => 0
    [data] => Array
        (
        )
I can query on other custom fields like id:15, or others and I will get the correct jobOrder:

Code: Select all

[data] => Array
        (
            [0] => Array
                (
                    [dateLastModified] => 1556733925000
                    [id] => 15
                    [_score] => 1
                )

        )
Is there something I'm missing?
hannahmotionmill
User
Posts: 2
Joined: Fri Nov 27, 2020 8:05 am

Re: query by dateLastModified

Post by hannahmotionmill »

I switched from search to query and now it works
Post Reply