exactly
after more tests, the best request i found was :
SELECT * FROM `cdr` WHERE trunkid > 0 and extension = ''
and i have to look after "remoteparty" field to know for Outbound Call the callee and for Inbound Call the caller
If during the call, there was a lot of : hold, transfer, *52 for cellphone, etc... the results will be the summary of the call but the "from" and "to" field will be not correct afterall, so i check the "remoteparty".
In case of call in huntgroup or ivr node, with this request, il will not know which extension pick up the phone. In these cases, i have to do another request to have more detail.
What do you think about all this ???
i'll continue my tests and let you know if i'm good
Thx for your answers
Rudwolf