AnsweredAssumed Answered

CMX 10.2 History Client

Question asked by jesalcido1 on Apr 25, 2016
Latest reply on May 31, 2016 by simpki001

Hi,

 

I have the next issue with CMX 10.2.1-219

 

I need retrieve all the history Client from API but the response is an error with code 500

 

Error:

PRIMARY KEY column "changedon" cannot be restricted (preceding column "key" is either not restricted or by a non-EQ relation)

 

I tried the next calls with the same error:

 

http://myHostCMX/api/location/v1/history/clients

http://myHostCMX/api/location/v1/history/clients?mapHierarchy=MyBuilding>MyCampus>MyFloor

http://myHostCMX/api/location/v1/history/clients?mapHierarchy=MyBuilding>MyCampus>MyFloor&pageSize=10&page=1&sortBy=lastLocatedTime:ASC?lastLocatedTime=2016-04-08T01:37:38.519-0700&beforeLocatedTime=2016-04-08T01:37:38.519-0700

 

The only way for get information is call the RESTFul with the parameter MacAddress however I need get all the macAddress.

 

http://myHostCMX/api/location/v1/history/clients/XX:XX:XX:XX:XX:XX

 

I tried to get all the macAddress with this

 

http://myHostCMX/api/location/v2/clients?sortBy=lastLocatedTime:ASC?page=x&pageSize=100

 

but the response is only for Active MacAddress

 

Please do you know if this is a bug or something is wrong with the parameters?

 

thanks for your time.

Outcomes