Hei Antti
Thanks again for your kind help.
1) for example I tried: [code]title like '%light%' ORDER BY 'title' ASC[/code]
2) [url]http://i.imgur.com/8a8T6FW.png[/url] Here is an example structure of my
data. Please mind that they don't corespondent with the query in 1) since I
used that in the
Jay,
1) Please post here again the query you insert into the dialog.
2) What do your full PDF document names and titles look like? Can you give us
couple of examples? If possible, upload couple of your assets to our live demo
site at demo.magnolia-cms.com and add the stkDownloadList component t
Hei Antti,
I used the demo-project assets (and accordingly your string) to use the same
queries as you. I just inserted the downloadlist in my own website (test site).
But I also tried the same in the demo-project as well and also with my very own
assets (the '%SV%' query), with the same result
Jay,
In your example you try to find Handbücher & Anleitungen that have the string
"light" in their title. It's unlikely that your PDF assets have that string. It
was just an example string I used. Weren't you originally querying for a title
like 'SV%'? Secondly, are your assets under the /dem
...ah damn, wrong URLs for the images.
Here we go:
JCR Querry App: [img]http://i.imgur.com/IIXKxIT.png[/img]
Dialog Input: [img]http://i.imgur.com/bFHLnFH.png[/img]
Result in the Page: [img]http://i.imgur.com/DtT1xLE.png[/img]
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread
Hei Antti
Thanks a million for your detailed answer! Much appreciated!
I tried your queries (and some variations) but i don't get the desired results.
When I use the JCR Query App all works fine:
JCR Querry App: [img]http://imgur.com/bFHLnFH,IIXKxIT,DtT1xLE#1[/img]
But as soon as I use the dialo
Hi Jay,
So your query returns results but not in the right order?
Create the query first in the Dev > JCR Queries app. It's faster to work with.
When the query returns the correct results, copy the WHERE clause to your
stkDownloadList component.
Be careful with quotes! Some properties have col
Does anyone by chance have more suggestions/tips on this?
I am still stuck on this and couldn't find anything in the documentation.
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=551a3707-98cd-4a1d-ae68-85fb21d55a95
-
sorry, i meant:
On the other hand when I use:
[code]title like "SV%"[/code]
I get 5 files.
in the first code example.
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=551a3707-98cd-4a1d-ae68-85fb21d55a95
--
Hej Jozef,
Thanks for your reply. I tried exactly that query in the Inputfield 'Query' in
the DownloadList-component though I get no files in the list.
On the other hand when I use: [code]title like "SV%" ORDER BY title ASC;[/code]
I get 5 files.
I've read, that in the Download List component
Hi,
'table' in "FROM table" is node type, so the most general query is
[code]SELECT title FROM nt:base WHERE title like "SV%" ORDER BY title
ASC;[/code]
The nt:base is the root of all node types, an equivalent of the Object class in
Java.
Jozef.
--
Context is everything:
http://forum.magno
Here I must pass. Currently I'm not familiar with Magnolia CMS Database
structure. Someone else has to answer this question.
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=551a3707-98cd-4a1d-ae68-85fb21d55a95
Thanks a milion, Tobias!
Do you know where can I find the specific 'table' (...FROM 'XY'...) within the
Magnolia structure? Like let's say for a specific Downloadlist? Can I use the
nodename?
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=551a3707-98cd-4a1d
[code] SELECT title FROM ... WHERE title like "SV%" ORDER BY title ASC; [/code]
[code] SELECT title FROM ... WHERE title like "SV%" ORDER BY title DESC; [/code]
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=551a3707-98cd-4a1d-ae68-85fb21d55a95
-
Since I don't have much experience with SQLs I just used examples from
'googeling' and by try and error.
I have no clue how to adress the sorting within Assets/JCR but i just tried an
alphabetic ordering by simply use:
title like 'SV%' ORDER BY 'title'
But it seems that it doesn't like the 'OR
Hello Jürg Rinaldi,
is it possible to show us your sql query?
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=551a3707-98cd-4a1d-ae68-85fb21d55a95
For list details, see http://www.magnolia-cms.
16 matches
Mail list logo
