LEFT COLUMN

QAtesting

Custom Fields

ALL CFT Test

Custom Field Test

datamanager

getcedata

getCEdataView

MAIN COLUMN

getCEdataView

Base Site > QAtesting > getCEdataView

RebuildView

element: qaTestRecords

queryType: selected

itemValue:

field: intListFLD

delim: ,

Records: 1

data

Array

Struct

DATEADDED

string

2014-02-21 23:05:47

DATEAPPROVED

string

2014-02-21 23:05:47

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4708

VALUES

Struct

from

string

intidFLD

string

4707

intListFLD

string

intListPipeFLD

string

testFileUpload

string

title

string

Test 13

uuidFLD

string

AC7B8F6C-6993-409C-808975D40435A882

itemValue:

field: intListPipeFLD

delim: |

Records: 1

data

Array

Struct

DATEADDED

string

2014-02-21 23:05:47

DATEAPPROVED

string

2014-02-21 23:05:47

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4708

VALUES

Struct

from

string

intidFLD

string

4707

intListFLD

string

intListPipeFLD

string

testFileUpload

string

title

string

Test 13

uuidFLD

string

AC7B8F6C-6993-409C-808975D40435A882

Records: 15

dataALL (all)

Array
Rows: 15

Struct

DATEADDED

string

2014-02-21 14:30:30

DATEAPPROVED

string

2016-02-23 16:24:02

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4676

VALUES

Struct

from

string

intidFLD

string

4675

intListFLD

string

1,2,3,4,44,33,11,22,8,88

intListPipeFLD

string

1|2|3|4|44|33|11|22|8|88

testFileUpload

string

What is Magic Briefcase3.pdf

title

string

1Test 1

uuidFLD

string

B7024739-0E3A-4563-A4D23A11CD6A6BB4

Struct

DATEADDED

string

2014-02-21 14:30:56

DATEAPPROVED

string

2014-02-21 14:30:56

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4678

VALUES

Struct

from

string

intidFLD

string

4677

intListFLD

string

4,44

intListPipeFLD

string

4|44

testFileUpload

string

title

string

Test 2

uuidFLD

string

EF3A873B-B18D-48C0-A133393E11CB9820

Struct

DATEADDED

string

2014-02-21 14:32:39

DATEAPPROVED

string

2014-02-21 14:32:39

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4681

VALUES

Struct

from

string

intidFLD

string

4680

intListFLD

string

1,2,3,4

intListPipeFLD

string

1|2|3|4

testFileUpload

string

title

string

Test 3

uuidFLD

string

4120F604-4E3F-4840-B075462FBA9A71EC

Struct

DATEADDED

string

2014-02-21 14:33:19

DATEAPPROVED

string

2014-02-21 14:33:19

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4683

VALUES

Struct

from

string

intidFLD

string

4682

intListFLD

string

44,33,11,22,88

intListPipeFLD

string

44|33|11|22|88

testFileUpload

string

title

string

Test 4

uuidFLD

string

810BAC43-1902-4E03-8E8E9BE34B9FDA47

Struct

DATEADDED

string

2014-02-21 14:33:40

DATEAPPROVED

string

2014-02-21 14:33:40

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4685

VALUES

Struct

from

string

intidFLD

string

4684

intListFLD

string

intListPipeFLD

string

testFileUpload

string

title

string

Test 5

uuidFLD

string

4D510E3F-CD0F-4EC4-9CAFDCAE1FA4DA11

Struct

DATEADDED

string

2014-02-21 14:34:09

DATEAPPROVED

string

2014-02-21 14:34:09

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4687

VALUES

Struct

from

string

intidFLD

string

4686

intListFLD

string

1,2,8,128

intListPipeFLD

string

1|2|8|128

testFileUpload

string

title

string

Test 6

uuidFLD

string

4C789175-B5E7-4B3B-B9A4C72998912E17

Struct

DATEADDED

string

2014-02-21 14:34:50

DATEAPPROVED

string

2014-02-21 14:45:42

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4689

VALUES

Struct

from

string

intidFLD

string

4688

intListFLD

string

4,8

intListPipeFLD

string

4|8

testFileUpload

string

title

string

Test 7

uuidFLD

string

60037305-4F5A-4EA9-934DB82D70983D06

Struct

DATEADDED

string

2014-02-21 14:46:08

DATEAPPROVED

string

2016-02-23 17:11:24

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4692

VALUES

Struct

from

string

intidFLD

string

4691

intListFLD

string

intListPipeFLD

string

testFileUpload

string

CSSMastery-Errata1.pdf

title

string

Test 11

uuidFLD

string

85174EE5-5167-4DC2-9E149463C595DA94

Struct

DATEADDED

string

2014-02-21 14:46:26

DATEAPPROVED

string

2014-02-21 14:46:26

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4694

VALUES

Struct

from

string

intidFLD

string

4693

intListFLD

string

intListPipeFLD

string

testFileUpload

string

title

string

Test 8

uuidFLD

string

2ECC1BBC-8844-4D16-9C5B636715B26354

Struct

DATEADDED

string

2014-02-21 15:04:40

DATEAPPROVED

string

2014-02-21 15:04:48

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4696

VALUES

Struct

from

string

intidFLD

string

4695

intListFLD

string

1,2,8,227

intListPipeFLD

string

1|2|8|227

testFileUpload

string

title

string

Test 9

uuidFLD

string

25FFCD6F-C019-46C0-B5B0AEA1536F1CBB

Struct

DATEADDED

string

2014-02-21 15:36:27

DATEAPPROVED

string

2016-02-23 16:35:45

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4701

VALUES

Struct

from

string

intidFLD

string

4700

intListFLD

string

intListPipeFLD

string

testFileUpload

string

Quick Start Guide.pdf

title

string

1Test 10

uuidFLD

string

E6789FF5-BA5C-4079-A4CBF08B77D3627D

Struct

DATEADDED

string

2014-02-21 20:30:43

DATEAPPROVED

string

2014-02-21 20:30:43

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4706

VALUES

Struct

from

string

you,me,other

intidFLD

string

4705

intListFLD

string

128,28

intListPipeFLD

string

128,28

testFileUpload

string

title

string

Test 12

uuidFLD

string

8348ED19-B919-4758-864E9A03369AD350

Struct

DATEADDED

string

2014-02-21 23:05:47

DATEAPPROVED

string

2014-02-21 23:05:47

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

4708

VALUES

Struct

from

string

intidFLD

string

4707

intListFLD

string

intListPipeFLD

string

testFileUpload

string

title

string

Test 13

uuidFLD

string

AC7B8F6C-6993-409C-808975D40435A882

Struct

DATEADDED

string

2016-02-23 13:56:38

DATEAPPROVED

string

2016-02-23 16:38:09

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

16550

VALUES

Struct

from

string

intidFLD

string

16549

intListFLD

string

1,2,3,4,44,33,11,22,8,88,128

intListPipeFLD

string

1|2|3|4|44|33|11|22|8|88|128

testFileUpload

string

CSSMastery-Errata.pdf

title

string

sfs test 1

uuidFLD

string

9AD4CE2C-D77B-A015-81FC35810537040D

Struct

DATEADDED

string

2016-02-23 15:31:41

DATEAPPROVED

string

2016-02-23 16:24:33

formID

number

4667

FORMNAME

string

qaTestRecords

pageID

number

16563

VALUES

Struct

from

string

intidFLD

string

16562

intListFLD

string

1,2,3,4,44,33,11,22,8,88,128

intListPipeFLD

string

1|2|3|4|44|33|11|22|8|88|128

testFileUpload

string

What is Magic Briefcase2.pdf

title

string

2TestTestBaby

uuidFLD

string

9E411D64-A5AE-134F-833949A1D01B5C98

qVIEW

Query Template: /site1/customcf/QA-getCEDataView.cfm:118 Execution Time: 3.05 ms Record Count: 15 Cached: No Datasource: commonspot-site-site1 Lazy: No SQL: Select * FROM ce_view_4667
	uuidFLD	intidFLD	title	intListFLD	intListPipeFLD	from	FormID	ControlID	PageID
1	B7024739-0E3A-4563-A4D23A11CD6A6BB4	4675	1Test 1	1,2,3,4,44,33,11,22,8,88	1\|2\|3\|4\|44\|33\|11\|22\|8\|88		4667	0	4676
2	EF3A873B-B18D-48C0-A133393E11CB9820	4677	Test 2	4,44	4\|44		4667	0	4678
3	4120F604-4E3F-4840-B075462FBA9A71EC	4680	Test 3	1,2,3,4	1\|2\|3\|4		4667	0	4681
4	810BAC43-1902-4E03-8E8E9BE34B9FDA47	4682	Test 4	44,33,11,22,88	44\|33\|11\|22\|88		4667	0	4683
5	4D510E3F-CD0F-4EC4-9CAFDCAE1FA4DA11	4684	Test 5	8	8		4667	0	4685
6	4C789175-B5E7-4B3B-B9A4C72998912E17	4686	Test 6	1,2,8,128	1\|2\|8\|128		4667	0	4687
7	60037305-4F5A-4EA9-934DB82D70983D06	4688	Test 7	4,8	4\|8		4667	0	4689
8	85174EE5-5167-4DC2-9E149463C595DA94	4691	Test 11	2	2	me	4667	0	4692
9	2ECC1BBC-8844-4D16-9C5B636715B26354	4693	Test 8	88	88		4667	0	4694
10	25FFCD6F-C019-46C0-B5B0AEA1536F1CBB	4695	Test 9	1,2,8,227	1\|2\|8\|227		4667	0	4696
11	E6789FF5-BA5C-4079-A4CBF08B77D3627D	4700	1Test 10	1	1		4667	0	4701
12	8348ED19-B919-4758-864E9A03369AD350	4705	Test 12	128,28	128,28	you,me,other	4667	0	4706
13	AC7B8F6C-6993-409C-808975D40435A882	4707	Test 13				4667	0	4708
14	9AD4CE2C-D77B-A015-81FC35810537040D	16549	sfs test 1	1,2,3,4,44,33,11,22,8,88,128	1\|2\|3\|4\|44\|33\|11\|22\|8\|88\|128		4667	0	16550
15	9E411D64-A5AE-134F-833949A1D01B5C98	16562	2TestTestBaby	1,2,3,4,44,33,11,22,8,88,128	1\|2\|3\|4\|44\|33\|11\|22\|8\|88\|128		4667	0	16563