Where can I find information about working with Infoblocks 2.0?

Dear developers! Help, please. Can't find the information about the SQL queries in the Infoblocks 2.0 Bitrix. At least one example where you would explain how to use Join and work with groups. How to do data sampling and so on. In official documentation there is nothing like this. Help, pliz!
June 14th 19 at 20:48
1 answer
June 14th 19 at 20:50
Solution
https://dev.1c-bitrix.ru/api_help/iblock/classes/c...

Bitrix does not recommend using direct DB queries, so no there is no documentation. What is the task specifically?
The specific task is this:
Write SQL queries to fetch the line item. The sample is the unit element for the property type list. - Dock.McDermott72 commented on June 14th 19 at 20:53
And You sent me was a link to GetList. Is there any information that is in the Infoblocks 2.0? I just don't understand the Highload Infoblocks 2.0 blocks are the same? - Dock.McDermott72 commented on June 14th 19 at 20:56
no , it highload other blocks. And getlist is the same for IB 1.0 and 2.0.

A sample item on the property list would be roughly as follows ($id - the identifier of the IB, 'MY_SPISOK' code properties):

$dbRes = CIBlockElement::GetList(array(), array('IBLOCK_ID' => $id, 'PROPERTY_MY_SPISOK' => 'needle'), false, false, array('ID', 'NAME'));
while ($arItem = $dbRes->GetNext()) {
print_r($arItem);
}
- ismael.Hessel commented on June 14th 19 at 20:59
in fact of the matter is that the task cannot use the getlist. - Dock.McDermott72 commented on June 14th 19 at 21:02
Then see the table and related b_iblock_element, b_iblock_element_prop_mID and b_iblock_element_prop_sID
ID - the identifier of the information block. Table s - scalar values m multiple.

But it's a very narrow task when you want to apply directly to the database, the optimization of some heavy queries, for example. - ismael.Hessel commented on June 14th 19 at 21:05
Well, Yes. So. Thank you. - Dock.McDermott72 commented on June 14th 19 at 21:08

Find more questions by tags 1C-Bitrix