[Registry-dev] [jira] Resolved: (REGISTRY-323) Advance Search: Can not filter the results by "Created by" filed.

[Chathura Ekanayake (JIRA)]

     [ https://wso2.org/jira/browse/REGISTRY-323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathura Ekanayake resolved REGISTRY-323.
-----------------------------------------

    Resolution: Fixed

This is caused because some parts of the generated SQLs are not modified to suite the new data model. Fixed it.

> Advance Search: Can not filter the results by "Created by" filed.
> -----------------------------------------------------------------
>
>                 Key: REGISTRY-323
>                 URL: https://wso2.org/jira/browse/REGISTRY-323
>             Project: WSO2 Registry
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.1
>         Environment: WinXP, apache-tomcat-6.0.14,jdk-1_5_0_13,FF 2.0
>            Reporter: Krishantha Samaraweera
>            Assignee: Chathura Ekanayake
>            Priority: Critical
>         Attachments: authour_search.JPG
>
>
> Advance Search: Can not filter the results by "Created by" filed. System displayed following message when I try to search by "Created by" filed.
> Failed to execute query /system/queries/advanced01000000000. All database operations will be rolled back. Column 'R.AUTHOR' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'R.AUTHOR' is not a column in the target table.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira