Format Currency and Grouping

Hello,

Formatting currency sounds like a useful feature, so I added it in the latest plugin update. It’s used like this:

[field field_name currency="USD"]

It doesn’t output the currency symbol, only formats the given number, for example: 2,500.00. Custom format is also possible. Please refer to the documentation under Settings -> Custom Content -> Content -> Currency.

—

By the way, in the support forum, you can post code wrapped with “backtick” symbol to avoid formatting it.

—

For your second question:

I would like to have condos in a neighborhood sort by Condo Name and other attributes such as amount of bedrooms, etc.

For grouping content, you can use taxonomies or fields. Currently, the plugin supports queries up to 2 taxonomies and 3 fields at one time. If you could tell me the specific condition you need – for example, 2 bedrooms – then I can try to find the right parameters to set.

I looked at the site you mentioned – I see there’s quite a lot of data, and numerous fields to consider. For this level of complex query, it might be necessary (and maybe quicker) to use PHP to set up custom SQL statements, to get exactly the result you need.

As you see, this plugin provides a simplified syntax for WP_Query, WP_User_Query, etc. It has most of the basic functions, but not all of the advanced query parameters are implemented yet.

Looking at the query you posted above: at this point the following features are not in the plugin:

• query by more than 3 fields
• group by fields
• order by more than one field

I think setting up the same query with WP_Query would be a challenge, and even more difficult to achieve it with shortcodes.

—

About the [raw] shortcode, it needs to be enabled in the settings page. After that, you can wrap blocks of code, and it will not get formatted. Then you can have shortcodes that span multiple lines, like:

[raw]
  [loop type="property"]
    [field building]
  [/loop]
[/raw]

—

All that said, it would still be interesting to see if the plugin could be extended to achieve the result you want. It may be possible by adding some parameters to [loop] and [if].

So, one of the scenarios you have is:

Condo Buildings within a City, Zip Code that have 1,2,3 bedrooms priced between $100,000-$200,000

..and if I were to imagine it represented in shortcode..

[loop
  type="property"
  field="city" value="Fort Lauderdale"
  field_2="zip" value_2="78704"
  field_3="price" value_3="100000-200000" compare="between"
  orderby="field" key="bedrooms"]

  ..Display fields..

[/loop]

Right now this code will not work, but I think the only feature missing is to query by a range of field values with between. I’ll look into how this can be achieved.

Hello,

In the newest plugin update, I added a feature to compare a range of field values. It’s used like this:

[loop type="property" field="price" value="10000,20000" compare="between"]

Also, I improved support for multiple field value queries, up to 5.

—

I’m looking into the other features you mentioned: group by field, and order by more than one field. As I said, I think these are not natively supported by WP_Query, so it might be an effort to implement them. I noticed that recent versions of WordPress has improved/extended queries, so I’ll see if there’s a solution there.

—

Meanwhile, you may be able to achieve what you need by using the [pass] shortcode. The documentation for it is a bit hard to find, in the section called Other.

For example, to use a list to make grouped queries:

[pass list="1,2,3"]
  [loop type="property" field="bedrooms" value="{ITEM}"]
    [if first]
      Properties with {ITEM} bedrooms:
    [/if]
    [field title]
    ...
  [/loop]
[/pass]

The [if first] clause is used to display group heading, if there’s any post that matches the query.