CDF missing in field - Revision history

Alnaucler at 08:48, 12 July 2014

2014-07-12T08:48:59Z

← Older revision		Revision as of 10:48, 12 July 2014
Line 30:		Line 30:
	`field`.fieldtype ASC		`field`.fieldtype ASC
	</pre>		</pre>
	~~{{note\| This query is in 5.x format}}~~

	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Dionysia at 08:34, 13 February 2014

2014-02-13T08:34:18Z

← Older revision		Revision as of 10:34, 13 February 2014
Line 30:		Line 30:
	`field`.fieldtype ASC		`field`.fieldtype ASC
	</pre>		</pre>
	~~Note:~~ This query is in 5.x format		{{note\| This query is in 5.x format}}

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 15:52, 12 February 2014

2014-02-12T15:52:10Z

← Older revision		Revision as of 17:52, 12 February 2014
Line 1:		Line 1:
	<pre>SELECT		This query check if all records in ''customdefinedfield'' are in ''field''
			<pre>
			SELECT
	customdefinedfield.name,		customdefinedfield.name,
	customdefinedfield.cdf_datatype,		customdefinedfield.cdf_datatype,
Line 8:		Line 10:
	WHERE		WHERE
	`field`.cdf_guid IS NULL		`field`.cdf_guid IS NULL
			</pre>

	~~-----------------------------------------------------------------------~~		This query check if all CDF records in ''field'' are in ''customdefinedfield''
			<pre>
	SELECT		SELECT
	`field`.property_name,		`field`.property_name,
Line 21:		Line 24:
	WHERE		WHERE
	customdefinedfield.cdf_id IS NULL AND		customdefinedfield.cdf_id IS NULL AND
	`field`.cdf_guid IS NOT NULL		`field`.cdf_guid IS NOT NULL AND
			(`field`.fieldtype = 'cdf' OR
			`field`.fieldtype = 'select_cdf')
			ORDER BY
			`field`.fieldtype ASC
	</pre>		</pre>
			Note: This query is in 5.x format
	[[Category:NoPublic]]		[[Category:NoPublic]]
			[[Category:SQL Queries]]

Alnaucler: Created page with "

SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype FROM customdefinedfield Left Join `field` ON customdefinedfield.cdf_id = `f..."

2014-02-10T15:46:53Z

Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype FROM customdefinedfield Left Join `field` ON customdefinedfield.cdf_id = `f..."

New page

<pre>SELECT
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype
FROM
customdefinedfield
Left Join `field` ON customdefinedfield.cdf_id = `field`.cdf_guid
WHERE
`field`.cdf_guid IS NULL

-----------------------------------------------------------------------

SELECT
`field`.property_name,
`field`.fieldtype,
`field`.display_mechanism,
`field`.cdf_guid
FROM
customdefinedfield
Right Outer Join `field` ON customdefinedfield.cdf_id = `field`.cdf_guid
WHERE
customdefinedfield.cdf_id IS NULL AND
`field`.cdf_guid IS NOT NULL

</pre>
[[Category:NoPublic]]

CDF missing in field - Revision history

Alnaucler at 08:48, 12 July 2014

Dionysia at 08:34, 13 February 2014

Alnaucler at 15:52, 12 February 2014

Alnaucler: Created page with "SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype FROM customdefinedfield Left Join `field` ON customdefinedfield.cdf_id = `f..."

Alnaucler: Created page with "
SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype FROM customdefinedfield Left Join `field` ON customdefinedfield.cdf_id = `f..."