Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-15708

[fiware-stackoverflow] Fiware Orion string query

        Details

          Description

          Created question in FIWARE Q/A platform on 16-04-2019 at 12:04
          Please, ANSWER this question AT https://stackoverflow.com/questions/55705683/fiware-orion-string-query

          Question:
          Fiware Orion string query

          Description:
          I have a question regarding queries, I am working on Fiware Orion instance where the date is stored as a string:

          "date": {
          "type": "String",
          "value": "2019-01-02T00:00:00.0000Z",
          "metadata": {}
          }

          I have checked documentation about queries ( most interest in < > )

          This operation is only valid for target properties of type date, number or string (used with target properties of other types may lead to unpredictable results).

          But it is not possible for me to for example to use this query:

          q=date<2020-04-13T00:00:00.0000Z
          q=date<2020-04-13

          My question is this possible if it is then what I am doing wrong here. If not then I will have to find an alternative way of getting this query to work.

          Thanks.

            Activity

            Descending order - Click to sort in ascending order
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Open In Progress In Progress
            		7d 17h 51m 1 Fernando Lopez 24/Apr/19 8:57 AM
            In Progress In Progress Answered Answered
            		2s 1 Fernando Lopez 24/Apr/19 8:57 AM
            Answered Answered Closed Closed
            		2s 1 Fernando Lopez 24/Apr/19 8:57 AM
            fla Fernando Lopez made changes -
            Fix Version/s 2021 [ 12600 ]
            fla Fernando Lopez made changes -
            Resolution Done [ 10000 ]
            Status Answered [ 10104 ] Closed [ 6 ]
            fla Fernando Lopez made changes -
            Status In Progress [ 3 ] Answered [ 10104 ]
            fla Fernando Lopez made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            fla Fernando Lopez made changes -
            HD-Enabler Orion [ 10875 ]
            Description
            Created question in FIWARE Q/A platform on 16-04-2019 at 12:04
            {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/55705683/fiware-orion-string-query


            +Question:+
            Fiware Orion string query

            +Description:+
            I have a question regarding queries, I am working on Fiware Orion instance where the date is stored as a string:

            "date": {
                    "type": "String",
                    "value": "2019-01-02T00:00:00.0000Z",
                    "metadata": {}
                }


            I have checked documentation about queries ( most interest in &lt; > )


              This operation is only valid for target properties of type date, number or string (used with target properties of other types may lead to unpredictable results).


            But it is not possible for me to for example to use this query:

            q=date&lt;2020-04-13T00:00:00.0000Z
            q=date&lt;2020-04-13


            My question is this possible if it is then what I am doing wrong here. If not then I will have to find an alternative way of getting this query to work.

            Thanks.
            		 Created question in FIWARE Q/A platform on 16-04-2019 at 12:04
            {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/55705683/fiware-orion-string-query


            +Question:+
            Fiware Orion string query

            +Description:+
            I have a question regarding queries, I am working on Fiware Orion instance where the date is stored as a string:

            "date": {
                    "type": "String",
                    "value": "2019-01-02T00:00:00.0000Z",
                    "metadata": {}
                }


            I have checked documentation about queries ( most interest in &lt; > )


              This operation is only valid for target properties of type date, number or string (used with target properties of other types may lead to unpredictable results).


            But it is not possible for me to for example to use this query:

            q=date&lt;2020-04-13T00:00:00.0000Z
            q=date&lt;2020-04-13


            My question is this possible if it is then what I am doing wrong here. If not then I will have to find an alternative way of getting this query to work.

            Thanks.
            fla Fernando Lopez made changes -
            Assignee Backlog Manager [ backlogmanager ]
            backlogmanager Backlog Manager made changes -
            Field Original Value New Value
            Component/s FIWARE-TECH-HELP [ 10278 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2019-04-16 15:05|CREATED monitor | # answers= 0, accepted answer= False

            Show
            backlogmanager Backlog Manager added a comment - 2019-04-16 15:05|CREATED monitor | # answers= 0, accepted answer= False
            backlogmanager Backlog Manager created issue -

              People

              • Assignee:
                backlogmanager Backlog Manager
                Reporter:
                backlogmanager Backlog Manager
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: