--- title: Examples slug: api/examples createdAt: 2024-04-23T10:55:51.966Z --- # Fetch ### Filter examples How do I filter on Custom\_002 = 1 :::CodeblockTabs Custom\_002 = 1 ```json "Filter": { "GenericName": "Custom_002", "CompareOperator": "=", "Value": "1" }, ``` ::: How do I filter on Custom\_002 = 1 OR 2 :::CodeblockTabs Custom\_002 = 1 OR 2 ```json "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 :::CodeblockTabs Custom\_002 = 1 OR 2 OR 3 ```json "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" :::CodeblockTabs Custom\_001 = "SampleA" ```json "Filter": { "GenericName": "Custom_001", "CompareOperator": "=", "Value": "SampleA" }, ``` ::: How do I filter on Custom\_001 LIKE "Sample..." (SampleA,SampleB... SampleZ) :::CodeblockTabs Custom\_001 LIKE "Sample..." ```json "Filter": { "GenericName": "Custom_001", "CompareOperator": "LIKE", "Value": "Sample%" }, ``` ::: ### Filter decimal How do I filter on Custom\_003 = 1,01 :::CodeblockTabs Custom\_003 = 1,01 ```json "Filter": { "GenericName": "Custom_003", "CompareOperator": "=", "Value": "1.01" }, ``` ::: How do I filter on Custom\_003 > 29,99 ***(greater than)*** :::CodeblockTabs Custom\_003 > 29,99 ```json "Filter": { "GenericName": "Custom_003", "CompareOperator": ">", "Value": "29.99" }, ``` ::: How do I filter on Custom\_003 \< 29,99 ***(less than)*** :::CodeblockTabs Custom\_003 \< 29,99 ```json "Filter": { "GenericName": "Custom_003", "CompareOperator": "<", "Value": "29.99" }, ``` ::: ### Filter date How do I filter on Custom\_006 = 20.03.2024 :::CodeblockTabs Custom\_006 = 20.03.2024 ```json "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 :::CodeblockTabs Custom\_006 between (including) 01.03.2024 and 01.04.2024 ```json "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 :::CodeblockTabs Custom\_007 = 06.02.2024 13:00 ```json "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 :::CodeblockTabs Custom\_007 between (including) 06.02.2024 13:00 and 16:00 ```json "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 :::CodeblockTabs Custom\_004 = 42392d94-1fdc-40d8-936e-064b48878ad7 ```json "Filter": { "GenericName": "Custom_004", "CompareOperator": "=", "Value": "42392d94-1fdc-40d8-936e-064b48878ad7" }, ``` ::: How do I Filter on Custom\_004\_DisplayValue = Sample1 :::CodeblockTabs Custom\_004\_DisplayValue = Sample1 ```json "Filter": { "GenericName": "Custom_004_DisplayValue", "CompareOperator": "=", "Value": "Sample1" }, ``` ::: :::CodeblockTabs example record ```json [ { "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 :::CodeblockTabs (attribute) Count = 1 ```json "Filter": { "Attribute": "Count", "CompareOperator": "=", "Value": "1" }, ``` ::: How do I filter on (attribute) Count = 1 OR 3 :::CodeblockTabs (attribute) Count = 1 OR 3 ```json "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" :::CodeblockTabs (attribute) Description= "SampleA" ```json "Filter": { "Attribute": "Description", "CompareOperator": "=", "Value": "SampleA" }, ``` ::: How do I filter on (attribute) Description LIKE "Sample..." (SampleA,SampleB... SampleZ) :::CodeblockTabs (attribute) Description LIKE "Sample..." (SampleA,SampleB... SampleZ) ```json "Filter": { "Attribute": "Description", "CompareOperator": "LIKE", "Value": "Sample%" }, ``` ::: ### Filter decimal How do I filter on (attribute) floating-point-number= 1,01 :::CodeblockTabs (attribute) floating-point-number= 1,01 ```json "Filter": { "Attribute": "floating-point-number", "CompareOperator": "=", "Value": "1.01" }, ``` ::: How do I filter on (attribute) floating-point-number > 29,99 ***(greater than)*** :::CodeblockTabs (attribute) floating-point-number > 29,99 (greater than) ```json "Filter": { "Attribute": "floating-point-number", "CompareOperator": ">", "Value": "29.99" }, ``` ::: How do I filter on (attribute) floating-point-number \< 29,99 ***(less than)*** :::CodeblockTabs (attribute) floating-point-number \< 29,99 (less than) ```json "Filter": { "Attribute": "floating-point-number", "CompareOperator": "<", "Value": "29.99" }, ``` ::: ### Filter date How do I filter on (attribute) date= 20.03.2024 :::CodeblockTabs (attribute) date= 20.03.2024 ```json "Filter": { "Attribute": "Date", "CompareOperator": "=", "Value": "2024-03-20" }, ``` ::: How do I filter on (attribute) date **between **(including) 01.03.2024 and 01.04.2024 :::CodeblockTabs (attribute) date between (including) 01.03.2024 and 01.04.2024 ```json "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 :::CodeblockTabs (attribute) appointment= 06.02.2024 13:00 ```json "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 :::CodeblockTabs (attribute) appointment between (including) 06.02.2024 13:00 and 16:00 ```json "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 :::CodeblockTabs attribute) Dropdown = 42392d94-1fdc-40d8-936e-064b48878ad7 ```json "Filter": { "Attribute": "Dropdown", "CompareOperator": "=", "Value": "42392d94-1fdc-40d8-936e-064b48878ad7" }, ``` ::: How do I filter on (attribute) dropdown DisplayValue = Sample1 :::CodeblockTabs (attribute) dropdown DisplayValue = Sample1 ```json "Filter": { "Attribute": "Dropdown_DisplayValue", "CompareOperator": "=", "Value": "Sample1" }, ``` :::