STRING LENGTH IN QUERY !

The 1C:Enterprise developers forum

#1
People who like this:1Yes/0No
Just came
Rating: 1
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 03:19 AM
 
#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 01:09 AM
 
#3
People who like this:1Yes/0No
Active user
Rating: 3
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)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.