SELECT distinct a.Societa as soc, a.IDSocieta, a.eliminato from protocollo p INNER JOIN anagrafica a ON a.IDSocieta = p.IDSocieta_mitt where p.flusso = 'in' and a.IDsocieta <> #session.ID_az_# UNION SELECT distinct a.Societa as soc, a.IDSocieta, a.eliminato from protocollo p INNER JOIN anagrafica a ON a.IDSocieta = p.IDSocieta_dest where p.flusso = 'out' and a.IDsocieta <> #session.ID_az_# UNION SELECT distinct a.Societa as soc, a.IDSocieta, a.eliminato from protocollo p INNER JOIN anagrafica a ON a.IDSocieta = p.IDSocieta_dest where p.flusso = 'arc' order by soc SELECT distinct IDSocieta, soc as Societa, eliminato from Soc_tutte order by soc SELECT * FROM doc_tipo order by doc_tipo SELECT * FROM doc_formato order by doc_formato SELECT * FROM doc_pertinenza

Cerca nel protocollo

Protocollo

aammgg####

Data:

Flusso

checked>Tutti checked>Entrata checked>Uscita checked>Archivio

Tipo documento

Formato

Pertinenza

Mittente/destinatario

Titolo

Parola chiave

Descrizione

SELECT p.*, dp.*, dt.*, df.* from (((protocollo p INNER JOIN doc_pertinenza dp ON dp.ID_doc_pertinenza = p.ID_doc_pertinenza) INNER JOIN doc_formato df ON df.ID_doc_formato = p.ID_doc_formato) INNER JOIN doc_tipo dt ON dt.ID_doc_tipo = p.ID_doc_tipo) where p.IDprotocollo > 0 and p.protocollo = #num_prot_# and p.data = #createODBCdate(data_prot_)# and p.Descrizione like '%#trim(form.Descrizione)#%' and p.titolo like '%#trim(form.titolo)#%' and p.keyword like '%#trim(form.keyword)#%' and p.data >= #createODBCdate(dateformat(form.data_da, "dd/mm/yyyy"))# and p.data <= #createODBCdate(dateformat(form.data_a, "dd/mm/yyyy"))# and p.ID_doc_pertinenza = #form.ID_doc_pertinenza# and p.ID_doc_formato = #form.ID_doc_formato# and p.id_doc_tipo = #form.id_doc_tipo# and p.flusso = '#form.flusso#' and (p.IDSocieta_mitt = #form.IDSocieta# or p.IDSocieta_dest = #form.IDSocieta#) ORDER BY p.data desc, p.Protocollo desc SELECT distinct IDfile as IDfiles from elenco where IDfile > 0 UNION SELECT distinct IDfile2 as IDfiles from elenco where IDfile2 > 0

>Risultato della ricerca SELECT IDSocieta, Societa, eliminato FROM anagrafica SELECT IDutente, nome, cognome FROM utenti select * from files where IDfile IN (#IDfiles#,0) SELECT nome, cognome FROM addetti where IDutente = #elenco.IDutente_ins# SELECT Societa FROM aziende WHere IDSocieta = #elenco.IDSocieta_mitt# SELECT Societa FROM aziende WHere IDSocieta = #elenco.IDSocieta_dest# SELECT * from cerca where name = '#num_protocollo#.pdf' SELECT * from allegati where IDfile = #IDfile# SELECT * from allegati where IDfile = #IDfile2#

N°

data

Utente

Titolo

Mitt

Dest

Tipo

Formato

Pertinenza

#num_protocollo##Doc_pert_settore#

#dateformat(data, "dd/mm/yyyy")#

#datiutente.Cognome# #left(datiutente.nome,1)#.