migxdb migxLoopCollection and getresourcefield

230 Posts

MacConin Reply #1, 10 years, 10 months ago

I have - simplified- a table with IDs of resources in a migx_table

[[+id-of-a-resource]] stores Ids of some resources

Now I want to output the pagetitle of these ids

[[!migxLoopCollection?
&packageName=`list-of-something`
&classname=`list-of-something`
&tpl=`@CODE:Name of resource is: [[getResourceField? &id=`[[+id-of-a-resource]]`]]`
]]

That does not work - it's monday - and I'm a blockhead

CONIN Werbeagentur . Köln
http://www.conin.de

5,888 Posts

Bruno17 Reply #2, 10 years, 10 months ago

first off. Does this output anything?

[[!migxLoopCollection?
&packageName=`list-of-something`
&classname=`list-of-something`
]]

If so. What?

And how does your db-schema look like for that table.
Perhaps we can do a join and we can get the pagetitles with one db-query together with the table's fields.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

230 Posts

MacConin Reply #3, 10 years, 10 months ago

Moin,

If I change the code to

[[!migxLoopCollection?
&packageName=`list-of-something`
&classname=`list-of-something`
&tpl=`@CODE:Name of resource is: [[getResourceField? &id=`3`]]`
]]

the getresource-call is rendered and everything is fine.

the [[+id-of-a-resource]] is an integer.

CONIN Werbeagentur . Köln
http://www.conin.de

5,888 Posts

Bruno17 Reply #4, 10 years, 10 months ago

not sure, if you have an aggregate to modResource with an alias for example of 'Resource' in your db-schema.

If so, you can try:

[[migxLoopCollection?
&packageName=`list-of-something`
&classname=`list-of-something`
&joins=`[{"alias":"Resource","selectfields":"id,pagetitle"}]`
&tpl=`@CODE:Name of resource is: [[+Resource_pagetitle]]`
]]

If not you can join with:

[[migxLoopCollection?
&packageName=`list-of-something`
&classname=`list-of-something`
&joins=`[{"alias":"Resource","classname":"modResource","on":"Resource.id=list-of-something.id-of-a-resource","selectfields":"id,pagetitle"}]`
&tpl=`@CODE:Name of resource is: [[+Resource_pagetitle]]`
]]

this should be faster than having a getResourceField - call at each row.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

230 Posts

MacConin Reply #5, 10 years, 10 months ago

Hi Bruno,

sry for the delay. will check that out. many thx.

Wenn's funkt, haste ein Kölsch bei mir gut.

CONIN Werbeagentur . Köln
http://www.conin.de