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

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

Board footer