Forum

Filter by recoder type

Dinh Hung	#1 Sep 05, 2014 01:51 AM
Just came Points:: 0 Joined:: Sep 5, 2014	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
	Profile

Sep 05, 2014 02:06 AM

Active user

Points:: 0
Joined:: Sep 26, 2012

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

Profile

Sep 05, 2014 05:40 AM

Guest

Points::
Joined::

The correct condition here is REFS

Code
WHERE InformationRegister1.Object REFS Document.Document1

Or better use the virtual table parameters, if possible.

Profile

Sep 05, 2014 05:40 AM

Interested

Points:: 0
Joined:: Apr 5, 2012

Hi Dinh Hung,

In query try to use "Refs" function.

For example,

Code
Where InformationRegister1.Document Refs Document.ReceiptInvoice

Profile

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