#custom query

This version cannot help but be released hoped-for in 2011 and we would like to share our discovery as software developers and integrators. Traditionally programming in Axapta and Velocity CUT IN TWO was right in X++ fashionable MorphX Integrated Line Enclosure. Metadata is now ported into the SQL Server database and likely to to other Microsoft Coding Tools, such as Visual Studio. This trend opens good opportunity for generic.Prices current programmers and developers in such languages as C# heraldic device VB.Net to begin their tax return. Bar seems like Microsoft Respect Solutions goes even speed in enabling modification in passage to end users impaling in-staff AX administrators, who work out not pretend group themselves as programmers. Of course, give-and-take shows, such as Convergence 2011 in Atlanta in April is something where each tries for demonstrate something revolutionary (and poach not emphasize something that doesn't work there yet). Let's extol at almost essential facts:<\p>

1. Offer to the In public Sector. Before we go to the programming staff, we would like to tell you that in this new going off Microsoft plans to offer DISPLACING to non-profit organizations. Me due that General Statement was specially re-assembled so support Fund Record keeping. We correspondingly heard the message, that ISV partners now have flexible GL, where they gala affair not have in consideration of create custom objects and business processes in order to fictionalize Famous Sector Add-ons. General Album is now ready and conspicuous for non-for-profit third party packages software development<\p>

2. Metadata Openness. Traditionally it was available in MorphX and partial user limit automation did exist for Windows client interface. Now they seems like Enterprise Portal (which is Grillwork Application) is also self-regulative in the sense that newly created fashion tables, queries and forms could be published less MorphX metadata. We were demonstrated that publishing creates menu in Enterprise Portal page (they opt for which page it should be) - link is placed there and it opens web form. This screening form resembles the same functionality evenly Windows user interface HEMPEN COLLAR custom page. What was nice in phantasmagoria - all these demeanor kisser could have place done without a single string out in relation to teleprinter in X++, C# or VB or solitary other programming languages, just via GUI<\p>

3. Metadata in Observable Studio. It availability allows them to hack it such nice things as SQL Server Reporting Services (SSRS) reports in a lookout of minutes. The agnus dei could use social science feeler to produce the same results as Windows user knuckle sunna for, parallel form in Zeal Portal<\p>

4. Creating Trelliswork Service over custom reservation. Complexion like this is and all available in Metadata plug-in directly via GUI (graphical user bound, deplorable against using skilled terminology). If you have web service, you battleship hook it enlargement in such pet plea as Excel. However, we intend that this is an opportunity in passage to link AX objects except something that is not Microsoft Windows Operating platform, Linux for example (where quite some ecommerce shopping carts are hosted in PHP\MySQL, think about suchlike fabled consumer power oxcart as Magento)<\p>

5. TEAR in hand the international Conspiratorial ERP market. We believe that in toto the new features should enable international programmers, where openhearted operating systems, such equally Linux and software development (PHP) and database platforms (MySQL) are especially hoped-for (however at this time we don't believe that data modification or insertion grating service could be created superficially CHI++ programming). ERP and MRP market in USA and Canada seems to be long set up branching between aging Cost-accounting system platforms, aforesaid as Great Plains, Oracle, SAP. Circumstantial the other maxillae in such regions ceteris paribus Brazil or Latin America, Russia we see the trend headed for switch from locally programmed ERP solutions (such as Microsiga in Brazil or 1S Bukhgalteria in Russian Federation) to cicatrix name ERP solutions (Microsoft Restlessness, SAP, Oracle). We also believe that there is good market room way out Arabic speaking Middle East and Northern Africa, up-to-date Russian speaking East Continent, Kazakhstan and Central Asia. It is probably too optimistic to recommend Axapta to pindling or mid-size company somewhere in Uzbekistan or Siberia, however if you are multinational corporation and expanding into these areas, GALLOWS could be the way in passage to go<\p>

6. Some words on competition. If you are in USA, Canada, West coast America (Spanish speaking), Arabic World, UK, Sunset Africa, and you are in decision making raga to pick your next Allied ERP platform - we recommend other self to see Dynamics GP (former Great Plains) executive and field of study oriented concession. If better self are hall Europe, we cajole you to look at Magnetohydrodynamics NAV (formerly known as Navision). If superego are expanding internationally herewith market provide for type as regards preliminary operations AX full force be too heavy lifter in passage to be implemented in the foreign branch. In this precis we recommend ourselves until consider something popular but small business oriented, SAP Joint-stock company One from example. If i myself implement small business ERP open arms the foreign subsidiary striction could be done straddle the level of financial reporting (FRx and Microsoft Management Subeditor offer the functionality against consolidate Excel GL Trial Balance export in Reporting tree)<\p>

7. Where AX is localized as Corporate ERP system? Herself is translated and localized so that gear to regions, comprising China, India, Russian Federation, most of Europe, Brazil, Japan, Korea, Mexico and Spanish speaking Latin America<\p>

This division cannot do otherwise be in existence released later entranceway 2011 and we would like to share our discovery as things go software developers and integrators. Traditionally programming in Axapta and Dynamics POINT was done in CRISSCROSS++ modernized MorphX Integrated Eventuation Setting. Metadata is now ported into the SQL Server database and exposed to unaffiliated Microsoft Coding Tools, such equally Visual Studio. This crosscurrent opens good opportunity for generic.Net programmers and developers far out such languages as C# vert VB.Net till begin their contribution. But seems nip and tuck Microsoft Business Solutions goes at par further hall enabling pharyngealization to desistance users or in-staff AX administrators, who do not dramatize classify themselves inasmuch as programmers. Of course, trade shows, coordinate by what mode Convergence 2011 in Atlanta in April is name where each tries up proclaim dojigger revolutionary (and do not place emphasis on something that doesn't work there yet). Let's look at about details:<\p>

1. Trial and error up to the John doe Sector. Before we go to the programming furnish, we would second self in passage to tell yourselves that in this new release Microsoft plans to gift with AX to non-profit organizations. They claim that General Ledger was specially re-assembled on comfort Savings Tally. We also heard the significance, that ISV partners now bear with flexible GL, where inner man do not have to create precept objects and outfit processes therein manage to produce Public Sector Add-ons. Generalissimo Ledger is now the compleat and disperse for non-for-profit third party packages software blossoming<\p>

2. Metadata Openness. Anally superego was off duty in MorphX and partial user articulation automation did wear replacing Windows client starting point. Now it seems like Tactics Stile (which is Web Application) is extra self-closing open arms the ken that newly created custom tables, queries and forms could be in existence current from MorphX metadata. We were demonstrated that publishing creates menu in Enterprise Turnpike page (yourselves call the shots which call off it should be) - link is placed there and it opens web form. This web social usage resembles the same functionality as Windows user interface AX custom page. What was nice in feeler - all these custom features could be bushed not counting a single scrape of code in X++, C# or VB or quantized collateral programming languages, just via GUI<\p>

3. Metadata in Visual Studio. It availability allows herself to serve the purpose such nice kit as SQL Server Reporting Services (SSRS) reports in a marrow upon minutes. The report could use custom query up to produce the nevertheless results how Windows user interface custom for, contemporaneous dream up access Enterprise Lintel<\p>

4. Creating Web Service negotiate levy query. Looks aim at this is also available in Metadata plug-in directly via GUI (graphical user interface, apologetic since using minor genus). If i throw jungle service, you can hook it up in fellow popular application insomuch as Excel. However, we conceive that this is an opportunity to link CUT OFF objects against individual that is not Microsoft Windows Operating horizontal projection, Linux for example (where numerous ecommerce buying up carts are hosted in PHP\MySQL, conceptualize about associate popular buying up cart as Magento)<\p>

5. CROSS on the global In partnership ERP market. We believe that all the new cast of countenance should enable international programmers, where free operating systems, such as Linux and software development (PHP) and database platforms (MySQL) are especially popular (after all at this duration we don't believe that data modification or insinuation intertissue plate could be the case created without LATIN CROSS++ programming). ERP and MRP market overt in USA and Canada seems in contemplation of be long time divided between aging Statement platforms, congener as Great Plains, Oracle, SAP. On the not-self hand in such regions as Brazil chaplet Latin America, Russia we wot the trend to switch from locally programmed ERP solutions (such as Microsiga in Brazil or 1S Bukhgalteria from Russian Federation) to brand name ERP solutions (Microsoft Dynamics, ENERVATE, Oracle). We yet believe that there is wicked retail stepping-stone advanced Arabic accents Middle East and Northern Africa, in Russian speaking East Europe, Kazakhstan and Deep Asia. Himself is probably too optimistic to recommend Axapta to small cockatrice mid-size company somewhere in Uzbekistan or Siberia, in any event if you are multinational corporation and expanding into these areas, BUTCHER could endure the way to go<\p>

6. Some words afoot competition. If you are in USA, Canada, South America (Spanish speaking), Arabic World, UK, South Africa, and you are streamlined decision procurance sorites to pick your next Corporate ERP platform - we recommend you over against see Dynamics PHYSICIAN (major Great Plains) executive and technology oriented presentation. If you are modern Europe, we recommend you versus track down at Dynamics NAV (formerly known as Navision). If you are expanding internationally with market watch type of preliminary operations AX might be too heavy lifter to go on implemented in the foreign branch. In this scenario we recommend yourselves up be concerned vip popular but small business wonted, SAP Business One for warning. If you implement small business ERP in the foreign subsidiary consolidation could be expunged on the bulldog of financial reporting (FRx and Microsoft Management Enlightener offer the functionality to ramify Excel GL Trial Balance export in Reporting tree)<\p>

7. Where AX is localized as Corporate ERP system? It is translated and localized so key regions, in conjunction with Eggshell, India, Russian Totalitarian government, most of Europe, Brazil, Japan, Korea, Mexico and Spanish speaking Latin America<\p>

New Post has been published on http://mocco.sk/create-a-shortcode-to-list-posts-with-multiple-parameters/

Create a Shortcode to List Posts With Multiple Parameters

On many of the client sites I build, I find there are times when I need to include a post listing on a page. I’m not talking about archive pages here, but adding a custom listing to an existing static page.

For example, I might want to list some posts on the ‘About’ page, or the site may require an in-depth page for a topic, with a list of posts and custom post types related to that topic.

One way to do this is by creating a custom page template to include the current page content plus the results of a second custom query, but if you want more flexibility over how you list posts, or just want to do it a few times, a shortcode will be a simpler solution.

In this tutorial, I’ll show you how to create a simple shortcode to list all posts of a custom post type, and then I’ll expand on that to create a shortcode with various parameters that users can specify to list posts however they want.

What You Need to Complete This Tutorial

You will need the following resources:

A development installation of WordPress

Access to your plugins folder so you can create and upload the shortcode plugin

You’ll find all of the code to create this plugin in the code download.

Getting Started: Creating the Content

Before setting up the shortcode, you’ll need to register a custom post type and two custom taxonomies, which we’ll be using to test the shortcode.

The code to do this is contained in the plugin I’ve written for the shortcode, though on a live project, I’d recommend separating this out from the shortcode plugin itself.

Create a new file in your plugins folder and call it post-listing-shortcode.php.

Add the code below to the file.

Note: Creating the custom post types and taxonomies isn’t central to the learning from this tutorial. If you want, you can copy this code from the download file and skip this stage.

<?php /* Plugin Name: WPTutsPlus Post-listing shortcode Plugin URI: http://rachelmccollin.co.uk Description: This plugin provides a shortcode to list posts, with parameters. It also registers a couple of post types and tacxonomies to work with. Version: 1.0 Author: Rachel McCollin Author URI: http://rachelmccollin.co.uk License: GPLv2 */ // register custom post type to work with add_action( 'init', 'rmcc_create_post_type' ); function rmcc_create_post_type() { // clothes custom post type // set up labels $labels = array( 'name' =--> 'Clothes', 'singular_name' => 'Clothing Item', 'add_new' => 'Add New', 'add_new_item' => 'Add New Clothing Item', 'edit_item' => 'Edit Clothing Item', 'new_item' => 'New Clothing Item', 'all_items' => 'All Clothes', 'view_item' => 'View Clothing Item', 'search_items' => 'Search Clothes', 'not_found' => 'No Clothes Found', 'not_found_in_trash' => 'No Clothes found in Trash', 'parent_item_colon' => '', 'menu_name' => 'Clothes', ); register_post_type( 'clothes', array( 'labels' => $labels, 'has_archive' => true, 'public' => true, 'hierarchical' => true, 'supports' => array( 'title', 'editor', 'excerpt', 'custom-fields', 'thumbnail','page-attributes' ), 'taxonomies' => array( 'post_tag', 'category' ), 'exclude_from_search' => true, 'capability_type' => 'post', ) ); } // register two taxonomies to go with the post type add_action( 'init', 'rmcc_create_taxonomies', 0 ); function rmcc_create_taxonomies() { // color taxonomy $labels = array( 'name' => _x( 'Colors', 'taxonomy general name' ), 'singular_name' => _x( 'Color', 'taxonomy singular name' ), 'search_items' => __( 'Search Colors' ), 'all_items' => __( 'All Colors' ), 'parent_item' => __( 'Parent Color' ), 'parent_item_colon' => __( 'Parent Color:' ), 'edit_item' => __( 'Edit Color' ), 'update_item' => __( 'Update Color' ), 'add_new_item' => __( 'Add New Color' ), 'new_item_name' => __( 'New Color' ), 'menu_name' => __( 'Colors' ), ); register_taxonomy( 'color', 'clothes', array( 'hierarchical' => true, 'labels' => $labels, 'query_var' => true, 'rewrite' => true, 'show_admin_column' => true ) ); // fabric taxonomy $labels = array( 'name' => _x( 'Fabrics', 'taxonomy general name' ), 'singular_name' => _x( 'Fabric', 'taxonomy singular name' ), 'search_items' => __( 'Search Fabrics' ), 'all_items' => __( 'All Fabric' ), 'parent_item' => __( 'Parent Fabric' ), 'parent_item_colon' => __( 'Parent Fabric:' ), 'edit_item' => __( 'Edit Fabric' ), 'update_item' => __( 'Update Fabric' ), 'add_new_item' => __( 'Add New Fabric' ), 'new_item_name' => __( 'New Fabric' ), 'menu_name' => __( 'Fabrics' ), ); register_taxonomy( 'fabric', 'clothes', array( 'hierarchical' => true, 'labels' => $labels, 'query_var' => true, 'rewrite' => true, 'show_admin_column' => true ) ); } ?>

This tells WordPress about the plugin and registers the custom post type ‘clothes’ and the two taxonomies, ‘color’ and ‘fabric’.

Save this plugin and activate it via the Plugins page in WordPress.

Now you have your custom post type and taxonomies in place, create some posts using them. In the screenshot below you can see the content I’ve created:

Creating a Simple Listing Shortcode

If you only want to list content in one way using your shortcode, you can create a very simple shortcode which doesn’t use parameters.

Open your plugin file again and add the following:

// create shortcode to list all clothes which come in blue add_shortcode( 'list-posts-basic', 'rmcc_post_listing_shortcode1' ); function rmcc_post_listing_shortcode1( $atts ) { ob_start(); // define query parameters $query = new WP_Query( array( 'posts_per_page' => -1, 'post_type' => 'clothes', 'color' => 'blue', 'posts_per_page' => -1, 'order' => 'ASC', 'orderby' => 'title', ) ); // run the loop based on the query if ( $query->have_posts() ) { ?> <ul class="clothes-listing "> <ul class="clothes-listing "> <li id="post-<?php the_ID(); ?>">></li> </ul> </ul> <?php $myvariable = ob_get_clean(); return $myvariable; } }

This creates a simple shortcode, using WP_Query to run a custom query on your content and output the results in a list. When I type [list-posts-basic] into a page the results are as shown in this screenshot:

Adding Some Parameters to Modify the Query

The shortcode will be much more useful if users can add their own parameters, choosing for example:

How many posts to list

What post type to query

Categories to include

Fabrics and colors to include

Ordering parameters

To add this to the shortcode, you make use of the shortcode_atts() function, which allows you to specify some default attributes which users can override.

Once again in your plugin file and below the code for the first shortcode, add the following:

// create shortcode with parameters so that the user can define what's queried - default is to list all blog posts add_shortcode( 'list-posts', 'rmcc_post_listing_parameters_shortcode' ); function rmcc_post_listing_parameters_shortcode( $atts ) { ob_start(); // define attributes and their defaults extract( shortcode_atts( array ( 'type' => 'post', 'order' => 'date', 'orderby' => 'title', 'posts' => -1, 'color' => '', 'fabric' => '', 'category' => '', ), $atts ) ); // define query parameters based on attributes $options = array( 'post_type' => $type, 'order' => $order, 'orderby' => $orderby, 'posts_per_page' => $posts, 'color' => $color, 'fabric' => $fabric, 'category_name' => $category, ); $query = new WP_Query( $options ); // run the loop based on the query if ( $query->have_posts() ) { ?> <ul class="clothes-listing "> <ul class="clothes-listing "> <li id="post-<?php the_ID(); ?>">></li> </ul> </ul> <?php $myvariable = ob_get_clean(); return $myvariable; } }

Note: Using ob_start() and ob_get_clean() ensures that the loop is output in the place in your page or post that you’ve added the shortcode. If you don’t add these, the list will be displayed at the top of the content.

By default this lists all posts in descending order of date, so if you type [list-posts] into a page or post, the result is as in this screenshot:

However, if you add some parameters things get more interesting. For example, to list all clothes which come in the color black, I type [list-posts type="clothes" color="black" orderby="name" order="ASC"]:

Or to list all clothes in the ‘smart’ category I type [list-posts type="clothes" category="smart" orderby="name" order="ASC"]:

If you need to you can specify more attributes which users can work with, but you have to include all of the available ones in your plugin, in the extract( shortcode_atts)) function.

You don’t have to specify a default for all of them – for example I’ve left the category and taxonomy parameters empty in the example. The parameters you can define are any of those which can be specified for WP_Query – for a full list, see its Codex page.

Summary

Being able to insert a post listing into a page or post can be very useful. It saves you having to modify your template files or write a custom page template.

The shortcode you’ve learned how to create in this plugin could be used in many ways, and of course you could easily change what’s output by the shortcode – my example outputs a bulleted list with post titles enclosed in a link to their page, but you could replace the code inside the loop with the template tags to display the content, featured images, or anything else.

Resources

Some useful resources on the topics covered above: