Database EAV model, record listing as per search
- by Shyam Sunder Verma
I am building a dynamic application.
I have three tables : ( EAV model style)
1: Items ( ItemId, ItemName)
2: Fields (FieldId, FieldName)
3: Field Values ( ItemID, FieldId, Value)
Can you tell me how to write SINGLE query to get starting 20 records from ALL items where FieldId=4 is equal to TRUE.
Expected Result :
Columns = ItemID | Name |…