Soql Case Sensitive

By default the Socrata Writer will perform an UPSERT on the dataset. Suppose, we are exporting report data from salesforce onto excel and using the Excel VLOOKUP function to match up records. "{{}}" The second step is I ask the question we already covered: "Should my user click on anything on the dashboard in order to trigger the binding?". Fixes: Fix Fixed a SalesForce. SELECT - GROUP BY- Transact-SQL. Apex is designed case insensitive because it works inline with case insensitive SOQL (SQL in Force. Currently a formula referencing an ID is created as text - and stored as the 15 character ID representation. I have an Excel spreadsheet with a large number of rows. Application E. If not, returns FALSE. This field is only available in the Create Block. Anyone know what I am doing wrong?. JavaScript is case sensitive. Cross Object Formulas in Salesforce. node/add is same as NODE/ADD and all combinations of upper case + lower work. Referencing encrypted fields in SOQL/WHERE clause is not supported. The naming convention for collation in mysql is as follows: *_bin: represents binary case sensitive collation *_cs: case sensitive collation. For more information, see Operators on page 51. Last 3 digits of the 18 digit represents checksum of the capitalization of 15 digit id. config G4S. Nachfolgend findet ihr einen Überblick über die wichtigsten SQL-Befehle. In this Search group we can use the following values ALL FIELDS like all sting field values, NAME FIELDS like standard Name fields, EMAIL FIELDS like fields values of types Email and PHONE FIELDS like field values of type Phone. clone() Makes a duplicate copy of the map. For Picklist, add TEXT() function to convert the picklist value to text. The id displayed by a report is the 15-digit case-sensitive id. Id should be easy to compare for them since salesforce should already have an index on this field. 15 Digit Id's is no longer used and SFDC now uses 18 Digit Id's 6. 15 digit case-sensitive version which is referenced in the UI; 18 digit case-insensitive version which is referenced through the API; The last 3 digits of the 18 digit ID are a checksum of the capitalizations of the first 15 characters, this ID length was created as a workaround to legacy systems which were not compatible with case-sensitive IDs. It did create a migration problem for existing data. This function is only for Text field. They can be given. • The LIKE operator in SOQL and SOSL supports escaping of special characters % or _. Apex and Database are Tightly Coupled. Anyone know what I am doing wrong?. I have an Excel spreadsheet with a large number of rows. When this is the case, the Force. From our previous Salesforce Developer Tutorial we have clearly learned about Salesforce Object Query Language(SOQL). So your query could be:. Salesforce record Id can either be 15 digit or 18 digit. It's work in progress. Use this link to. Hi Shashi, The LIKE operator performs a case-insensitive match, unlike the case-sensitive matching in SQL. Release Notes for Alpha Anywhere (Alpha Five Version 12) This document describes the updates and fixes made to Alpha Anywhere since its initial release. SOQL statements are case-sensitive; SOQL statements can be used in Apex and the Web Services API; If the output of a SOQL statement is an “Consider and Index Filter” error, it means the statement is returning too many records in which case you need to use a WHERE clause to restrict the # of records returned. Provide an example of when a Custom Setting would be used. com SOQL and SOSL Reference Last updated:. What you may not have know is that you can also use the === operator. SQL string operators are case-sensitive. Good conclusions for essays. Currently, SOQL statements cannot exceed 10,000 characters, but the good news is that Salesforce has promised to raise the limit to up to 20,000 characters, soon. So what's going on? Thanks! EDIT: actual SOQL code is below (in JS):. Ask Question This algoritm is case sensitive. Similarly, when the filter-preserving scheme tests for. Login to your Salesforce Customer Account. Use Apex Limits Methods to avoid hitting governor exceptions. Only 3 digit of ids represent object type. sp_server_info. Case Sensitivity, The SOQL query performed inside the. Applications such as Excel are not case-sensitive and may cause import errors or bad data in the system. Salesforce record Id can either be 15 digit or 18 digit. Salesforce Developer interview questions and answers are useful to attend job interviews and get shortlisted for job position. There may be a case where certain data wasn’t mandatory in the legacy system and has been made mandatory in Salesforce, what should be entered there as a value for a successful upload. They might have to change it so it is case sensitive when comparing Ids. The LIKE operator in SOQL and SOSL supports escaping of special characters % or _. For more information, see Operators on page 51. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. To specify a condition for a specific data set you might need a basic knowledge of SOQL. If an external object has no searchable fields, searches on that object return no records. We should take before delete event. The problem is that VLOOKUP doesn’t handle case-sensitive data well – it doesn’t recognize that 001C000000o4OOI is different from 001C000000o4Ooi. It is similar to SQL and helps to optimize code. We'll cover both sides of data connectivity, including an overview of basic characteristics of External Objects, their setup and usage, as well as a survey of the OData ecosystem. NET, let's go over some differences. The true power of LIKE comes with the use of wildcards. In this tutorial we will see concepts about database in Salesforce. Apex is on-demand and is compiled and executed in the cloud Apex is not a general purpose programming language, but is instead a proprietary language used for specific business logic functions Apex requires unit testing for deployment into a production. When composing a Salesforce query in the Editor, use SOQL instead of SQL. SQL is not case sensitive (i. Check Server Collation. Each row includes the 15 character case sensitive version of a Salesforce Id. Unless explicitly mentioned in the documentation, you can use the RESTful web service in the same way as published REST web services: the input parameters are the same and the output has the same format. As we know that each record Id represents a unique sObject record. Case Sensitivity, The SOQL query performed inside the. Why 18 characters? 15 case-sensitive (base 62) characters can represent 62 15, or around 7. The county boundary is identified by the state name (ie: WA) and county name (ie. Since Apex uses SOQL comparison semantics, results for Strings are collated according to the context user's locale, and `are not case sensitive. Because a collation is not specified in the ORDER BY clause, the first query uses the collation of the column when sorting the values. The custom fields can be used as the external IDs. Two keys that differ only by the case are considered unique and have corresponding distinct Map entries. Southern connecticut state university admissions essay topic. I recently wanted to do this -- but only for active users, and I wanted to be sure to exclude any System Administrators. TaroWorks 4. No SOQL or SOSL queries inside loops. SOQL is used to pull data out of Salesforce Objects (also known as “query the database”). Take this into account when linking the lookup table within a map. You only use that merge field when you are sending data from a mapping using SOQL. Remember also that incore lookups have better performance. To see the 'What's New in V12' document (which describes all of the new features in Alpha Anywhere's initial release) please click here. I think it would be an excellent enhancement if Salesforce allowed you to pull the 18 char IDs in their standard reports as they are much easier to work with in packages like Excel. Case Sensitivity, The SOQL query performed inside the. What is the collation? As you can see, this SQL Server has a case insensitive collation i. To help solve this problem, Salesforce came up with a variant of the 15-character case-sensitive ID, an 18-character version that’s not case-sensitive. Salesforce Customer Secure Login Page. 0 and later, Standard Picklist Value metadata type in salesforce would be StandardValueSet in salesforce. com platform – It is metadata driven architecture. How would you resolve this issue? My goal is to be able to query only selective ids (instead of all of them) of an object in salesforce. Easysoft ODBC-Salesforce Driver User's Guide - Configuration. 8 - SOQL and SOSL reserved words. Note: Salesforce queries created in Toad Data Point 3. Someone on SO will help you adjust your code to do what you want but you need to specify what language that is. However, upon running this method, you may affect more records than you intend to. All are instance methods. The most significant changes are on analysis performance, support for Salesforce's Visualforce language a whole new Apex Security Rule Set and the new Braces Rule Set for Apex. If you want to create a case sensitive database, you can explicitly specify the required Collation properties when creating. There is an algorithm for changing between the two, but the easiest way to do this is to use the FIXID() formula in the Excel Connector. Take this into account when linking the lookup table within a map. There may be a case where certain data wasn’t mandatory in the legacy system and has been made mandatory in Salesforce, what should be entered there as a value for a successful upload. com (1) Using Regular Expressions in SFDC (1) Using the Import Wizard in SFDC (1). Sono i comandi DDL a definire la struttura del database e quindi dei dati ivi contenuti, ma non fornisce gli strumenti per modificare i dati stessi per il quale si usa il DML (Data Manipulation Language). Check out interview questions page to get more information. The LIKE operator performs a case-insensitive match, unlike the case-sensitive matching in SQL. Webucator provides instructor-led training to students throughout the US and Canada. • The LIKE operator performs a case-insensitive match, unlike the case-sensitive matching in SQL. Salesforce Customer Secure Login Page. Use Deterministic instead (Exact Match and Case Sensitive only). I wonder if it is a technical reason: for example string comparisons are case insensitive and since Ids are case sensitive it doesn't simply work right. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. Refine your SOQL to only retrieve the data needed by the page. Determines whether the arguments in this function are case sensitive. First three characters represent the object. Easy Peasy Date Filters in Salesforce Reports. SOQL (Salesforce Object Query Language) Use SOQL to construct simple but powerful query strings in the queryString parameter in the query() call, in Apex statements, in Visualforce controllers and getter methods, or in the Schema Explorer of the Force. There are two types of Data Loader logs: sd1. We know there are two types of record-id are present in salesforce (18 digit -- Case Insensitive, 15 digit -- Case Sensitive). SOQL query can't run more than 120 seconds. I was dealing in a scenario where I was checking case-sensitivity of keys in Salesforce Maps. The true power of LIKE comes with the use of wildcards. Filters are not case-sensitive. Top most and recently asked questions in salesforce interviews. The following is a list of the Salesforce Standard Object ID prefixes. How to Check Case-Sensitivity in SQL Server. SQL Server is not by default case-sensitive, be it at the server, database, or column level. A case-sensitive VLOOKUP formula. 18 digit id is referenced through in the API and other 3 rd party tools. Please check that your. Using the == operator (most common case). 100、【Company Profile的Fiscal Year在SOQL Case:在做数据集成(类似Data Backup那种 Same 18 digit is represented as 15 digit id as case sensitive. Since SOQL is not case sensitive, The Scoop Composer uses upper-case/lower-case spelling of fields as rendering instructions. A OneCloud connection consists of a resource (i. Note: Don’t worry, “publishing” in this case means that you make your changes visible for other users on your server and, of course, it does not mean that it will be available for everyone on the internet. Certificate failure due to case sensitive client name not matched in the commserv database. That is, "Name" and "name" are the same in Apex, but different in JavaScript. For example, you cannot use SOQL to perform. Janbask Training. Why 18 characters? 15 case-sensitive (base 62) characters can represent 62 15, or around 7. 15 character IDs are case-sensitive, but 18-character IDs are case-insensitive. I have an apex datatable returning some User fields from a list in my apex class. It turns what are mostly case-insensitive identifiers into case-sensitive ones, e. v1 Version 1. SOQL Queries on Custom Metadata is case sensitive. 15 digit id is case sensitive 18 digit id is case insensitive Last 3 characters of the 18 digit id represent the checksum of the capitalization of the first 15 digitss 67. Time zone codes are case-sensitive. This formula calculates the number of days a case has been open. txt) or read online for free. To help solve this problem, Salesforce came up with a variant of the 15-character case-sensitive ID, an 18-character version that's not case-sensitive. Considerations:. I have an Excel spreadsheet with a large number of rows. I have inserted two records having External Id data as ' abc123 ' and ' ABC123 '. When the 'updateCustomerDescription' method is called and the number of customer records are more than 100, then it will hit the SOQL limit. It is not case sensitive. * **MatchCase** - Specifies if the text matching should be case sensitive. However in some setups table and column names are case-sensitive. Triggers determine what event to listen to in order to execute the actions described in a recipe. In the example below, the highlight duplicate function in Excel cannot distinguish the difference between the two 15-digit case sensitive IDs in rows 2 and 3. Soql like case sensitive definition. jOOQ's reason for being - compared to JPA. We use cookies to make your interactions with our website more meaningful. Case and where in sql keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. These functions can be used to transform and validate your data before you publish your dataset for consumption. Read: An Introduction to Apex Class in Salesforce for Beginners. What are different user licenses available in salesforce and explain them? Below is the list of licenses available in salesforce. In most cases described in this manual, they require editing of the template source code, which can be easily accessed by clicking on the Source button on the S-Docs Template Editor page. SOQL (Salesforce Object Query Language) Use SOQL to construct simple but powerful query strings in the queryString parameter in the query() call, in Apex statements, in Visualforce controllers and getter methods, or in the Schema Explorer of the Force. Case Insensitive Queries; so I turned up on site with a CD containing this procedure all ready to impress but it turns out they had a different case sensitive. "{{}}" The second step is I ask the question we already covered: "Should my user click on anything on the dashboard in order to trigger the binding?". com Blogger 24 1 25 tag:blogger. You only use that merge field when you are sending data from a mapping using SOQL. Is the drive letter case sensitive? I always thought they were upper case. Salesforce entity IDs are case-sensitive. ' I've tested it with a SOQL Query and 18 digits are indeed. I need to find the rows that contain duplicate Salesforce Ids. Janbask Training. If specified, do not specify an assignmentRuleId. The problem is that VLOOKUP doesn't handle case-sensitive data well - it doesn't recognize that 001C000000o4OOI is different from 001C000000o4Ooi. There may be a case where certain data wasn’t mandatory in the legacy system and has been made mandatory in Salesforce, what should be entered there as a value for a successful upload. It's critical to convert Dates to SOQL format with String. object id field can be 15 character case-sensitive or 18 character case-insensitive. Do not use the backslash character in a search except to escape a special character. Unix paths are case sensitive, so your commands must follow suit. Whereas, MySQL makes difference in table names. Tip: If you have pattern matching needs that go beyond this, consider writing a user-defined function in Perl or Tcl. DT-023259 Refresh Folder Header Data page part on current folder change. Another issue related to comparisons I've seen is that people sometimes use Maps with objects as the key. #MWD16 Midwest Dreamin’ Gold Sponsors 4. Salesforce SOQL query is not working same way as SQL server Data Base query. NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Assignment Rules The 15 characterID is case‐sensitive. Now that we understand how awesome Simple Salesforce is, I have a small application to read metadata from a Salesforce object and create a Create Table statement for Postgres database. It doesn’t support all advanced features of the SQL. Values in these External ID field must also be unique and you can also determine whether or not value are case sensitive. the latter will give no results which means that they are case sensitive in Salesforce. It takes an object name as an argument (not case sensitive). Currently, SOQL statements cannot exceed 10,000 characters, but the good news is that Salesforce has promised to raise the limit to up to 20,000 characters, soon. If true for an Account, all territory assignment rules are applied, and if false, no territory assignment rules are applied. a Eye-One Pro, EFI ES-1000) on Ebay. The problem is that internal, non-API Salesforce code uses 15 character unique object Ids. Join us for an introduction to External Data Sources, External Objects, and the OData Connector. SOQL (Salesforce Object Query Language) Use SOQL to construct simple but powerful query strings in the queryString parameter in the query() call, in Apex statements, in Visualforce controllers and getter methods, or in the Schema Explorer of the Force. So in the above example imagine there were two account objects in your org with Ids 01rG0000000FBr6 and 01rG0000000FbR6 respectively. You may enter clauses such as SELECT, FROM, and WHERE in upper or lowercase. For more information, see Salesforce. User Login History Report. It is not case sensitive. Don't use the backslash character in a search except to escape a special character. new contact is created, existing ticket is updated), when a new line is added in a file, or according to a schedule (fires at a certain time or interval), etc. Validation Rules B. Integration Name must be unique, Salesforce uses this value to integrate new picklist values with former text-only values. Filtering the records retrieved from Salesforce. 8 - SOQL and SOSL reserved words. The Structured Query Language offers database users a powerful and flexible data retrieval mechanism — the SELECT statement. Usually Annotation means which will specifies the behavior or modifies the way how the particular class or method. Salesforce Object Query Language is case sensitive and very easy to understand. Your options for this are: All, Referenced (default), Select, and Where. Each row includes the 15 character case sensitive version of a Salesforce Id. But client has a requirement to delete the child object records. For Example : ===== SELECT AccountId, Firstname, Lastname FROM Account WHERE. For starters, unlike C#, Apex is not case sensitive. 15 digit salesforce record id is case sensitive and 18 digit salesforce record id is case insensitive. Since Apex uses SOQL comparison semantics, results for Strings are collated according to the context user's locale, and `are not case sensitive. Note that this operation is not case-sensitive. User Login History Report. Filtering encrypted fields with probabilistic encryption is not supported. Soql like case sensitive definition. How it relates to other RDBMS databases. Returns 1 if expr matches pat; otherwise it returns 0. Validation Rules B. Check Server Collation. You want to create a relationship between Accounts and the Orders object (one-to-many relationship) leveraging a key field for account which is on both external object and Account. There are two versions of every record Id in salesforce : ・15 digit case-sensitive version which is referenced in the UI ・18 digit case-insensitive version which is referenced through the API And there are many usages of sObject ID,such as:Get the sObject name […]. We recommend that you use the exact, correct case always and everywhere—even in code where you can get away with being sloppy, such as your Apex or SOQL code. a Eye-One Pro, EFI ES-1000) on Ebay. Why 18 characters? 15 case-sensitive (base 62) characters can represent 62 15, or around 7. Many applications does not support case sensitive strings, so in that case we can make use of 18 digit Id which is case in-sensitive. Certificate failure due to case sensitive client name not matched in the commserv database. Through user interface user always see 15 digit id which is Cases-Sensitive. Each row includes the 15 character case sensitive version of a Salesforce Id. What is the collation? As you can see, this SQL Server has a case insensitive collation i. py install or, with easy_install: $ cd Database. To specify a condition for a specific data set you might need a basic knowledge of SOQL. The problem is not the auto capitalization. How it relates to other RDBMS databases. Feel free to comment. 2 days ago · How to make cp Linux shell/bash command to care letter case, be case-sensitive. This will determine. I need to find the rows that contain duplicate Salesforce Ids. The ids returned by web services api are 18-digit id. Lack of readability and maintainability. Filtering the records retrieved from Salesforce. In this Search group we can use the following values ALL FIELDS like all sting field values, NAME FIELDS like standard Name fields, EMAIL FIELDS like fields values of types Email and PHONE FIELDS like field values of type Phone. Applications such as Excel are not case-sensitive and may cause import errors or bad data in the system. Easysoft ODBC-Salesforce Driver User's Guide - Configuration. Cross Object Formulas in Salesforce refers to fields in records that are related to the current record that the formula is being applied to Example:-. 15 digit case-sensitive version is referenced in the UI and also visible in browser. In this example, CASE is connected to three different RUNSCRIPT actions. You can also using the % wildcard multiple times with the LIKE condition. One option is to specify the collation for the query to use a case sensitive configuration. Full name TZ codes are recommended, if a time zone is being used, as "AST" can refer to either "Atlantic" or "Arabic" standard time. Because the LIKE condition is not case-sensitive, the following SQL statement would return the same results: Try It SELECT * FROM customers WHERE last_name LIKE 'j%' ORDER BY last_name; Using Multiple % Wildcards in the LIKE Condition. SQL is a standard language for storing, manipulating and retrieving data in databases. Southern connecticut state university admissions essay topic. There are two versions of every record Id in salesforce : ・15 digit case-sensitive version which is referenced in the UI ・18 digit case-insensitive version which is referenced through the API And there are many usages of sObject ID,such as:Get the sObject name […]. So you could have a Case Sensitive Column in a Case Insensitive database. Easy Peasy Date Filters in Salesforce Reports. Note, that this is CASE SENSITIVE. Scope of the static variables and methods is through out the transaction. Welcome back to another episode of "Cooking with Code" where I introduce delectable bite-sized topics related to coding in Salesforce. Encrypted standard fields cannot be set up on the legacy portal orgs. Category: Salesforce Apex. Salesforce analyzes record changes against your SOQL query, and based on criteria outlined below, determines if the record should be pushed out to you. Use Deterministic instead (Exact Match and Case Sensitive only). Group by clause in SOQL. There is easiest way to use Salesforce Report ID and export in the Apex code. It turns what are mostly case-insensitive identifiers into case-sensitive ones, e. 18 digit case-insensitive and best used for manipulating data outside Salesforce. String comparison using == is case-insensitive; ID comparison using == is case-sensitive, and does not distinguish between 15-character and 18-character formats; User-defined types are compared by reference, which means that two objects are equal only if they reference the same location in memory. For more information, see Operators on page 51. In the second query, a case-sensitive, accent-sensitive collation is specified in the ORDER BY clause, which changes the order in which the rows are returned. Save your entry. Salesforce Object Query Language is very similar to SQL (Structured Query Language) used in other database systems. ・15 digit case-sensitive version which is referenced in the UI ・18 digit case-insensitive version which is referenced through the API And there are many usages of sObject ID,such as: Get the sObject name. Following snapshot of code explains the sample example of an interface, remember Apex is not case sensitive. The problem is that VLOOKUP doesn’t handle case-sensitive data well – it doesn’t recognize that 001C000000o4OOI is different from 001C000000o4Ooi. What are the differences between 15 and 18 digit record IDs? Case sensitive 5. Scope of the non-static variables or metods is within the scope of the same object. You may enter clauses such as SELECT, FROM, and WHERE in upper or lowercase. py install or, with easy_install: $ cd Database. Fieldset apex code salesforce Fieldset apex code salesforce A field set is a grouping of fields for same object. The following is a list of the Salesforce Standard Object ID prefixes. Time zone codes are case-sensitive. I can get the last log in from the user object but I need a way to join the user object to the rstk__sysusr__c object. Case Assignments. If the case is closed, it sets the result to null. Understanding environment management, release management, code versioning, deployment methodologies, and CI/CD tools. Although Salesforce uses case-insensitive matching for string operators such as “=” and “LIKE”, the driver processes SQL string operators in a case-sensitive manner. Loading Data from External Systems. 15 digit case-sensitive version. Please meet Spire R6, which is dedicated to improving the Code Assistance functionality for Apex. PHP code syntax check; javascript validator; Regex Tester; Compress JS and CSS;. $ cd Database. Also, be careful because the name is case sensitive. String comparison using == is case-insensitive; ID comparison using == is case-sensitive, and does not distinguish between 15-character and 18-character formats; User-defined types are compared by reference, which means that two objects are equal only if they reference the same location in memory. SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL. This guide uses uppercase for all VQL grammar. There are databases where this function is case-sensitive and others where is case-insensitive. Comparisons on strings are case-sensitive for unique case-sensitive fields and case-insensitive for all other fields. This will determine. Integer Standard integer string Using Data Loader. Webucator provides instructor-led training to students throughout the US and Canada. SQL Server is not by default case-sensitive, be it at the server, database, or column level. Case sensitive vs insensitive Ids. Expose Custom Apex Logic as RESTful Web Service Key Characteristics: - Define your own URI - Authentication (oAuth or Session ID) - Built-in (de)serialisation for JSON and XML - Case sensitive data keys (parameter names) - You can’t have more than 1 of the same HTTP method in the same class - You can have multiple classes with the same URI. Is net_Id__pc field is unique case-sensitive field? In general string comparisons using the equals operator are case-sensitive for unique case-sensitive fields and case-insensitive for all other fields. Note: Don’t worry, “publishing” in this case means that you make your changes visible for other users on your server and, of course, it does not mean that it will be available for everyone on the internet. You can also using the % wildcard multiple times with the LIKE condition. Salesforce, JIRA) when a certain event happens (e. We should take before delete event. This field is only available in the Create Block. the formula might apply to a Contact record, but in that formula you might want to refer to the related Account record. 000+01:00 2018-06-04T16:04:28. com platform. 0; Known Issues. Salesforce Useful Formula Fields - Free download as PDF File (. The rule validates you are checking for access permissions before a SOQL/SOSL/DML operation. Select Fields: Select the checkboxes of the fields you want included in the query to have them automatically added to the SOQL statement on the right. Apex - Strings - String in Apex, as in any other programming language, is any set of characters with no character limit. Access Salesforce During Planned Maintenance With Read-Only Mode (Generally Available) With Winter'16, Salesforce gives users read-only access during splits, instance migrations, instance switches, and certain other maintenance events. 'ACME' and 'Acme' will be considered 2 unique values and the encryption scheme would use different cipher text strings to identify these 2 records. One option is to specify the collation for the query to use a case sensitive configuration. You can also use the filter checkbox and the field next to it to type in code and look for specific things in your debug log. Yes this is possible as the keys of type string are case sensitive and can have multiple simialr strings.