I am trying to set the Taxable status on a Requisition Line level if the Requisition line is Job Material (PUR-MTL) and the Job’s Project is Tax Exempt. I have duplicated and overridden the original event that causes CheckJobNum to run, and I thought I’d also be able to use JobNum to insert into my BAQ to check if the Project is Tax Exempt (Custom field). When I trace the screen, I see the CheckJobNum go off, then I see it try to execute my BAQ but it passes nothing for the job number.
I have a BAQ Dataview created to store the data from the BAQ, but it’s returning nothing
I was hoping I could use that temporary data that is on the screen (JobNum) to run this BAQ and update the Taxable checkbox in real time, but the BAQ seems to just sit and lock up the screen as it loads forever.
When I look further into the CheckJobNum, the paramter is ‘%value%’, which I don’t know what that means, but I too would like to use the data that is on the screen for my own purposes.
Whole event map with dataview highlighted (manually created, set to BAQ, told it what BAQ to use, it looks fine)
May be Row-Update that is hanging it up. Is there a special syntax I am supposed to use to update booleans? I see on the trace that the BAQ is returning the values I want. When I add the row-update widget back into the mix, the page has a stopwatch at the top and is locked up
Was messing around with the display message widget, changing single quotes to double quotes. The message shows the result of the BAQ with the corresponding quotes around it (‘true’ and “true”) I assume the message is printing it as a string but was experimenting to see if there was any reason it was hanging up because it thinks I’m trying to pass a string into a boolean (checkbox)
No quotes, it doesn’t like it at all. Just a slideout panel shows, but no buttons and I have to refresh or relaunch the preview window to get it working again
Tried to make a separate event to do the Row-Update (Before Update) to look at that dataview and update the checkbox. When I click save, it checks the check box, but gives me a nondescript error:
Added a condition to evaluate if the dataview object was true, if true, do a row update, if false, send a message (for testing). It doesn’t lock up but it clears the job field after I enter a valid job. The Taxable checkbox doesn’t update, but if I click the button I made that sets the Taxable checkbox to the value of the dataview populated from the BAQ, it sets it to true, as it should.
This is a variable you get to use when you have a column changing event.
It will be what the column is changed to, in your case, the JobNum.
Honestly, I wouldn’t hook into the column changing event.
I would make a new event with a trigger of DataTable > Column Changed* > ReqDetail > JobNum and then use your original syntax for the BAQ of ReqDetail_JobNum = '{ReqDetail.JobNum}'
It sounds like an event timing issue. Using the changed event will allow the view change to actually happen and then you can access the view field.
