Filter output result different when string value given with and without single quotes | Adobe Higher Education
Skip to main content
G
Greeshma_Sampath1
Level 4
September 29, 2021
Beantwortet

Filter output result different when string value given with and without single quotes

  • September 29, 2021
  • 3 Antworten
  • 1803 Ansichten

Hi All,

In one of the schema I tried to use filter with a string field.

For example let the field be @PriorCY_PPDon.

When creating a query: @PriorCY_PPDon >= '3', Some values are ignored and when using @PriorCY_PPDon >= 3 all values correctly coming.

What can be the issue or is it something inbuild for adobe. 

Could someone please help me understand what is causing this issue?

 

Thanks & Regards,

Greeshma

 

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von DebTr

Hi @greeshma_sampath1 ,

It is due to SQL not ACC. The comparison operator will return different result based on the data type of operand used in your case. That's why, when you pass '3' you are getting a different result than 3.

 

If you want a proper numeric comparison, then the field shall be numeric one or you can write some expression to cast the values if you are sure about the possible values.

 

Cheers,

Deb

3 Antworten

D
DebTrAntwort
Level 6
September 29, 2021

Hi @greeshma_sampath1 ,

It is due to SQL not ACC. The comparison operator will return different result based on the data type of operand used in your case. That's why, when you pass '3' you are getting a different result than 3.

 

If you want a proper numeric comparison, then the field shall be numeric one or you can write some expression to cast the values if you are sure about the possible values.

 

Cheers,

Deb

    G
    Greeshma_Sampath1Autor
    Level 4
    October 1, 2021

    Thank you @debtr for your suggestion.

    M
    minakshis868318
    Level 2
    September 30, 2021

    Hi @greeshma_sampath1,

    It depends on the data type of the field on which you are doing this operation. Incase you are sure about the values/ any queries result then i would suggest you can convert your field to appropriate data type through enrichment activity & get the expected comparison values.

      G
      Greeshma_Sampath1Autor
      Level 4
      October 1, 2021

      Thank you @minakshis868318  for your suggestion.

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      October 13, 2021

      Hi @greeshma_sampath1,

      Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know.
      Thanks!

      Sukrity Wadhwa
      Allgemeine NutzungsbedingungenAccessibility statement

      Loading footer...