RobiWan
Themenersteller
Und hier so ein Beispiel wie man die Bilder aus einer Collection (Album) bekommt.
zuerst eine Abfrage nach den collections
select z_pk from zcollection where zname = "Hier Name des Albums";
dann:
select distinct ZPATHLOCATION.ZWINROOT || ZPATHLOCATION.ZRELATIVEPATH || "\" || ZIMAGE.ZIMAGEFILENAME as fullFileName
from ZPATHLOCATION
join ZIMAGE on ZPATHLOCATION.Z_PK = ZIMAGE.ZIMAGELOCATION
join ZIMAGEINCOLLECTION on ZIMAGE.Z_PK = ZIMAGEINCOLLECTION.ZIMAGE
join ZVARIANT on ZIMAGE.Z_PK = ZVARIANT.ZIMAGE
join ZVARIANTLAYER on ZVARIANT.Z_PK = ZVARIANTLAYER.ZVARIANT
join ZVARIANTMETADATA on ZVARIANTLAYER.Z_PK = ZVARIANTMETADATA.ZLAYER
where zcollection = 'Hier kommt die Nummer aus der erster Abfrage';
zuerst eine Abfrage nach den collections
select z_pk from zcollection where zname = "Hier Name des Albums";
dann:
select distinct ZPATHLOCATION.ZWINROOT || ZPATHLOCATION.ZRELATIVEPATH || "\" || ZIMAGE.ZIMAGEFILENAME as fullFileName
from ZPATHLOCATION
join ZIMAGE on ZPATHLOCATION.Z_PK = ZIMAGE.ZIMAGELOCATION
join ZIMAGEINCOLLECTION on ZIMAGE.Z_PK = ZIMAGEINCOLLECTION.ZIMAGE
join ZVARIANT on ZIMAGE.Z_PK = ZVARIANT.ZIMAGE
join ZVARIANTLAYER on ZVARIANT.Z_PK = ZVARIANTLAYER.ZVARIANT
join ZVARIANTMETADATA on ZVARIANTLAYER.Z_PK = ZVARIANTMETADATA.ZLAYER
where zcollection = 'Hier kommt die Nummer aus der erster Abfrage';