UDT to make a query to content prop_name

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
uloloi
Forum Members
Forum Members
Posts: 88
Joined: Thu Dec 16, 2010 8:50 pm

UDT to make a query to content prop_name

Post by uloloi »

Hi, at the start publishing of a cmsms site I suggested to the editor to use into a cms_content_prop / prop_name : extra1 a string to recognize from which number of magazine publishing belongs this article, then she was just writing something like 'Boletin No. 207', 'Boletin No. 208', in few articles it was forgotten to be put! etc... Well, because the growing of the site, it is needed to make an adjustment, just use into this extra1 field a number value, that's all.

Now, how can I use an UDT to locate all articles that contains in extra1 the same value?, something like using tags, but using extra1 and content_props of the cms_content

I'm searching results for this:

cms_content
- prop_names : target,image,thumbnail,extra1,extra2,extra3,search

cms_content_props
- prop_name : extra1
- content : %Bolet%170%

Well, I want to find all the articles which has filled in the extra1 some string LIKE Boletin No. 170
uloloi
Forum Members
Forum Members
Posts: 88
Joined: Thu Dec 16, 2010 8:50 pm

Re: UDT to make a query to content prop_name

Post by uloloi »

Continuing with further details with the table cms_content...

It is impossible to upgrade to version 1.11.2 from a website done in cmcms in version 1.9. +, NO! can not this simply sends errors.

I want-or pretend-update a website that is now online, the problem with this is that the table has enough information cms_content, many articles, and many news categories_n_items are already published. What can be done? What do you recommend? I can not create a database with new tables of version 1.11.2 and then import a table cms_content the database from the previous version.

Obviously this means take the group of editors, design templates applied, my UDTs, plugins, etc

UGH! Any help?
Post Reply

Return to “The Lounge”