Search
28 results 21-28
Forum
- 30th Oct 2020MJoin alias and displaying resultsunit_outcome_discipline_outcome_1_lookup.discipline_outcome_fk' ) ->order( 'discipline_outcome.discipline_outcome asc' ) ->where('discipline_fk', '1' ) ->fields( Field::inst( 'discipline_outcome_pk'
- 1st Oct 2020MJoin Alias - Records deleted in lookup table when updatingunit_outcome_discipline_outcome_lookup.unit_outcome_fk' ) ->link( 'paediatrics.discipline_outcome_pk', 'unit_outcome_discipline_outcome_lookup.discipline_outcome_fk' ) ->where('discipline_fk', '5' ) // ->order( 'discipline_outcome.discipline_outcome asc'
- 9th Jul 2020Missing duplicate rows in result of Mjoinvessel_tanks_project.vessel_tank_id', 'daily_inspection.tank_id' ) ->where('vessel_tanks_project.project_id', $project_id) ->where('daily_inspection.project_id', $project_id) ->link( 'daily_inspection.di_id', 'maconsumption.di_id'
- 10th Jan 2018The column.render callback runs too many timesamount of logic in there—depending on the template. The
- 5th Apr 2017Where condition between today 19:00 and tomorrow 09:00I tried to use ->where('date', date('Y-m-d') ,'>') ->where ('time', time('19:00:00'),'>=')
- 5th Jan 2017How to format date returned from .NET ajax call.Editor(db, "DisplayMessage", "DisplayMessage_ID") .Model<DisplayMessageData>() .Where("DisplayLocation_ID", locId) .Field(f) .Field(ex) .Field(new
- 12th Oct 2016Editor: Conversion from nvarchar to int??Set("displayOrder", "displayOrder + 1", false) .Where("displayOrder", "displayOrder", ">=") .Exec(); }; response.PostRemove
- 7th Oct 2016Editor: Row Reorder Precreate IssueSet("displayOrder", "displayOrder + 1", false) .Where("displayOrder", e.Values["displayOrder"], ">=") .Exec(); };