ids

  1. CMTV

    XF 2.0 Why nullable entity ID?

    The question is stated in the title of this thread. @property int|null trophy_id 'trophy_id' => ['type' => self::UINT, 'autoIncrement' => true, 'nullable' => true] Should I do the same with my entities? What about string IDs? String UserField ID, for example, is not marked as nullable
  2. CMTV

    XF 2.0 ->whereIds(...) Use IDs array order

    Hi! I have an ordered array of IDs gathered from complex SELECT query. Now I need to get entities with IDs from my array but in the order they are listed in IDs array! It can be done with this query: SELECT * FROM table WHERE id IN (5,4,3,1,6) ORDER BY FIELD(id, 5,4,3,1,6); But the porblem...
Top Bottom