Examples

fetch filter examples how do i filter on custom 002 = 1 custom 002 = 1 "filter" { "genericname" "custom 002", "compareoperator" "=", "value" "1" }, how do i filter on custom 002 = 1 or 2 custom 002 = 1 or 2 "filter" { "logic" "or", "groups" \[ { "genericname" "custom 002", "compareoperator" "=", "value" "1" }, { "genericname" "custom 002", "compareoperator" "=", "value" "2" } ] }, how do i filter on custom 002 = 1 or 2 or 3 custom 002 = 1 or 2 or 3 "filter" { "logic" "or", "groups" \[ { "genericname" "custom 002", "compareoperator" "=", "value" "1" }, { "genericname" "custom 002", "compareoperator" "=", "value" "2" }, { "genericname" "custom 002", "compareoperator" "=", "value" "3" } ] }, filter text how do i filter on custom 001 = "samplea" custom 001 = "samplea" "filter" { "genericname" "custom 001", "compareoperator" "=", "value" "samplea" }, how do i filter on custom 001 like "sample " (samplea,sampleb samplez) custom 001 like "sample " "filter" { "genericname" "custom 001", "compareoperator" "like", "value" "sample%" }, filter decimal how do i filter on custom 003 = 1,01 custom 003 = 1,01 "filter" { "genericname" "custom 003", "compareoperator" "=", "value" "1 01" }, how do i filter on custom 003 > 29,99 (greater than) custom 003 > 29,99 "filter" { "genericname" "custom 003", "compareoperator" ">", "value" "29 99" }, how do i filter on custom 003 < 29,99 (less than) custom 003 < 29,99 "filter" { "genericname" "custom 003", "compareoperator" "<", "value" "29 99" }, filter date how do i filter on custom 006 = 20 03 2024 custom 006 = 20 03 2024 "filter" { "genericname" "custom 006", "compareoperator" "=", "value" "2024 03 20" }, how do i filter on custom 006 between (including) 01 03 2024 and 01 04 2024 custom 006 between (including) 01 03 2024 and 01 04 2024 "filter" { "logic" "and", "groups" \[ { "genericname" "custom 006", "compareoperator" ">=", "value" "2024 03 01" }, { "genericname" "custom 006", "compareoperator" "<", "value" "2024 04 01" } ] }, filter appointment how do i filter on custom 007 = 06 02 2024 13 00 custom 007 = 06 02 2024 13 00 "filter" { "genericname" "custom 007", "compareoperator" "=", "value" "2024 02 06 13 30 00" }, how do i filter on custom 007 between (including) 06 02 2024 13 00 and 16 00 custom 007 between (including) 06 02 2024 13 00 and 16 00 "filter" { "logic" "and", "groups" \[ { "genericname" "custom 007", "compareoperator" ">=", "value" "2024 02 06 13 00 00" }, { "genericname" "custom 007", "compareoperator" "<", "value" "2024 02 06 16 00 00" } ] }, filter dropdown how do i filter on custom 004 = 42392d94 1fdc 40d8 936e 064b48878ad7 custom 004 = 42392d94 1fdc 40d8 936e 064b48878ad7 "filter" { "genericname" "custom 004", "compareoperator" "=", "value" "42392d94 1fdc 40d8 936e 064b48878ad7" }, how do i filter on custom 004 displayvalue = sample1 custom 004 displayvalue = sample1 "filter" { "genericname" "custom 004 displayvalue", "compareoperator" "=", "value" "sample1" }, example record \[ { "createdby" "mfa, customizer", "createdbyid" "95f5d41c c234 4dec b88b 52c81a8f5143", "createddate" "2024 05 02t12 41 42 793z", "custom 001" "sample", "custom 002" "", "custom 003" "", "custom 004" "42392d94 1fdc 40d8 936e 064b48878ad7", "custom 004 displayvalue" "sample1", "custom 005" "0", "custom 006" "", "custom 007" "", "custom 008" "", "dataid" "7a759c82 8c01 402f 85bc 14053a54592a", "displayvalue" "sample", "entityid" "ee5f85eb 53d4 47a5 a8d2 f18ee0a9ce91", "entrytime" "2024 05 02t12 41 42 793z", "haswriteaccess" true, "isactive" true, "mandatorid" "8d7bfcac 6588 4ee3 b4a3 daa4e7ad7a9d", "modifiedby" "mfa, customizer", "modifiedbyid" "95f5d41c c234 4dec b88b 52c81a8f5143", "modifieddate" "2024 05 02t12 41 42 793z", "triggerstamp" "2024 05 02t12 41 42 793z", "userid" "95f5d41c c234 4dec b88b 52c81a8f5143" } ] fetchnamed filter examples how do i filter on (attribute) count = 1 (attribute) count = 1 "filter" { "attribute" "count", "compareoperator" "=", "value" "1" }, how do i filter on (attribute) count = 1 or 3 (attribute) count = 1 or 3 "filter" { "attribute" "count", "logic" "or", "groups" \[ { "attribute" "count", "compareoperator" "=", "value" "1" }, { "attribute" "count", "compareoperator" "=", "value" "3" } ] }, filter text how do i filter on (attribute) description= "samplea" (attribute) description= "samplea" "filter" { "attribute" "description", "compareoperator" "=", "value" "samplea" }, how do i filter on (attribute) description like "sample " (samplea,sampleb samplez) (attribute) description like "sample " (samplea,sampleb samplez) "filter" { "attribute" "description", "compareoperator" "like", "value" "sample%" }, filter decimal how do i filter on (attribute) floating point number= 1,01 (attribute) floating point number= 1,01 "filter" { "attribute" "floating point number", "compareoperator" "=", "value" "1 01" }, how do i filter on (attribute) floating point number > 29,99 (greater than) (attribute) floating point number > 29,99 (greater than) "filter" { "attribute" "floating point number", "compareoperator" ">", "value" "29 99" }, how do i filter on (attribute) floating point number < 29,99 (less than) (attribute) floating point number < 29,99 (less than) "filter" { "attribute" "floating point number", "compareoperator" "<", "value" "29 99" }, filter date how do i filter on (attribute) date= 20 03 2024 (attribute) date= 20 03 2024 "filter" { "attribute" "date", "compareoperator" "=", "value" "2024 03 20" }, how do i filter on (attribute) date between (including) 01 03 2024 and 01 04 2024 (attribute) date between (including) 01 03 2024 and 01 04 2024 "filter" { "attribute" "date", "logic" "and", "groups" \[ { "attribute" "date", "compareoperator" ">=", "value" "2024 03 01" }, { "attribute" "date", "compareoperator" "<", "value" "2024 04 01" } ] }, filter appointment how do i filter on (attribute) appointment= 06 02 2024 13 00 (attribute) appointment= 06 02 2024 13 00 "filter" { "attribute" "appointment", "compareoperator" "=", "value" "2024 02 06 13 30 00" }, how do i filter on (attribute) appointment between (including) 06 02 2024 13 00 and 16 00 (attribute) appointment between (including) 06 02 2024 13 00 and 16 00 "filter" { "attribute" "appointment", "logic" "and", "groups" \[ { "attribute" "appointment", "compareoperator" ">=", "value" "2024 02 06 13 00 00" }, { "attribute" "appointment", "compareoperator" "<", "value" "2024 02 06 16 00 00" } ] }, filter dropdown how do i filter on (attribute) dropdown= 42392d94 1fdc 40d8 936e 064b48878ad7 attribute) dropdown = 42392d94 1fdc 40d8 936e 064b48878ad7 "filter" { "attribute" "dropdown", "compareoperator" "=", "value" "42392d94 1fdc 40d8 936e 064b48878ad7" }, how do i filter on (attribute) dropdown displayvalue = sample1 (attribute) dropdown displayvalue = sample1 "filter" { "attribute" "dropdown displayvalue", "compareoperator" "=", "value" "sample1" },