project listing

Q How do you list the projects a human would actually pick from?

Endpoint GET /entity/projects ; POST /entity/projects/_search

Docs claim sg_status marks a project Active.

Actual

candidate fields on Project:
  sg_status              list       valid=['Bidding', 'Active', 'Lost', 'Hold'] display=None
  archived               checkbox   valid=None display=None
  is_template            checkbox   valid=None display=None
  is_demo                checkbox   valid=None display=None
  is_template_project    checkbox   valid=None display=None

22 projects on the site
  sg_status      {'None': 15, 'Active': 5, 'Lost': 1, 'Bidding': 1}
  archived       {'False': 22}
  is_template    {'True': 7, 'False': 15}
  is_demo        {'False': 21, 'True': 1}

sg_status is NULL on real, in-use projects - it is not a liveness flag:
  8 of 22 have no status and are not templates

filter results:
  no filter                                    -> 22
  sg_status is Active                          -> 5
  is_template is False                         -> 15
  is_demo is False                             -> 21
  archived is False                            -> 22
  not template AND not archived                -> 15
  not template AND not demo AND not archived   -> 14

Teaches

• Trap. sg_status is Active is not a liveness filter. It is not set automatically, and on the probed site 7 of 22 projects have a value against 15 null, 8 of the nulls non-template working shows, so the filter returns 5 and hides the rest. What sets it on those 7 is unmeasured: this probe reads the tally, not the history.

• sg_status is a list field with valid values Bidding/Active/Lost/Hold and no display_values, so even where it is set there is no label to put in front of a user (probe 009).

• The checkboxes are the discriminators. On the probed site:

  checkbox	True on
  is_template	7, the stock templates
  is_demo	1, the shipped demo show
  archived	0 of 22

  All three False leaves 14 of 22. The archived clause is proven harmless but not proven to exclude anything; keep it, it costs nothing.