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

FIWARE.Question.Tech.Filter by attribute value in Orion Context Broker SQL Style - "Attribute" LIKE '%text%'.

        Details

          Description

          Created question in FIWARE Q/A platform on 20-04-2018 at 07:04
          Please, ANSWER this question AT https://stackoverflow.com/questions/49934753/filter-by-attribute-value-in-orion-context-broker-sql-style-attribute-like

          Question:
          Filter by attribute value in Orion Context Broker SQL Style - "Attribute" LIKE '%text%'

          Description:
          Following NGSIv2 specification document is there any way to search entities by part of attribute string value?

          Something like
          http://192.168.36.95:1026/v2/entities?type=POI&options=keyValues&q=Description=='PART OF TEXT'
          to get entities that Description attribute contains 'PART OF TEXT'

            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
            		6h 1 Backlog Manager 20/Apr/18 3:05 PM
            In Progress In Progress Answered Answered
            		2h 59m 1 Backlog Manager 20/Apr/18 6:05 PM
            Answered Answered Closed Closed
            		2h 59m 1 Backlog Manager 20/Apr/18 9:05 PM
            fla Fernando Lopez made changes -
            Fix Version/s 2021 [ 12600 ]
            veronika Veronika Vlnkova made changes -
            HD-Enabler Orion [ 10875 ]
            backlogmanager Backlog Manager made changes -
            Summary [fiware-stackoverflow] Filter by attribute value in Orion Context Broker SQL Style - "Attribute" LIKE '%text%' FIWARE.Question.Tech.Filter by attribute value in Orion Context Broker SQL Style - "Attribute" LIKE '%text%'.
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2018-04-20 21:05|UPDATED status: transition Finish| # answers= 2, accepted answer= True

            Show
            backlogmanager Backlog Manager added a comment - 2018-04-20 21:05|UPDATED status: transition Finish| # answers= 2, accepted answer= True
            backlogmanager Backlog Manager made changes -
            Resolution Done [ 10000 ]
            Status Answered [ 10104 ] Closed [ 6 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2018-04-20 18:05|UPDATED status: transition Answered| # answers= 2, accepted answer= False

            Show
            backlogmanager Backlog Manager added a comment - 2018-04-20 18:05|UPDATED status: transition Answered| # answers= 2, accepted answer= False
            backlogmanager Backlog Manager made changes -
            Status In Progress [ 3 ] Answered [ 10104 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2018-04-20 15:05|UPDATED status: transition Answer| # answers= 2, accepted answer= False

            Show
            backlogmanager Backlog Manager added a comment - 2018-04-20 15:05|UPDATED status: transition Answer| # answers= 2, accepted answer= False
            backlogmanager Backlog Manager made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            veronika Veronika Vlnkova made changes -
            Assignee Jose Manuel Cantera [ jmcantera ]
            backlogmanager Backlog Manager made changes -
            Field Original Value New Value
            Component/s FIWARE-TECH-HELP [ 10278 ]
            Hide
            Permalink
            backlogmanager Backlog Manager added a comment -

            2018-04-20 09:05|CREATED monitor | # answers= 0, accepted answer= False

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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: