How to write a query-function as a query-shortcode?

A shortcode is essentially a trigger that leads to execution of a piece of code in you functions.php file. The only real difference with the code you already have is you don’t print the result immediately, but return it from the function. Also, get_posts is not the preferred way to do multiple loops, as you can see in the first paragraph in the codex. Better use wp_query directly. Like this:

add_shortcode ('wpse312883', 'wpse312883_query_shorcode' );

function wpse312883_query_shorcode () {
  $all_post_titles = "";
  $args = (array(
    "post_type"=>"book_pages",
    "post_status"=>"publish",
    "posts_per_page"=>-1 
    ));
  $the_query = new WP_Query( $args );
  if ( $the_query->have_posts() ) {
    while ( $the_query->have_posts() ) {
      $the_query->the_post();
      $all_post_titles .= get_the_title();
      }
    }
  wp_reset_postdata();
  return $all_post_titles;
  }

No, if you include [wpse312883] in your post content in the GUI you will get a list of post titles. You may want to add some html to $all_post_titles depending on how you want to format the result.

Related Posts:

  1. Shortcode returns escaped HTML tags
  2. Can certain (site-crashing) limitations on WP_Query in shortcode be overcome?
  3. How to retrieve current page WP_Query arguments?
  4. Multiple Loops Inside a Function
  5. Orderby is working with one query but not with other
  6. how to use pre_gets_posts to exclude one queried ID from homepage loop
  7. relation OR instead of AND – Filtered term ID’s in loop
  8. Custom query for custom post type not getting correct post ID
  9. pages shortcode filtering by category
  10. WP_Query & shortcode : Return 3 articles from a category WordPress
  11. Get post Number with local loop and template
  12. Problem with custom WP_Query and underlying pagination/posts_per_page
  13. Calling a function with WP_Query only ever brings the first result
  14. WP_query shortcode inside acf Repeater breaks the repeater loop
  15. Resetting post data to previous loop in nested loops
  16. Pagination returns 404 after page 20
  17. Make loop display posts by alphabetical order
  18. get custom post type by tag
  19. Group posts by custom field
  20. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  21. Calling a custom excerpt function in a local loop
  22. Dynamically Override Fancy Title – Part II
  23. Transient pagination not working properly
  24. query posts in functions.php and update a field
  25. get_posts() seemingly ignoring post_type
  26. Woocommerce custom loop to show all the products [closed]
  27. How to show the posts of some category first, and then all other
  28. Pagination stops at page 6
  29. Paginated HTML Sitemap
  30. Why does the_content not work like others for a set post id?
  31. How to limit total number of posts in wp query loop?
  32. Custom Post Type Loop within Shortcode
  33. Pagination is broken and I need help fixing it
  34. Category attribute not working in custom shortcode
  35. How to vary post loop results layout and resume?
  36. Get a post from other loop each n-posts in the main loop
  37. Loop returning only 1 result
  38. WordPress Loop and $post
  39. How to filter, restrict and return posts based on custom user meta information
  40. Excluding pages in WP_query using ACF
  41. reset to main loop doesnt work
  42. Some doubts about how the main query and the custom query works in this custom theme?
  43. Post loop for all taxonomy terms
  44. Stuck in the query loop
  45. Shortcode for latest -not expired- posts
  46. Only display post if published in last 24 hours?
  47. How to remove the most recent post from $the_query
  48. WP_Query loop else statement not executing
  49. Include current post into loop
  50. Loop increase number
  51. How to display the featured image for each post?
  52. Check for the main query from the template
  53. Output loop to function return?
  54. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  55. has_excerpt() not working inside wp_query
  56. Exclude authors IDs from WP_Query
  57. Getting the post terms ‘wp_get_post_terms’ per post when within the functions.php file
  58. Save (and exclude) posts from loop to use in another loop on page
  59. Get all posts with empty meta_value
  60. Loop 3 posts column wise and continue the loop into same columns
  61. Check if a post has term inside loop
  62. How to Order By Two Custom Fields?
  63. Display specific page (that is child) content on parent page
  64. Query Taxonomy By Page Title
  65. How to change the default post type over the loop?
  66. Query Not working as expected
  67. Paginate pages with dynamic query
  68. WP_Query loop doen’t work with my custom taxonomy
  69. Determine if ID is page or post and query the ID
  70. get_children() Archive Template
  71. Populate select list with meta values from all posts of a Custom Post Type
  72. show most viewed post
  73. Bootstrap grid while loop
  74. How to display a post(by id) along with css in a page?
  75. How can I use WP_Query to sort ‘event’ custom post type by date?
  76. Display posts side by side with custom query
  77. WordPress For Loop Prints Unwanted Extra Paragraph Element
  78. Query by Category and Custom Field – Shortcode
  79. How to modify WP Query to target the first most recent post to adjust content
  80. Some doubts about how the main query and the custom query works in this custom theme?
  81. Pagination returns 404 after page 20
  82. Ordering Posts by parent category, name ascending
  83. I wan to process the following js to process the AJAX Request on my function to calculate author Total Post views
  84. WP_Query a custom field value bringing back 0 results
  85. Set Transient on CPT
  86. Modify shortcode to work with custom taxonomies and slugs
  87. Load 3 posts in flexslider slide [closed]
  88. Issue with WP_Query (need a array of selected ID’s)
  89. Multiple wp_query loops showing first 5 posts on all pages instead of older posts[Resolved]
  90. How to exclude posts ordered by comment_count from subsequent wordpress loops using WP_Query?
  91. meta_query dates from an array
  92. Creating array to compare custom field values
  93. $query conflicting with other queries in the same page
  94. WordPress Post Looping? [duplicate]
  95. Remove 5 latest posts from the loop
  96. Exclude post formats in custom loop
  97. Adding css tweak based on page template
  98. shortcode with $atts with strange results
  99. First post outside of loop, homepage only?
  100. Query All Posts: Either Display Most Recent or One with Particular ACF Value Chosen