Examples
Fetch
Filter examples
How do I filter on Custom_002 = 1
"Filter": {
"GenericName": "Custom_002",
"CompareOperator": "=",
"Value": "1"
},How do I filter on 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
"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"
"Filter": {
"GenericName": "Custom_001",
"CompareOperator": "=",
"Value": "SampleA"
},
How do I filter on Custom_001 LIKE "Sample..." (SampleA,SampleB... SampleZ)
"Filter": {
"GenericName": "Custom_001",
"CompareOperator": "LIKE",
"Value": "Sample%"
},
Filter decimal
How do I filter on Custom_003 = 1,01
"Filter": {
"GenericName": "Custom_003",
"CompareOperator": "=",
"Value": "1.01"
},
How do I filter on Custom_003 > 29,99 (greater than)
"Filter": {
"GenericName": "Custom_003",
"CompareOperator": ">",
"Value": "29.99"
},
How do I filter on Custom_003 < 29,99 (less than)
"Filter": {
"GenericName": "Custom_003",
"CompareOperator": "<",
"Value": "29.99"
},
Filter date
How do I filter on 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
"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
"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
"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
"Filter": {
"GenericName": "Custom_004",
"CompareOperator": "=",
"Value": "42392d94-1fdc-40d8-936e-064b48878ad7"
},
How do I Filter on Custom_004_DisplayValue = Sample1
"Filter": {
"GenericName": "Custom_004_DisplayValue",
"CompareOperator": "=",
"Value": "Sample1"
},[
{
"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
"Filter": {
"Attribute": "Count",
"CompareOperator": "=",
"Value": "1"
},
How do I filter on (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"
"Filter": {
"Attribute": "Description",
"CompareOperator": "=",
"Value": "SampleA"
},
How do I filter on (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
"Filter": {
"Attribute": "floating-point-number",
"CompareOperator": "=",
"Value": "1.01"
},
How do I filter on (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)
"Filter": {
"Attribute": "floating-point-number",
"CompareOperator": "<",
"Value": "29.99"
},
Filter date
How do I filter on (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
"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
"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
"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
"Filter": {
"Attribute": "Dropdown",
"CompareOperator": "=",
"Value": "42392d94-1fdc-40d8-936e-064b48878ad7"
},
How do I filter on (attribute) dropdown DisplayValue = Sample1
"Filter": {
"Attribute": "Dropdown_DisplayValue",
"CompareOperator": "=",
"Value": "Sample1"
},