[Solved] Looking for an example of the status filter for EVEONLINE.CHARACTER_INDUSTRY_JOBS()

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

As the title says I am looking for an example of how to filter by the status of industry jobs. The function presents industry jobs with active, delivered and cancelled statuses from what I have seen. However, if I am interested in seeing only active jobs I feel like I should be running something like EVEONLINE.CHARACTER_INDUSTRY_JOBS(,active,) as the addin explains that to filter the status we need to use a string, as opposed to a number.

image

Clearly I am misunderstanding something, so I’d appreciate it if anyone would be able to nudge me in the right direction.

2

Not a minute after I post this I figured it out. For anyone wondering EVEONLINE.CHARACTER_INDUSTRY_JOBS(,“active”,) produced the results I needed.

3

Nice you got it resolved, for reference from the esi docs/swagger here are the enums available.

For industry jobs data that is

image

evetech - get_corporations_corporation_id_industry_jobs

4

Much appreciated.

I was not aware of this resource.

5

I am having the exact same issue with the excel add-in, even copypasted what you posted as the fix and it didn’t work

6

Is your formula seperator “,” or “;”, since if it’s not “,” would make the fix need to be =EVEONLINE.CHARACTER_INDUSTRY_JOBS(;“active”)

7

Hi, Zeedious

It’s been a while since I’ve tinkered with my spread sheet.

I had to clear my cache first, to get my sheet working again (I had to log my characters back in).

At the moment I have EVEONLINE.CORPORATION_INDUSTRY_JOBS(CharacterID,“active”) working just fine.

As for =EVEONLINE.CHARACTER_INDUSTRY_JOBS, I can’t get it to work either. Not sure what to do.

Sorry I can’t be of more help.