{"id":3451,"date":"2023-04-12T15:33:17","date_gmt":"2023-04-12T15:33:17","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/"},"modified":"2026-01-16T17:24:31","modified_gmt":"2026-01-16T17:24:31","slug":"using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/","title":{"rendered":"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results?"},"content":{"rendered":"<p>The OFFSET-FETCH filter is a SQL combination designed so that you can specify how many rows you want to <em>skip<\/em> before specifying how many rows you want to return in a SQL query.<\/p>\n<p>This can come in handy in a variety of ways such as returning results to the user one \u201cslice\u201d at a time when the full result set is too big to fit in one screen or web page.<\/p>\n<p>To use the OFFSET-FETCH filter, it requires an <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/select-order-by-clause-transact-sql?view=sql-server-ver15\">ORDER BY clause<\/a> in a query and then must be specified right after it. You start by indicating how many rows to skip in the <strong>OFFSET<\/strong> clause, followed by how many rows to return in the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/language-elements\/fetch-transact-sql?view=sql-server-ver15\"><strong>FETCH<\/strong><\/a> clause.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1538 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch1-min.jpg\" alt=\"\" width=\"919\" height=\"371\" \/><\/p>\n<p><strong>A Planning Analytics Use Case<\/strong><\/p>\n<p>In Planning Analytics (PA), you use TurboIntegrator processes to query relational database tables and create and\/or update cubes and dimensions from the data returned in those queries. The data is typically extracted, transformed in some way, and then loaded into dimensions and cubes for consumption by Planning Analytics users. In most cases, the relational source systems will remain what is referred to as the \u201csystem of record\u201d and the data in Planning Analytics will be used for modeling and reporting.<\/p>\n<p>In common modeling scenarios, you may encounter data that might be infrequently referenced but is useful in decision making or drawing insights from a model. For this data, it may not make sense to incur the expense of actually \u201cloading and keeping\u201d it within Planning Analytics but forcing an analyst to \u201cgo outside\u201d (of Planning Analytics) to view this information is not necessarily a reasonable option.<\/p>\n<p>As an alternative, you can offer Planning Analytics users the ability to dynamically query database data and then immediately \u201cpage back and forth\u201d through the result set while remaining in Planning Analytics using a king of \u201cVCR\u201d control.<\/p>\n<p>To keep this example simple, I am going to use the previously shown RandomNames SQL Server table which has thousands of first names extracted from a global organizations employee database. I want my users to be able to page or \u201cscroll\u201d forward and back through the entire list of the names in alphabetical order, 25 names at a time.<\/p>\n<p>To accomplish this, first you can build a \u2018relational cube\u201d \u2013 meaning a cube with only 2 dimensions corresponding to the rows and columns that are retrieved by a SQL query. In this example I built the FETCH cube shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1533 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch2-min.jpg\" alt=\"\" width=\"884\" height=\"143\" \/><\/p>\n<p>Next, we\u2019ll create 2 TurboIntegrator processes (one to move forward and one to move back) that will query our RandomNames table through an <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/administer-odbc-data-sources-b19f856b-5b9b-48c9-8b93-07484bfab5a7\">ODBC data source<\/a>. The first process will be our \u201cgo forward\u201d process and is shown below.<\/p>\n<p>Basically, this process utilizes a numeric attribute to track \u201cwhat page\u201d is currently being viewed so that it can calculate the OFFSET and FETCH parameters for the SQL query (Note that I have decided to keep the page size (FETCH value) consistent at 25).<\/p>\n<p>The process then clears the previous page of data from our FETCH cube and then resets the attribute to the new OFFSET value.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1534\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch3-min.jpg\" alt=\"\" width=\"900\" height=\"313\" \/><\/p>\n<p>The Data tab of the process uses the value of the <strong>nRecordCount<\/strong> variable to insert the new records into our <strong>FETCH<\/strong> table:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1535\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch4-min.jpg\" alt=\"\" width=\"889\" height=\"205\" \/><\/p>\n<p>The process to \u201cmove back\u201d is a copy of the above process with the following exceptions: decrement the offset (rather than increment it) and then check to make sure the user hasn\u2019t \u201cpaged beyond\u201d the start or top of the list:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1536\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch5-min.jpg\" alt=\"\" width=\"853\" height=\"110\" \/><\/p>\n<p>If you use your imagination, I see a more parameterized query here where you might add the ability to narrow the search for names \u201cstarting with\u201d or \u201ccontaining\u201d or specific character or string. With an even more thought, another use case might add more columns of data might being returned, as users might want to search for sales by a customer or product or another qualifying attribute. The number of records to FETCH in a page could even be configurable.<\/p>\n<p><strong>Using Planning Analytics Workspace<\/strong><\/p>\n<p>With Planning Analytics Workspace (or \u201cPAW\u201d) it is easy work to create a new page with two buttons and a view.<\/p>\n<p>The view will be a simple view of the FETCH table we created earlier.<\/p>\n<p>You can use descriptive <u>Button Text<\/u> or simple characters on the buttons. \u00a0For the <u>Button Target<\/u> properties, make sure you select the proper Planning Analytics\u00a0 <u>Database<\/u> name and <u>Process<\/u> names and also be sure to check the box labeled \u201c<strong>Refresh after execution<\/strong>\u201d. Doing this will execute the forward or back process (when you click the corresponding button) and then refresh the PAW page (and the view) after it completes.<\/p>\n<p>If you the click the buttons, the view will show the next or previous 25 names from the database table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1537 alignnone\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch6-min.jpg\" alt=\"\" width=\"185\" height=\"542\" \/><\/p>\n<p>If you make sure your database table is properly indexed, the performance will be more than reasonable and allow your Planning Analytics users to quickly access and scroll though data that is resident <u>outside of any Planning Analytics cube<\/u> and is always current since it is coming from the system of record.<\/p>\n<p><strong>Final Thoughts<\/strong><\/p>\n<p>The above is a simple yet working example of a single-user scenario. To support multiple users, you would have to further parameterize the FETCH table, which shouldn\u2019t be too difficult.<\/p>\n<p>You could use this concept to archive data from Planning Analytics model to a relational data mart or warehouse. For example, imagine if you kept a limited number of scenarios in Planning Analytics and at certain times this data was moved to a data warehouse. If the occasion arose where you wanted to compare information from a current scenario, perhaps a particular product, customer, or period, you could query that data directly from the warehouse table, scroll through it in Planning Analytics and even use Planning Analytics Workspace to visualize it \u2013 without having to reload it into a model.<\/p>\n<p>Finally, when designing a Planning Analytics model, excluding infrequently used data (while still having access to it) will allow for a cleaner design and will typically improve the overall performance of the model, if only by reducing the total amount of data being stored and manipulated by the model.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The OFFSET-FETCH filter is a SQL combination designed so that you can specify how many rows you want to skip before specifying how many rows you want to return in a SQL query. This can come in handy in a variety of ways such as returning results to the user one \u201cslice\u201d at a time&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[35,36,52],"class_list":["post-3451","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-development","tag-planning-analytics","tag-planning-analytics-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"The OFFSET-FETCH filter is a SQL combination designed so that you can specify how many rows you want to skip before specifying how many rows you want to return in a SQL query. This can come in handy in a variety of ways such as returning results to the user one \u201cslice\u201d at a time&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:33:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T17:24:31+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results?\",\"datePublished\":\"2023-04-12T15:33:17+00:00\",\"dateModified\":\"2026-01-16T17:24:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/\"},\"wordCount\":1030,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/ch1-min.jpg\",\"keywords\":[\"Development\",\"Planning Analytics\",\"Planning Analytics Development\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/\",\"name\":\"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/ch1-min.jpg\",\"datePublished\":\"2023-04-12T15:33:17+00:00\",\"dateModified\":\"2026-01-16T17:24:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/ch1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/ch1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results? - QueBIT","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:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results? - QueBIT","og_description":"The OFFSET-FETCH filter is a SQL combination designed so that you can specify how many rows you want to skip before specifying how many rows you want to return in a SQL query. This can come in handy in a variety of ways such as returning results to the user one \u201cslice\u201d at a time&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:33:17+00:00","article_modified_time":"2026-01-16T17:24:31+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results?","datePublished":"2023-04-12T15:33:17+00:00","dateModified":"2026-01-16T17:24:31+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/"},"wordCount":1030,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch1-min.jpg","keywords":["Development","Planning Analytics","Planning Analytics Development"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/","url":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/","name":"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch1-min.jpg","datePublished":"2023-04-12T15:33:17+00:00","dateModified":"2026-01-16T17:24:31+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/08\/ch1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/using-the-sql-server-offset-fetch-feature-in-ibm-planning-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Use the SQL Server OFFSET-FETCH Feature in IBM Planning Analytics to Page Query Results?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3451"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3451\/revisions"}],"predecessor-version":[{"id":5015,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3451\/revisions\/5015"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}