I am trying to access Username field (which is present in User Object) Using LoginHistory Object as follow:
SELECT+Username+FROM+LoginHistory
but is shows below error:
[{"message":"\nSELECT Username FROM LoginHistory\n ^\nERROR at Row:1:Column:8\nNo such column 'Username' on entity 'LoginHistory'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.","errorCode":"INVALID_FIELD"}]**
also tried nested SOQL Query as :
SELECT+CountryIso,(SELECT+Username+FROM+User)+FROM+LoginHistory+limit+10
then also getting error.
How do I fix this error?