Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > STRING LENGTH IN QUERY !

Forum

Search UsersRules
STRING LENGTH IN QUERY !
#1
Just came
Points:: 0
Joined:: May 25, 2017

Hi, how can I get the length of a string in Query, like in SQL (SELECT LEN ('2019-02'); ) ? Thanx.

Profile
#2
Just came
Points:: 0
Joined:: Jan 10, 2019

unfortunately, no way :( - only use the result of query and get it fr om the result...

but if you want to filter records by field length, you can use WHERE <field> LIKE "_____"  

use "_" symbol as many times as the length of the string

Profile
#3
Active user
Points:: 0
Joined:: Mar 10, 2017

Hi Onofras !

You can use your own global export functions in data composition templates queries.

Kind regards,
Alex

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.