Search call data by id

[xuhualin99]

The following query is sent to the postgresql (seen from homer_app log) and its execution is taking a long time:
select * from hep_proto_1_call where create_date between $1 and $2 and id in (1.08390982591e+11) limit 200
Strangely there is no index or primary key for the id field by default. After index added, the performance is still not getting better. It turns out that since its value is in scientific notation (e+11), postgresql thinks it's numeric type (not bigint) and the index is not used. We wonder where and how in homer_app this value is specified. Is it in the GUI or in the driver? This query is likely generated when user clicks on a specific sip message (after getting all messages by call-id for example). Is it possible to specify the value as integer, like 108390982591? Thanks

[github-actions]

Your report is appreciated. Please star this repository to motivate its developers! ⭐