Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Web service - ReportedByUsername

web-app

Hello,
i am calling gemini web services, but when i try to create new issue using web service 'CreateIssue', with attribute 'ReportedBy' it work properly. But I like to use username instead 'ReportedByUsername' and got always error :

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'username', table 'CrossAd.dbo.issuehistory'; column does not allow nulls. INSERT fails.

Can you help me please ?

nemecpav
· 1
nemecpav
Replies (3)
helpful
0
not helpful

Not sure I understand, can you post sample code?

You have to enter the reported by when creating the issue.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Yes, probably little confused question. I am using Gemini web services and I call them from another system. Maybe better question is "Can I replace ReportedBy by ReportedByUsername element ? Because in the system which use Gemini web services i know user names, but not gemini user id and I don´t like to add attribute "gemini user id" into my system. Is there some way to use only user name here ?  On other hand, why there is in this web service CreatedByUsername element ? Thanks for answer

sample code in PHP:
$newIssue = array(
        'ProjectID'           => $ProjectVersionID,
        'DateCreatedString'=> $DateCreatedString,
        'IssueType'           => $IssueType,
        'IssuePriority'    => $IssuePriority,
        'ReportedBy'=> $ReportedBy,
        'AssignedTo'     => $AssignedTo,
        'IssueSummary'    =>$IssueSummary,
        'IssueLongDesc'    => $IssueLongDesc
        );

What I need is
$newIssue = array(
        'ProjectID'           => $ProjectVersionID,
        'DateCreatedString'=> $DateCreatedString,
        'IssueType'           => $IssueType,
        'IssuePriority'    => $IssuePriority,
        'ReportedByUsername'=> $ReportedByUsername,
        'AssignedTo'     => $AssignedTo,
        'IssueSummary'    =>$IssueSummary,
        'IssueLongDesc'    => $IssueLongDesc
        );


nemecpav
· 1
nemecpav
helpful
0
not helpful

Unfortunately, this is not possible. The reported by user name is a derrived field that gets populated by the Gemini application.


Mark Wing
· 9108
Mark Wing