Hi Samuele,

>> Mmmh. what do you have if you type:
>> 
>> $ echo "select a.*, b.* from accROLE_accACTION_accARGUMENT as a join
>> accACTION on id_accACTION=accACTION.id join accARGUMENT as b on
>> id_accARGUMENT=b.id where name='submit'" | /opt/invenio/bin/dbexec
>> 
>> For example on vanilla Invenio you would obtain:
>> 
>> id_accROLE      id_accACTION    id_accARGUMENT  argumentlistid
>> id      keyword value 19      33      8       1       8       categ
>> * 19      33      11      1       11      doctype DEMOJRN
>> 19      33      12      1       12      act     SBI
>> 19      33      8       2       8       categ   *
>> 19      33      11      2       11      doctype DEMOJRN
>> 19      33      13      2       13      act     MBI
>> 18      33      19      1       19      categ   ARTICLE
>> 18      33      20      1       20      doctype DEMOART
>> 18      33      12      1       12      act     SBI
>> 
>> Which shows that to every id_accROLE+argumentlistid there is a
>> triplet.
>
> I have this result:
>
> id_accROLE      id_accACTION    id_accARGUMENT  argumentlistid  id
> keyword value 4       12      2       1       2       doctype ARTCIE  
> 4       12      5       1       5       act     SBI  
> 5       12      4       1       4       doctype EXAMEN  
> 5       12      5       1       5       act     SBI  
> 6       12      6       1       6       doctype DOCEMP  
> 6       12      5       1       5       act     SBI  
> 7       12      7       1       7       doctype EXPBIB
> 7       12      5       1       5       act     SBI
> 8       12      5       1       5       act     SBI
> 8       12      9       1       9       doctype FOTO 
> 9       12      10      1       10      doctype LLIBRES 
> 9       12      5       1       5       act     SBI  
> 10      12      13      1       13      doctype AUDVID
> 10      12      5       1       5       act     SBI
> 1       12      14      -1      14      categ   *  
> 4       12      14      1       14      categ   *  
> 5       12      14      1       14      categ   *  
> 6       12      14      1       14      categ   *  
> 7       12      14      1       14      categ   *  
> 8       12      14      1       14      categ   *  
> 9       12      14      1       14      categ   *  
> 10      12      14      1       14      categ   *
> 11      12      14      1       14      categ   *
> 11      12      16      1       16      doctype TFG
> 11      12      5       1       5       act     SBI
>
> Does it help?  Sorry I cannot understand the meaning of the results.

Any updates?  Can I do anything else?

Thanks,

Ferran, yes and yes! :-)

Reply via email to