# \[Solved\] Looking for an example of the status filter for EVEONLINE.CHARACTER\_INDUSTRY\_JOBS()

**URL:** <https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460>\
**Category:** EVE x Microsoft Excel Add-in\
**Created:** [November 24, 2023, 6:06am UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460 "2023-11-24T06:06:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grandpa\_Fogie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/grandpa_fogie/32/396035_2.png) [@Grandpa\_Fogie](https://forums.eveonline.com/u/Grandpa_Fogie)\
**Post date:** [November 24, 2023, 6:06am UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/1 "2023-11-24T06:06:07Z")

</div>

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](https://global.discourse-cdn.com/eveonline/original/4X/7/a/1/7a17791a6c0ef6f210f0ff0f848a22ab0b33b852.png)

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

---

<div class="post-metadata">

**Author:** ![Grandpa\_Fogie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/grandpa_fogie/32/396035_2.png) [@Grandpa\_Fogie](https://forums.eveonline.com/u/Grandpa_Fogie)\
**Post date:** [November 24, 2023, 6:07am UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/2 "2023-11-24T06:07:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\
**Post date:** [November 25, 2023, 10:50am UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/3 "2023-11-25T10:50:29Z")

</div>

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

For industry jobs data that is

![image](https://global.discourse-cdn.com/eveonline/original/4X/9/b/0/9b0412ec57f034598a5865aa468f6861d688a754.png)

[evetech - get\_corporations\_corporation\_id\_industry\_jobs](https://esi.evetech.net/ui/?version=latest#/Industry/get_corporations_corporation_id_industry_jobs)

---

<div class="post-metadata">

**Author:** ![Grandpa\_Fogie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/grandpa_fogie/32/396035_2.png) [@Grandpa\_Fogie](https://forums.eveonline.com/u/Grandpa_Fogie)\
**Post date:** [November 26, 2023, 2:08am UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/4 "2023-11-26T02:08:21Z")

</div>

Much appreciated.

I was not aware of this resource.

---

<div class="post-metadata">

**Author:** ![Zeedious\_Zaze](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/zeedious_zaze/32/453171_2.png) [@Zeedious\_Zaze](https://forums.eveonline.com/u/Zeedious_Zaze)\
**Post date:** [March 11, 2025, 6:01pm UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/5 "2025-03-11T18:01:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\
**Post date:** [March 14, 2025, 7:05pm UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/6 "2025-03-14T19:05:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Grandpa\_Fogie](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/grandpa_fogie/32/396035_2.png) [@Grandpa\_Fogie](https://forums.eveonline.com/u/Grandpa_Fogie)\
**Post date:** [March 16, 2025, 5:22pm UTC](https://forums.eveonline.com/t/solved-looking-for-an-example-of-the-status-filter-for-eveonline-character-industry-jobs/429460/7 "2025-03-16T17:22:29Z")

</div>

Hi, Zeedious

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

I had to [clear my cache](https://forums.eveonline.com/t/issues-loading-excel-add-in/428494) 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.