{"id":77590,"date":"2018-06-01T19:00:21","date_gmt":"2018-06-01T16:00:21","guid":{"rendered":"https:\/\/www.javacodegeeks.com\/?p=77590"},"modified":"2018-06-01T13:45:49","modified_gmt":"2018-06-01T10:45:49","slug":"matching-string-wild-card-querydsl","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html","title":{"rendered":"Exact Matching of a String Containing a Wild Card in QueryDSL"},"content":{"rendered":"<p>On one of our recent projects, our client asked for a single search field that would be able to search on first name, last name and email address, with the only wildcard being an asterix \u2018*\u2019 for partial matches. Sounds simple, but it threw us for a little loop. In our project, we used QueryDSL in combination with JPA and MySQL as the underlying relational database management system.<\/p>\n<p>This means that the default wildcards are &#8216;_&#8217; for one character and &#8216;%&#8217; for multiple characters. Supporting &#8216;*&#8217; for partial matches was easy: we just replace &#8216;*&#8217; by &#8216;%&#8217; in our search string before passing it as a value to the JPA Query LIKE expression.<\/p>\n<p>Our code then looked like this:<\/p>\n<pre class=\"brush:sql\">searchText = searchText.replace( \"*\", \"%\" );\r\nquery.where( user.email.like( searchText ).or(\r\n\t\tuser.firstName.like( searchText ).or(\r\n\t\t\t\tuser.lastName.like( searchText )\r\n\t\t)\r\n) )<\/pre>\n<p>When searching on firstname_lastname@example.org at this point, the current query still returned two results: firstname_lastname@example.org and firstname.lastname@example.org.<div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<p>The &#8216;_&#8217; wildcard needed to be escaped, of course. But, as it turned out, it wasn&#8217;t quite that straightforward.<\/p>\n<p>As defined by <a href=\"http:\/\/www.querydsl.com\/static\/querydsl\/latest\/apidocs\/constant-values.html#com.querydsl.jpa.JPQLTemplates.DEFAULT_ESCAPE\" target=\"_blank\" rel=\"noopener\">the JPQLTemplates class<\/a>, the default escape character is &#8216;!&#8217;. This means that replacing &#8216;_&#8217; by &#8216;!_&#8217; in the search string <em>should<\/em> be enough.<\/p>\n<pre class=\"brush:sql\">searchText = searchText.replace( \"_\", \"!_\" );\r\nsearchText = searchText.replace( \"*\", \"%\" );<\/pre>\n<p>However, the tests showed that this wasn&#8217;t the case. After some debugging, and turning on SQL logging (which we turn off by default) we found out that the resulting SQL resolved to:<\/p>\n<p><code>SELECT * FROM users WHERE email like 'firstname!!_lastname@example.org' escape '!';<\/code><\/p>\n<p>Turns out the escape character itself was escaped. Initially, our Google Fu failed us a bit, but then we stumbled on <a href=\"https:\/\/github.com\/querydsl\/querydsl\/issues\/438\" target=\"_blank\" rel=\"noopener\">this GitHub issue from 2013<\/a>.<\/p>\n<p>Apparently, <em>actual escaping<\/em> can only be forced by <em>explicitly<\/em> stating the escape character, even when it&#8217;s the same as the default escape character.<\/p>\n<p>Adding the escape character to the QueryDSL expression solved our issue:<\/p>\n<pre class=\" brush:java\">searchText = searchText.replace( \"_\", \"!_\" );\r\nsearchText = searchText.replace( \"*\", \"%\" );\r\nquery.where( user.email.like( searchText, '!' ).or(\r\n\t\tuser.firstName.like( searchText, '!' ).or(\r\n\t\t\t\tuser.lastName.like( searchText, '!' )\r\n\t\t)\r\n) )<\/pre>\n<p>resolving to the SQL that we wanted:<\/p>\n<p><code>SELECT * FROM users WHERE email like 'firstname!_lastname@example.org' escape '!';<\/code><\/p>\n<p>and generating the search results that fulfilled the requirement of our client: firstname_lastname@example.org<\/p>\n<p>This is one we\u2019ll never forget!<\/p>\n<div class=\"attribution\">\n<table>\n<tbody>\n<tr>\n<td>Published on Java Code Geeks with permission by Andy Somers, partner at our <a href=\"\/\/www.javacodegeeks.com\/join-us\/jcg\/\" target=\"_blank\" rel=\"noopener\">JCG program<\/a>. See the original article here: <a href=\"https:\/\/www.foreach.be\/blog\/exact-matching-of-a-string-containing-a-wild-card-in-querydsl\" target=\"_blank\" rel=\"noopener\">Exact Matching of a String Containing a Wild Card in QueryDSL<\/a><\/p>\n<p>Opinions expressed by Java Code Geeks contributors are their own.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>On one of our recent projects, our client asked for a single search field that would be able to search on first name, last name and email address, with the only wildcard being an asterix \u2018*\u2019 for partial matches. Sounds simple, but it threw us for a little loop. In our project, we used QueryDSL &hellip;<\/p>\n","protected":false},"author":37425,"featured_media":12771,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[33,43,778],"class_list":["post-77590","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-java","tag-jpa","tag-mysql","tag-querydsl"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exact Matching of a String Containing a Wild Card in QueryDSL - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"&quot;Interested to learn more about QueryDSL? Then check out our article on Exact Matching of a String Containing a Wild Card in QueryDSL!&quot;\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exact Matching of a String Containing a Wild Card in QueryDSL - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"&quot;Interested to learn more about QueryDSL? Then check out our article on Exact Matching of a String Containing a Wild Card in QueryDSL!&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html\" \/>\n<meta property=\"og:site_name\" content=\"Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-01T16:00:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/05\/querydsl-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andy Somers\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andy Somers\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html\"},\"author\":{\"name\":\"Andy Somers\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/ee7d220ccec670500250742ddcc87e92\"},\"headline\":\"Exact Matching of a String Containing a Wild Card in QueryDSL\",\"datePublished\":\"2018-06-01T16:00:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html\"},\"wordCount\":356,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/querydsl-logo.jpg\",\"keywords\":[\"JPA\",\"MySQL\",\"Querydsl\"],\"articleSection\":[\"Enterprise Java\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html\",\"name\":\"Exact Matching of a String Containing a Wild Card in QueryDSL - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/querydsl-logo.jpg\",\"datePublished\":\"2018-06-01T16:00:21+00:00\",\"description\":\"\\\"Interested to learn more about QueryDSL? Then check out our article on Exact Matching of a String Containing a Wild Card in QueryDSL!\\\"\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#primaryimage\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/querydsl-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/querydsl-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2018\\\/06\\\/matching-string-wild-card-querydsl.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Enterprise Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\\\/enterprise-java\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Exact Matching of a String Containing a Wild Card in QueryDSL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Developers Resource Center\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.javacodegeeks.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/javacodegeeks\",\"https:\\\/\\\/x.com\\\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/ee7d220ccec670500250742ddcc87e92\",\"name\":\"Andy Somers\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fed4b0294d51ab26ee54ba874a083a059866bc2db98ab72ef964eef0bbe1f837?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fed4b0294d51ab26ee54ba874a083a059866bc2db98ab72ef964eef0bbe1f837?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fed4b0294d51ab26ee54ba874a083a059866bc2db98ab72ef964eef0bbe1f837?s=96&d=mm&r=g\",\"caption\":\"Andy Somers\"},\"description\":\"Software Engineer\",\"sameAs\":[\"https:\\\/\\\/www.foreach.be\\\/\"],\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/author\\\/andy-somers\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exact Matching of a String Containing a Wild Card in QueryDSL - Java Code Geeks","description":"\"Interested to learn more about QueryDSL? Then check out our article on Exact Matching of a String Containing a Wild Card in QueryDSL!\"","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html","og_locale":"en_US","og_type":"article","og_title":"Exact Matching of a String Containing a Wild Card in QueryDSL - Java Code Geeks","og_description":"\"Interested to learn more about QueryDSL? Then check out our article on Exact Matching of a String Containing a Wild Card in QueryDSL!\"","og_url":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html","og_site_name":"Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2018-06-01T16:00:21+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/05\/querydsl-logo.jpg","type":"image\/jpeg"}],"author":"Andy Somers","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Andy Somers","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#article","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html"},"author":{"name":"Andy Somers","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/ee7d220ccec670500250742ddcc87e92"},"headline":"Exact Matching of a String Containing a Wild Card in QueryDSL","datePublished":"2018-06-01T16:00:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html"},"wordCount":356,"commentCount":0,"publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/05\/querydsl-logo.jpg","keywords":["JPA","MySQL","Querydsl"],"articleSection":["Enterprise Java"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html","url":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html","name":"Exact Matching of a String Containing a Wild Card in QueryDSL - Java Code Geeks","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#primaryimage"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/05\/querydsl-logo.jpg","datePublished":"2018-06-01T16:00:21+00:00","description":"\"Interested to learn more about QueryDSL? Then check out our article on Exact Matching of a String Containing a Wild Card in QueryDSL!\"","breadcrumb":{"@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#primaryimage","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/05\/querydsl-logo.jpg","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/05\/querydsl-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.javacodegeeks.com\/2018\/06\/matching-string-wild-card-querydsl.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java","item":"https:\/\/www.javacodegeeks.com\/category\/java"},{"@type":"ListItem","position":3,"name":"Enterprise Java","item":"https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java"},{"@type":"ListItem","position":4,"name":"Exact Matching of a String Containing a Wild Card in QueryDSL"}]},{"@type":"WebSite","@id":"https:\/\/www.javacodegeeks.com\/#website","url":"https:\/\/www.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Developers Resource Center","publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/ee7d220ccec670500250742ddcc87e92","name":"Andy Somers","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fed4b0294d51ab26ee54ba874a083a059866bc2db98ab72ef964eef0bbe1f837?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fed4b0294d51ab26ee54ba874a083a059866bc2db98ab72ef964eef0bbe1f837?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fed4b0294d51ab26ee54ba874a083a059866bc2db98ab72ef964eef0bbe1f837?s=96&d=mm&r=g","caption":"Andy Somers"},"description":"Software Engineer","sameAs":["https:\/\/www.foreach.be\/"],"url":"https:\/\/www.javacodegeeks.com\/author\/andy-somers"}]}},"_links":{"self":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/77590","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/users\/37425"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=77590"}],"version-history":[{"count":0,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/77590\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media\/12771"}],"wp:attachment":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=77590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=77590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=77590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}