⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Can GroceryCrud do multi-field joins?



basementjack

basementjack
  • profile picture
  • Member

Posted 18 June 2012 - 02:00 AM

I have a database that uses "natural keys" so several fields are combined together to create the unique key, and also to relate records.

For example a query might look like this

Select
Company.Name
Asset.Name
Asset.Value
From
Company
Inner join
Asset
On
Company.CompanyID = Asset.CompanyID
and
Company.Region = Asset.Region

Is there a way to handle multi field relationships in GroceryCRUD?

Thanks!

web-johnny

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 18 June 2012 - 06:09 AM

For now there is not such a functionality . This is the feature set_relation_1_1 that I want to do in the future but for now something like this doesn't exist. You can use the set_model to do such customizations but use it only if you are familar with grocery CRUD