Skip to main content
To homepage To homepage
Solved

ODX server - Filter rows based on substring of column

  • May 27, 2024
  • 1 reply
  • 48 views
G
Contributor

Hello,

 

I am using ODX server 20.10.47. I would like to limit the amount of records loaded by implementing following filtering rule on column [perakt] among others:

LEFT ([perakt],2) > 20

I am trying to achieve this in following way using “Filter Rows” options on data source but it does not work:


Also if i click OK and load the data, the 2 upper filters are not applied, just because the 3rd filter does not work.

Are there any ways of achieving this through “Filter rows” functionality? Or the only option is to create a custom query table?

Thank you!

Best answer by rory.smith

Hi @gediminas.juskenas ,

you cannot run SQL expressions in those filter fields. If you want to do something like that you would need to implement a query table that contains an extra column with the left and then filter on the result.

View original
Did this topic help you find an answer to your question?

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • May 27, 2024

Hi @gediminas.juskenas ,

you cannot run SQL expressions in those filter fields. If you want to do something like that you would need to implement a query table that contains an extra column with the left and then filter on the result.

daniel
1 person likes this
  • daniel
    daniel

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings