Listings Module Ignoring Custom Where Entries

Login with username, password and session length

[Cornelius Wasmund]

I have in "Category List" the breadcrumbs, Cat Title/Desc
http://www.4logistic.firma.cc/produkte/mobile-conputer-mde/mobile-computer

but in "Custom List" i missed this
http://www.4logistic.firma.cc/produkte/mobile-conputer-mde/mobile-computer/gun

Any Ideas where i can add this?

Category breadcrumbs are available only to Category List pages, no other menu item type can have them.

And SQL Selects are only available in Custom List?

[Kristian]

And SQL Selects are only available in Custom List?

Yes. When you use custom SQL queries, listings can be returned from any category, it is not possible to have the category breadcrumbs then.

[Cornelius Wasmund]

Okay. Bummer ...

Now i have insert the HTML Code of titel/desc and breadcump ... it is static ... but i do not have a better idea.

Thank you.

[Cornelius Wasmund]

I try this in Custom Where

Code:

Field.jr_mdemobilecomputergehaeuse LIKE '%gun%'
AND
jos_content.catid = '15'

Can i select the categorieid?

[Alejandro]

Code:

(Field.jr_mdemobilecomputergehaeuse LIKE '%*gun*%' AND Listing.catid = 15)

If your field is single select, better use:

Code:

(Field.jr_mdemobilecomputergehaeuse = '*gun*' AND Listing.catid = 15)

[Cornelius Wasmund]

I have a multi select field which is in 2 CATIDs.
I can select all, but the counting (XX Summary) is false.

http://4logistic.firma.cc/produkte/barcodescanner/industrie

Code:

(Field.jr_scannerfunkeinsatzgebiet LIKE '%industrie%'
AND
Listing.catid = 19)
OR
(Field.jr_scannerkabeleinsatzgebiet LIKE '%industrie%'
AND
Listing.catid = 20)
AND
Field.jr_scannerkabeleinsatzgebiet <> ""
AND
Field.jr_scannerfunkeinsatzgebiet <> ""
AND
Field.jr_scannerkabeleinsatzgebiet is not null
AND
Field.jr_scannerfunkeinsatzgebiet is not null
AND
Listing.catid <> 17

Any Ideas where i can make this better?

Best Regards,
Cornelius

[Alejandro]

You should put the whole code in a single line without pressing ENTER. You can also change it like this:

Code:

(Field.jr_scannerfunkeinsatzgebiet LIKE '%industrie%' AND Listing.catid IN (19,20) AND Field.jr_scannerkabeleinsatzgebiet <> "" AND Field.jr_scannerfunkeinsatzgebiet <> "" AND Field.jr_scannerkabeleinsatzgebiet IS NOT  NULL AND Field.jr_scannerfunkeinsatzgebiet IS NOT NULL)

No need to include Listing.catid <> 17 if you are already filtering by cat ids 19 and 20.

[Cornelius Wasmund]

Great! Thx. It Works.