etc_query: all things Textpattern

progre55 · 2012-08-02 17:38:27

Ok … I can answer that — give me a second —-

progre55 · 2012-08-02 17:47:29

glz_custom_fields stores it data in a seperate table called custom_field — the multi-select data is stored no differently that I can tell than the drop down data — just invidiual rows with values —-

An example would be:

Last edited by progre55 (2012-08-02 17:50:33)

etc · 2012-08-02 17:53:29

Ah, pity. I hoped it was in textpattern table, something like XMRadio, Moon Roof. Then we need the table structure: what are its fields?

progre55 · 2012-08-02 17:57:51

Actually — there are only three fields in the table: ID | NAME | VALUE — as you can see from below —- the drop down (Price) custom_3 is no different than the multi-select custom_4

Last edited by progre55 (2012-08-02 17:58:41)

etc · 2012-08-02 18:08:13

Ok, and can you retrieve articles by multi-select: <txp:article_custom custom_4_set="XMRadio,MoonRoof" /> or something like this?

progre55 · 2012-08-02 18:32:07

Using this <txp:article_custom custom_4_set="XMRadio,MoonRoof" /> did not work —

So I used this <txp:article_custom Price="25000" /> and it worked — which I know is a drop down field but wanted to make sure I could move the ball forward — so I think using the field name is the way to go —

The I tried this <txp:article_custom Features="XMRadio,MoonRoof" /> and unfortunately it returned nothing —-

progre55 · 2012-08-02 18:34:58

One thing to note — if I use this <txp:article_custom Features="" /> it does return the articles that are not using that Custom Field

etc · 2012-08-02 18:42:03

Maybe it was Moon Roof (with a space), sorry. Anyway, do ID correspond to articles’ ID?

progre55 · 2012-08-02 18:49:09

ID appears to be just a unique identifier and does not correspond to Article ID.

Last edited by progre55 (2012-08-02 18:49:20)

progre55 · 2012-08-02 18:54:57

Also, what I discovered is that this will return a result <txp:article_custom Features="XMRadio" /> if the article does not have any other features selected

etc · 2012-08-02 19:26:47

Well, and what is in custom fields of textpattern table, for example in Features?

progre55 · 2012-08-02 19:34:38

XMRadio|Moon Roof

etc · 2012-08-02 19:44:05

Yay! just wait few minutes.

progre55 · 2012-08-02 19:57:40

Very cool. Looking forward to seeing it.

etc · 2012-08-02 20:01:19

Let’s try this:

re-download the latest etc_query
change your inputs like this (note the brackets after Features):

<INPUT NAME="Features[]" TYPE="CHECKBOX" <txp:if_variable name="Features" value="XMRadio">selected</txp:if_variable>value="XMRadio">XMRadio<BR>
<INPUT NAME="Features[]" TYPE="CHECKBOX" <txp:if_variable name="Features" value="Moon Roof">selected</txp:if_variable>value="Moon Roof">Moon Roof<BR>

Don’t pass Features through adi_gps, but (without linebreaks)

<txp:variable name="Features"><txp:etc_query globals="_GET" data="{?Features||doarray($,htmlspecialchars).implode(|,$)}" markup="raw" argsep="," /></txp:variable>

Then do as before

<txp:etc_query globals="variable" data="{?Model}{?Color}{?Price}{?Features}">
  <txp:article_custom
    {$?({?Model}|Model='<txp:variable name="Model" />'|)}
    {$?({?Color}|Color='<txp:variable name="Color" />'|)}
    {$?({?Price}|Price='<txp:variable name="Price" />'|)}
    {$?({?Features}|Features='<txp:variable name="Features" />'|)}
  />
<txp:else />
  <txp:article />
</txp:etc_query>

Textpattern CMS

Textpattern CMS support forum

#61 2012-08-02 17:38:27

Re: etc_query: all things Textpattern

#62 2012-08-02 17:47:29

Re: etc_query: all things Textpattern

#63 2012-08-02 17:53:29

Re: etc_query: all things Textpattern

#64 2012-08-02 17:57:51

Re: etc_query: all things Textpattern

#65 2012-08-02 18:08:13

Re: etc_query: all things Textpattern

#66 2012-08-02 18:32:07

Re: etc_query: all things Textpattern

#67 2012-08-02 18:34:58

Re: etc_query: all things Textpattern

#68 2012-08-02 18:42:03

Re: etc_query: all things Textpattern

#69 2012-08-02 18:49:09

Re: etc_query: all things Textpattern

#70 2012-08-02 18:54:57

Re: etc_query: all things Textpattern

#71 2012-08-02 19:26:47

Re: etc_query: all things Textpattern

#72 2012-08-02 19:34:38

Re: etc_query: all things Textpattern

#73 2012-08-02 19:44:05

Re: etc_query: all things Textpattern

#74 2012-08-02 19:57:40

Re: etc_query: all things Textpattern

#75 2012-08-02 20:01:19

Re: etc_query: all things Textpattern

Board footer