Filter by recoder type

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

Pages: 1

Dinh Hung	#1 People who like this:0 Yes/0 No Sep 05, 2014 01:51 AM
Just came Rating: 1 Joined: Sep 5, 2014 Company:	Hi everybody, I use Information Registers to store many Documents type, when I want to get the oldest record information of only one Document type. Please help me use parameter type or another method to solve it. Thanks

ivan avdonin

People who like this:0 Yes/0 No

Sep 05, 2014 02:06 AM

Active user

Rating: 7
Joined: Sep 26, 2012
Company: individual

You have dimension of Information Register with composite data type?
If so you can try use next condition at query

Code
WHERE NOT CAST(InformationRegister1.Document AS Document.Document1) IS NULL

If value of dimension is not of type Document.Document1 then expression CAST(InformationRegister1.Document AS Document.Document1) return null

Edited: ivan avdonin - Sep 05, 2014 05:39 AM

Timofey Bugaevsky

People who like this:0 Yes/0 No

Sep 05, 2014 05:40 AM

Timofey Bugaevsky

Guest

Joined:
Company:

The correct condition here is REFS

Code
WHERE InformationRegister1.Object REFS Document.Document1

Or better use the virtual table parameters, if possible.

Murat Yazlıyev

People who like this:0 Yes/0 No

Sep 05, 2014 05:40 AM

Interested

Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

Hi Dinh Hung,

In query try to use "Refs" function.

For example,

Code
Where InformationRegister1.Document Refs Document.ReceiptInvoice

Dinh Hung	#5 People who like this:0 Yes/0 No Sep 18, 2014 08:04 AM
Just came Rating: 1 Joined: Sep 5, 2014 Company:	Thanks everybody so much!

Pages: 1

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