Specify 6 Not Showing Queries In Specify 7

[carlosmbe]

Describe the bug
Queries present in Specify 7 are not available in Specify 6

To Reproduce
Steps to reproduce the behavior:

1. Go to NHMD Amber as petrifiedroadkill on Both Specify 6 and 7
2. Click on Queries
3. See error

Expected behavior
Both Versions have the same Queries

Screenshots

Desktop:
OS: Mac OSx Ventura
Browser: Chrome
Specify 7 Version: 7.8.10-prerelease

Database Name: NHMD Test

Reported By
@carlosmbe

[carlosmbe]

Error is also present in DAO_TEST

[maxpatiiuk]

Part of the diference is because sp7 list of queries includes schema mappings, where as sp6 excludes those. (would be fixed by #285 or #256)

[melton-jason]

Another difference is that some queries contain features that are Specify 7 exclusive.
Specify 7 marks these queries as Not Favorited in the database, which hides the queries by default in Specify 6.

specify7/specifyweb/frontend/js_src/lib/components/QueryBuilder/Save.tsx

Line 24 in 6dc0b59

query.set('isFavorite', !isModern(query));

specify7/specifyweb/frontend/js_src/lib/components/QueryBuilder/helpers.ts

Lines 366 to 382 in 6dc0b59

	export function isModern(query: SpecifyResource<SpQuery>): boolean {
	const serializedQuery = serializeResource(query);
	const baseTableName = getModel(serializedQuery.contextName)?.name;
	if (baseTableName === undefined) return false;
	const fields = serializedQuery.fields;
	const fieldSpecsMapped = queryFieldsToFieldSpecs(
	baseTableName,
	parseQueryFields(fields)
	);
	return (
	containsOr(fieldSpecsMapped) ||
	containsSpecifyUsername(baseTableName, fieldSpecsMapped) ||
	containsRelativeDate(fieldSpecsMapped)
	);
	}