Forum OpenACS Q&A: Re: List Reference Data - Request Error

Collapse
Posted by Randy Ferrer on

Ok - Fixed this by adding a distinct operator like so:

 select distinct repository_id,
    table_name,
    internal_data_p,
    package_name,
    last_update,
    source,
    source_url,
    effective_date,
    expiry_date,
    maintainer_id
    from acs_reference_repositories r,cc_users u
    where repository_id= :repository_id

Is anyone doing any work to complete the UI???