Filters - Revision history

46.16.211.253: /* Sorting */

2024-01-29T16:50:51Z

Sorting

2024-01-29T16:49:47Z

Sorting

2024-01-29T16:48:14Z

Sorting

← Older revision		Revision as of 16:48, 29 January 2024
Line 250:		Line 250:
	You can create a filter which sorts using "sort" like so:		You can create a filter which sorts using "sort" like so:

	<~~syntaxhiglight~~ lang="js">		<syntaxhighlight lang="js">
	{		{
	"sort":{		"sort":{

2024-01-29T16:47:42Z

Sorting

← Older revision		Revision as of 16:47, 29 January 2024
Line 250:		Line 250:
	You can create a filter which sorts using "sort" like so:		You can create a filter which sorts using "sort" like so:

			<syntaxhiglight lang="js">
	{		{
	"sort":{		"sort":{
Line 256:		Line 257:
	}		}
	}		}
			</syntaxhighlight>

	= Filter functions =		= Filter functions =

2024-01-29T16:47:07Z

← Older revision		Revision as of 16:47, 29 January 2024
Line 245:		Line 245:
	}		}
	</syntaxhighlight>		</syntaxhighlight>

			= Sorting =

			You can create a filter which sorts using "sort" like so:

			{
			"sort":{
			"field": "name",
			"dir": "desc" // or asc
			}
			}

	= Filter functions =		= Filter functions =

2023-01-13T23:28:45Z

Virtual Fields

← Older revision		Revision as of 23:28, 13 January 2023
Line 239:		Line 239:

	{		{
	query: "Tags=?", // Results must have exactly tags #4 and #5 and no others		query: "Tags=[?]", // Results must have exactly tags #4 and #5 and no others
	args: [		args: [
	[4, 5]		[4, 5]

2022-10-25T23:34:34Z

← Older revision		Revision as of 23:34, 25 October 2022
Line 197:		Line 197:
	From javascript you can just pass an array inside your args like so:		From javascript you can just pass an array inside your args like so:

	<syntaxhighlight lang="~~csharp~~">		<syntaxhighlight lang="js">

	{		{
Line 206:		Line 206:
	}		}

			</syntaxhighlight>

			= Virtual Fields =

			Virtual Fields can be used inside filter query strings as well just by simply using their name. The value is always the uint IDs. So for example if we want to get all pages tagged with "hello", first we need to get the ID of the tag "hello" (which we'll say is tag #4) and then from there can use it as either an array or a number as-is:

			<syntaxhighlight lang="js">
			{
			query: "Tags contains ?", // Results must have tag #4 on them, but can have any other tags too
			args: [
			4
			]
			}

			{
			query: "Tags=?", // Results must have exactly 1 tag and it must be tag #4
			args: [
			4
			]
			}
			</syntaxhighlight>

			You can query with an array as well, and like above there are two variants:

			<syntaxhighlight lang="js">
			{
			query: "Tags contains [?]", // Results must have tag #4 and tag #5 on them but can have any other tags too
			args: [
			[4, 5]
			]
			}

			{
			query: "Tags=?", // Results must have exactly tags #4 and #5 and no others
			args: [
			[4, 5]
			]
			}
	</syntaxhighlight>		</syntaxhighlight>

2022-10-25T23:28:43Z

JS filter notation

← Older revision		Revision as of 23:28, 25 October 2022
Line 24:		Line 24:

	Filters can also be constructed by the frontend, most often by [[Loop]]. In this scenario, a convenience filter notation is also available - it'll take the object notation you provide, and then convert it into the textual format with arguments. Here's some examples:		Filters can also be constructed by the frontend, most often by [[Loop]]. In this scenario, a convenience filter notation is also available - it'll take the object notation you provide, and then convert it into the textual format with arguments. Here's some examples:

			<syntaxhighlight lang="js">

			<Loop over="page" filter={
			{
			where: {
			userId: 14
			}
			}
			}>
			{page => { return <p>{page.url}</p>; }}
			</Loop>

			</syntaxhighlight>


			<syntaxhighlight lang="js">

			import webRequest from 'UI/Functions/WebRequest';

			webRequest("page/list", {
			where: {
			userId: 14
			}
			}).then(response => {
			// response.json contains the set of pages made by user #14
			})

			</syntaxhighlight>

			The filter object itself:

	<syntaxhighlight lang="js">		<syntaxhighlight lang="js">
Line 78:		Line 109:
	args: [14]		args: [14]
	}		}
			</syntaxhighlight>

			Query/args being passed in to webRequest and Loop:

			<syntaxhighlight lang="js">

			import webRequest from 'UI/Functions/WebRequest';

			webRequest("page/list", {
			query: "UserId=?",
			args: [14]
			}).then(response => {
			// response.json contains the set of pages made by user #14
			})


			<Loop over='page' filter={{query: "UserId=?",
			args: [14]}}> ...
			</Loop>

	</syntaxhighlight>		</syntaxhighlight>

2022-10-25T23:24:06Z

Arrays

← Older revision		Revision as of 23:24, 25 October 2022
Line 129:		Line 129:

	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	~~name~~=[?]		Name=[?]
	</syntaxhighlight>		</syntaxhighlight>

	If you're doing this in C# you can then bind any IEnumerable like so:		This syntax exists such that the precompiled filter is ready to receive a set of values rather than just one.

			If you're doing this in C# you can then bind any IEnumerable like so, provided its data type matches that of the target field:

	<syntaxhighlight lang="csharp">		<syntaxhighlight lang="csharp">

2022-10-25T23:22:55Z

Arrays

← Older revision		Revision as of 23:22, 25 October 2022
Line 126:		Line 126:
	= Arrays =		= Arrays =

	~~Todo~~: ~~Using~~ [?] inside ~~a filter for array-of-things comparisons.~~		If you provide an array of values you must tell the query system that you are doing so by surrounding your ? arg with square brackets, like this:

			<syntaxhighlight lang="bash">
			name=[?]
			</syntaxhighlight>

			If you're doing this in C# you can then bind any IEnumerable like so:

			<syntaxhighlight lang="csharp">

			var nameList = new List<string>() { "Dave", "Steve" };

			var resultsWithEitherName = await Where("Name=[?]").Bind(nameList).ListAll(context);

			</syntaxhighlight>

			From javascript you can just pass an array inside your args like so:

			<syntaxhighlight lang="csharp">

			{
			"query": "Name=[?]",
			"args": [
			["Dave", "Steve"]
			]
			}

			</syntaxhighlight>

	= Filter functions =		= Filter functions =