LoginHistory: Workaround for Filtering Query on Application Field

Question

Hi guys,

I'm trying to filter a SOQL query on the LoginHistory object using the Application field. Apprrently, this is not possible since 'Application' is not filterable (curious as to why that is.) I'm wondering if there is any workaround to this limitation, assuming I need to filter the information in Application to achieve my goal.

Thanks!

Alain Cabon · Accepted Answer

@Yissochor Eisenberg

There are three other objects: LoginEvent, LoginGeo and LoginIp.

But the field Application is never filterable par SOQL.

So the only trivial workarounds are the export of the login history (csv+java./python) ( Setup > Login History ) or to use a filter on another field like the logintime.

select id, userid, logintime, application from loginhistory where logintime = THIS_MONTH

A batch can also read the LoginHistory object regularly and load a new custom object where the new field Application__c is now filterable (or by using dataloader reloading the exported csv file).

Sochy Eisenberg · Answer

Thank you, Alain!

LoginHistory: Workaround for Filtering Query on Application Field

Apex

相关学习

更多帮助