nils

Need to check the SQL but that counts as null when the query happens

nils

Like GroupID = 5 and SimulationID = 10, then the Group is deleted but that record remains

nils

@MichalKleiner It’s not null, just using an ID that doesn’t exist

nils
  1. $simulations = Simulation::get()->filter([
  2. 'OrganisationGroups.ID' => [null, 1, 4]
  3. ]);

This query also returns records that have been assigned to a OrganisationGroup that has been deleted, because there’s still a record in the mapping table.

nils

Do people clean up their mapping tables manually? I’ve got a query like this:

  1. $simulations = Simulation::get()->filter([
  2. 'OrganisationGroups.ID' => [null, 1, 4]
  3. ]);

works fine, except if there’s an old record in Simulation_OrganisationGroup table pointing to a deleted entry it counts as null which isn’t really desired.

nils

Solved it, was because I had this in my api.yml

  1. After:
  2. - '#graphqlconfig'
nils

I'm getting Unknown column errors on /dev/build because it's trying to execute queries in functions exposed via GraphQL, before the database changes has been build. Any one experienced the same?

nils

@unclecheese How do I specify what arguments can be passed? I basically want to pass a parameter to a function on a DataObject.

nils

Is it possible to use arguments on fields? i.e.

  1. {
  2. human(id: "1000") {
  3. name
  4. height(unit: FOOT)
  5. }
  6. }