1C:Query language and DCS

Common questions about 1C:Query language, Query builder tool and Data composition schema

Topics Posts Views Last Post
StickyUseful information

Author: Timofey Bugaevsky

0 4105 Oct 26, 2012 12:00 PM

Author: Timofey Bugaevsky

MovedDCS Template - Information Register

Author: Mesut Kahraman

0 0  
MovedCreating a custom query

Author: Mesut Kahraman

0 0  
MovedAdding parameter to query

Author: Mesut Kahraman

0 0  
DocumentForm -> Report parameter "Ref"

Author: Kris Lipiński

1 1249 Jul 30, 2019 05:52 PM

Author: Sergey Simonenkov

ExternalDataSource - Cannot call SP

Author: Sebastian Dan

4 950 May 27, 2019 03:59 AM

Author: Vladimir Gurov

Create a new line number

Author: Anh Bui

2 1713 Sep 10, 2018 11:47 PM

Author: Alexey Gerasimov

Edit Interfaces Text error

Author: Ali Khalil

1 2049 May 28, 2018 03:08 AM

Author: Vladimir Gurov

how to use UUID("00000000-0000-0000-0000-000000000000") in query under where

Author: Mehmet Tuğrul SARIÇİÇEK

17 11383 Feb 27, 2018 10:08 PM

Author: Alexey Gerasimov

select getdate() in DataCompositionScheme query

Author: Kris Lipiński

5 3022 Jan 24, 2017 12:39 AM

Author: Anton Chikov

Query builder ambiguous field problem

Author: Alexey Gerasimov

13 2091 Aug 18, 2016 02:23 PM

Author: Alexey Gerasimov

"Select" problems

Author: Sebastian Dan

2 2083 Jun 30, 2016 02:16 AM

Author: Sebastian Dan

DCS Calculated fields calculation order

Author: Alexey Gerasimov

1 2105 Dec 09, 2015 01:54 AM

Author: Timofey Bugaevsky

Explicit lock of scheduled jobs

Author: Aurimas Fišeras

6 5389 Dec 12, 2014 03:51 AM

Author: Aurimas Fišeras

Filter by recoder type

Author: Dinh Hung

4 3839 Sep 18, 2014 08:04 AM

Author: Dinh Hung

How can I change UserSettings by script in Report

Author: Murat Yazlıyev

4 3887 Sep 16, 2014 01:37 AM

Author: ivan avdonin

Necessary to set "Array" in ExtDimensions parameters of Virtual Table Parameters property

Author: Murat Yazlıyev

2 2669 Sep 02, 2014 10:44 PM

Author: Timofey Bugaevsky

Trim value in sql

Author: Dinh Hung

4 4062 Jun 04, 2014 10:03 PM

Author: Dinh Hung

The parameter list in the report

Author: Veli Bıçakçı

3 2785 May 13, 2014 06:16 AM

Author: Timofey Bugaevsky

Display report details

Author: Yuliya Davlyatshina

0 3063 Apr 22, 2014 08:33 PM

Author: Yuliya Davlyatshina

Manage User Filter,ConditionalAppear, Group, Field Restrictions By Script

Author: Murat Yazlıyev

5 3214 Apr 08, 2014 06:49 AM

Author: Timofey Bugaevsky

Grouping by recorder

Author: Mikhail Ivanenko

3 3884 Mar 20, 2014 12:12 AM

Author: Timofey Bugaevsky

Request To Add Shortcut Keys on Query Builder

Author: Murat Yazlıyev

3 4047 Feb 06, 2014 01:04 AM

Author: Timofey Bugaevsky

DCS global functions are not triggered and appear error

Author: Murat Yazlıyev

4 3367 Jan 10, 2014 04:23 AM

Author: Timofey Bugaevsky

add a sum function under specific field on a report

Author: mohammad maleh

1 3382 Nov 29, 2013 01:19 AM

Author: Timofey Bugaevsky

Methods StrReplace, Left, Right in query

Author: Murat Yazlıyev

2 3742 Jun 24, 2013 01:41 AM

Author: Murat Yazlıyev

Obtaining DataCompositionSchema Result

Author: Murat Yazlıyev

3 3678 May 22, 2013 01:58 PM

Author: Murat Yazlıyev

List of dates between two dates

Author: Murat Yazlıyev

2 4323 Apr 19, 2013 12:22 PM

Author: Timofey Bugaevsky

Logo on report form

Author: Roshan Ashok

2 3794 Apr 15, 2013 12:45 PM

Author: Samuel Harris

Default period in past

Author: Roshan Ashok

1 3700 Apr 10, 2013 08:50 PM

Author: ivan avdonin

TempTableManager

Author: Murat Yazlıyev

4 3944 Apr 08, 2013 10:02 AM

Author: Timofey Bugaevsky

Wrong parameters "+"

Author: Felicia McKenzie

4 3675 Apr 05, 2013 12:59 PM

Author: Xin Wang

Expand values as columns

Author: Simon Foster

6 3637 Mar 26, 2013 03:10 PM

Author: Aleksey Bochkov

Empty report

Author: Simon Foster

2 3430 Mar 21, 2013 02:44 PM

Author: Simon Foster

Process string in DCS report

Author: Stephanie Elliott

3 4823 Feb 25, 2013 05:02 PM

Author: Stephanie Elliott

Change DataComposition appearance for printing

Author: Alexey Gerasimov

6 3069 Feb 20, 2013 09:45 AM

Author: Timofey Bugaevsky

Can not use Period attribute in Data composition schema!

Author: Lies Susann

2 3209 Jan 18, 2013 11:43 AM

Author: Lies Susann

Optional filter in query

Author: Yi Gang

5 4048 Dec 26, 2012 11:34 AM

Author: Aleksey Bochkov

A query to join only one record even if there are more of them

Author: Silvia Ashley

4 4052 Dec 11, 2012 11:47 AM

Author: Silvia Ashley

new messages no new messages
Be the first to know tips & trick 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.