STRING LENGTH IN QUERY !



The 1C:Enterprise developers forum

#1
People who like this:1Yes/0No
Active user
Rating: 2
Joined: May 25, 2017
Company: Smart ID Dynamics

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

Edited: Onofras Ioan - Feb 19, 2019 01:19 PM
 
#2
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Jan 10, 2019
Company: 1c developer

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

Edited: Alex Aster - Feb 20, 2019 11:09 AM
 
#3
People who like this:1Yes/0No
Active user
Rating: 4
Joined: Mar 10, 2017
Company: Rufinor

Hi Onofras !

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

Kind regards,
Alex

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