Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

By cosyxu
#815601
Hi Amo,

I have a suggest control in my Dynaform, when I connect it to my MSSQL database, it only works for the tables in the Database, not working for the view tables in the database.

For example, under the database MYDB, there are "Tables" and "Views", why the query only works for the tables under "Tables" Catalogue not the "View" Catalogue, any ideas?

Thanks,
Yuan
By amosbatto
#815615
Do the query with executeQuery() in a trigger and check if there is a message in the "__ERROR__" system variable that indicates what is the problem. You need to turn on Debug Mode when running a case to see it. Also, if you want a detailed error message you need to set in your env.ini file:
Code: Select all
debug = 1 
By cosyxu
#815618
Hi Amo,

I have put the query in a trigger, and please find the following System variable __ERROR__,
Code: Select all
Could not rollback transaction [Native Error: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.]
Thanks,
Yuan
By cosyxu
#815619
amosbatto wrote: Fri Aug 10, 2018 12:05 am Do the query with executeQuery() in a trigger and check if there is a message in the "__ERROR__" system variable that indicates what is the problem. You need to turn on Debug Mode when running a case to see it. Also, if you want a detailed error message you need to set in your env.ini file:
Code: Select all
debug = 1 
And this is the trigger before the dynaform that I used,
Code: Select all
$msSQL = "23123213123213213213213213213"; //DB's id

$query = "SELECT   
				staff_id,        
            	staff_name         
      		FROM  view_timesheet
      		WHERE staff_id = '110' ";


$queryResult = executeQuery($query, $msSQL);		

if( is_array($queryResult) and count($queryResult) > 0 ){

	foreach($queryResult as $row){
		@@employee_Name  = $row['staff_name'];	
	}
	
}
Thanks,
Yuan
By amosbatto
#815621
Test that same query directly in MSSQL to verify that it is correct.

If your staff_id field is an integer, then its value shouldn't be enclosed in quotation marks. Try it this way:
Code: Select all
$query = "SELECT  staff_id, staff_name FROM view_timesheet WHERE staff_id = 110";
By cosyxu
#815649
Hi Amo,

I have two tables, one is a table in the "Tables" category; the other is a view table in the "Views" category.

To test the connection, I have changed my query from a view to a table, and then it works.

So this makes me thinking that ProcessMake may not support to query a view within a trigger?

Thanks

Yuan
Attachments
2018-08-13_15-51-45.png
2018-08-13_15-51-45.png (7.72 KiB) Viewed 171 times
By amosbatto
#815658
Yuan,
Please file a bug report about this issue at http://bugs.processmaker.com and post a link to your bug report here.

The Dev team usually ignores bug reports from the community, but this issue will also effect clients with support contracts, so they might address it.
By cosyxu
#815660
amosbatto wrote: Mon Aug 13, 2018 10:27 pm Yuan,
Please file a bug report about this issue at http://bugs.processmaker.com and post a link to your bug report here.

The Dev team usually ignores bug reports from the community, but this issue will also effect clients with support contracts, so they might address it.
Hi Amo,

I have filled a bug here https://bugs.processmaker.com/view.php?id=25657

Thanks,
Yuan

Hi, Please tell to processmaker team for solu[…]

Hey jamesjohnston, Your first course of action is[…]

https://wiki.processmaker.com/3.2/Case_Summary#Mor[…]

instagram download for pc

Download images on Instagram, you have to take a s[…]