search

YetiForceCompany / YetiForce

One of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
https://yetiforce.com
4 stars 3 forks source link

relatedRecordsList on PDF module, condition not working for status_rel and comment_rel fields #21

Open apcloic opened 2 years ago

apcloic commented 2 years ago

Tested on gitstable.

Now that these 2 extra fields are available thanks to recent commit by yetiforce, I'm trying to get the list of contacts related to an Occurrence record where status_rel is equal to PLL_PRESENT.

See video at the end.


$(relatedRecordsList : Contacts|firstname,lastname,jobtitle,parent_id,email,mobile,status_rel,comment_rel|[[["status_rel","e","PLL_PRESENT"]]]|||)$

Debug log trace below.


2022-09-27 17:20:04.9624 [error][] - Not found field model | Field name: 'status_rel' in moduleContacts
2022-09-27 17:20:04.9626 [error][] - ERR_NOT_FOUND_FIELD_MODEL|status_rel|Contacts
App\Exceptions\AppException: ERR_NOT_FOUND_FIELD_MODEL|status_rel|Contacts in /web/yetiforce/app/QueryGenerator.php:1247
Stack trace:
#0 /web/yetiforce/app/QueryGenerator.php(1162): App\QueryGenerator->getQueryField('status_rel')
YetiForceCompany/YetiForceCRM#1 /web/yetiforce/app/QueryGenerator.php(1213): App\QueryGenerator->getCondition('status_rel', 'PLL_PRESENT', 'e', false)
YetiForceCompany/YetiForceCRM#2 /web/yetiforce/app/QueryGenerator.php(834): App\QueryGenerator->addCondition('status_rel', 'PLL_PRESENT', 'e', true)
YetiForceCompany/YetiForceCRM#3 /web/yetiforce/modules/Vtiger/models/RelationListView.php(215): App\QueryGenerator->parseAdvFilter(Array)
YetiForceCompany/YetiForceCRM#4 /web/yetiforce/modules/Vtiger/models/RelationListView.php(180): Vtiger_RelationListView_Model->loadCondition()
YetiForceCompany/YetiForceCRM#5 /web/yetiforce/modules/Vtiger/models/RelationListView.php(250): Vtiger_RelationListView_Model->getRelationQuery()
YetiForceCompany/YetiForceCRM#6 /web/yetiforce/app/TextParser.php(967): Vtiger_RelationListView_Model->getEntries(Object(Vtiger_Paging_Model))
YetiForceCompany/YetiForceCRM#7 /web/yetiforce/app/TextParser.php(940): App\TextParser->relatedRecordsListPrinter(Object(Occurrences_RelationListView_Model), Object(Vtiger_Paging_Model), 0)
YetiForceCompany/YetiForceCRM#8 /web/yetiforce/app/TextParser.php(484): App\TextParser->relatedRecordsList('Contacts|firstn...')
YetiForceCompany/YetiForceCRM#9 [internal function]: App\TextParser->App\{closure}(Array)
YetiForceCompany/YetiForceCRM#10 /web/yetiforce/app/TextParser.php(482): preg_replace_callback('/\\$\\((\\w+) : ([...', Object(Closure), '<table border="...')
YetiForceCompany/YetiForceCRM#11 /web/yetiforce/app/TextParser.php(452): App\TextParser->parseData('<table border="...')
YetiForceCompany/YetiForceCRM#12 /web/yetiforce/modules/Vtiger/models/PDF.php(516): App\TextParser->parse()
YetiForceCompany/YetiForceCRM#13 /web/yetiforce/app/Pdf/Drivers/Base.php(258): Vtiger_PDF_Model->parseVariables('<table border="...')
YetiForceCompany/YetiForceCRM#14 /web/yetiforce/modules/Vtiger/actions/PDF.php(177): App\Pdf\Drivers\Base->loadTemplateData()
YetiForceCompany/YetiForceCRM#15 /web/yetiforce/app/Controller/ExposeMethod.php(68): Vtiger_PDF_Action->generate(Object(App\Request))
YetiForceCompany/YetiForceCRM#16 /web/yetiforce/app/Controller/ExposeMethod.php(81): Vtiger_PDF_Action->invokeExposedMethod('generate', Object(App\Request))
YetiForceCompany/YetiForceCRM#17 /web/yetiforce/include/main/WebUI.php(188): Vtiger_PDF_Action->process(Object(App\Request))
YetiForceCompany/YetiForceCRM#18 /web/yetiforce/index.php(26): Vtiger_WebUI->process(Object(App\Request))
YetiForceCompany/YetiForceCRM#19 {main}

issue_with_status_rel_field

YetiForceCompany/YetiForceCRM#13486

15942