Use id column to build Details link

[vini]

Hello,

Is it possible to use raw table column like `id` to build the "Details" link?
For example, I have a page with metamodel listing: http://domain.tld/people/

I want the "Details" link to be: http://domain.tld/people/5212

In the demo installation "Movie Database" they use aliases for that, but I don't want to create redundant data when the simple ID is enough for me. And even if I wanted to use aliases, I can't figure out the way to mass-generate them. I have a database with 6000+ records, can't possible generate them one by one.

[zonky]

You can use the alias Attribute with id as value... but its not possible to use a integer as alias. Contao add ‚id-‚ automaticaly.. you can use an Owen prefix

[vini]

In that case – how do I generate the aliases for the existing 6000+ records?
Or any other attribute, for example – combined values?

[zonky]

If you use the latest MM Version, you can try the „multipe editing“ with edit all - or you build the value in phpmyadmin

[vini]

There is no "Generate aliases" button in MetaModels, like in Contao for Pages, for example. So, now the only way to do it is check the "Always save" checkbox in Input screen, and then "Edit multiple" records. Overriding is not possible, since alias is unique, and php can't handle editing of 6000 records at once, the only option is to edit them in portions, like every 50 records... It's unthinkable
Same goes for adding "Combined values" attribute to existing MetaModels btw - because those only generated on save, not on render.

May be I should post a feature request on Github?

[zonky]

There is no "Generate aliases" button in MetaModels, like in Contao for Pages, for example. So, now the only way to do it is check the "Always save" checkbox in Input screen, and then "Edit multiple" records. Overriding is not possible, since alias is unique, and php can't handle editing of 6000 records at once, the only option is to edit them in portions, like every 50 records... It's unthinkable
Same goes for adding "Combined values" attribute to existing MetaModels btw - because those only generated on save, not on render.

May be I should post a feature request on Github?

Currently, the only way is to use „Edit multiple“... you can add your wishes as FR in Github..

It‘s not possible to use phpMyAdmin?

[zonky]

another way would be to bypass the attribute Alias...

You can find the ID in your template in the array node [raw] (see http://metamodels.readthedocs.io/en/...templates.html) and create your own URL to the detail page - there you can catch the ID with a filter rule "Own SQL"... that's it!

[vini]

another way would be to bypass the attribute Alias...

You can find the ID in your template in the array node [raw] (see http://metamodels.readthedocs.io/en/...templates.html) and create your own URL to the detail page - there you can catch the ID with a filter rule "Own SQL"... that's it!

This actually worked! Thank you for the idea.

Just for the reference:

1. The filter type is "Custom SQL"

2. Actual query looks like this:

SELECT id FROM {{table}} WHERE id={{param::get?name=auto_item}}

3. The details link in the template is built like this:

<a href="<?= $arrItem['jumpTo']['url'] . '/' . $arrItem['raw']['id'] ?>"></a>

[zonky]

SELECT id FROM {{table}} WHERE id={{param::get?name=auto_item&default=0}} 

if auto_item not set