0

I'm new to ObjectBox. I have a worklistDocumentNumber, from which I need to get report master data by using query. Can anyone help me with this. I tried by adding some filter conditions in query, but I'm not sure how exactly this works...

@Entity()
class ReportMaster {
  int id;
  String? reportName;
  String? reportContent;

final workList = ToOne<WorkList>();

  ReportMaster({
    this.id = 0,
    required this.reportName,
    required this.reportContent,

  });
}



@Entity()
class WorkList{
  int id;
  String? worklistDocumentNumber;
  String? worklistStatus;


  WorkList({
      this.id = 0 ,
      this.worklistDocumentNumber,
      this.worklistStatus,
});
}

This is my Store

late final Store _store;
late final Box<ReportMaster> _reportMasterBox;


ObjectBox._init(this._store){
  _reportMasterBox = Box<ReportMaster>(_store);

}


static Future<ObjectBox> init() async {
  final store = await openStore();
  return ObjectBox._init(store);
}
Guhan
  • 35
  • 6
  • It is not apparent, how both boxes are related. There needs to some common key (like worklistDocumentNumber in ReportMaster). Or you create a relationship explained here: https://docs.objectbox.io/relations – w461 Dec 22 '22 at 14:39

1 Answers1

0

Learn something about relational database concepts, though ObjectBox depends upon NoSql. But for establishing relations, you should have know some basics, like key!

  • What Primary Keys are?
  • What Foreign Keys are?
  • How two tables are related via Primary and Foreign Key?

After knowing this basics, you can head over to the docs of ObjectBox, it'll be much easier than before!

For knowing the basics You can refer to,

  • w3 schools or
  • javatpoint
  • or anyother youtube video

And for ObjectBox The Official Documentation about Relations in ObjectBox

Meshkat Shadik
  • 194
  • 7