[Tim Hernandez]

Ran as Admin.
Deleted everything and even ran it again.
Removed Reg.

Any thoughts appreciated.

[Tim Hernandez]

Any experts on the repair side wanna offer some control advise to produce a custom event to resolve Mike’s initial question? I have a general scope of the SQL that would be required.

[Tim Hernandez]

Hey Mike: I can work with you on this. What do you have drafted as far as values go in SQL?

[Tim Hernandez]

I just use sql, and you have to include the foreign as well.

[Tim Hernandez]

I believe it is in the stored procedure. You can alter it there.

[Tim Hernandez]

Sorry this one appears to part of a function. I know the WO_QUOTE was part of the procedure.

[Tim Hernandez]

Please share with us your initial report.

[Tim Hernandez]

It’s most likely your inner joins. Try using left outer joins and see what happens.

[Tim Hernandez]

Hi John:

Do a lot of this over here. I use dreamweaver but only because I have an adobe subscription. You can use any editor and a good free one would be visual studio code.

As for a guide, we could probably get something at a round table at the conference August 25-26th. Will you be attending?

[Tim Hernandez]

Hi Jim:

I have been using the cloud for a couple years now with being on the QUE Group Board. There are some potential nuances. First being normal RDP issues with copy and paste not working properly. Easy fix is to reboot your machine. Quick keys do not work like your normal environment, so you will have to integrate another step but it looks and feels like Quantum. It is super easy to deploy and maintain. Have you done a trial yet to see if it fits your needs?

[Tim Hernandez]

👍

[Tim Hernandez]

If there was no particular reason for the stock line to be split then just do a qty adjustment to account accordingly.

[Tim Hernandez]

Hi Kirsten:

If you want to post a fake snippet of what you are working on along with the error, maybe someone can better help. I do not use the Web API but could still probably help or find the right person take a look at your issue.

Best Regards,
Tim

[Tim Hernandez]

If you haven’t done so already, export HKEY_CURRENT_USER\SOFTWARE\Component Control USA, LLC. then remove the registry key for the logged in windows user in attached picture on the PC with the problem. Close quantum on bad pc and move to the good PC. Export the registry key for the logged in user on the good client PC. Take the good client registry key export for HKEY_CURRENT_USER\SOFTWARE\Component Control USA, LLC. and place it on the desktop of the problem PC. Double click to import into the good PC. Open Quantum and log in user that had the previous problem and see if that resolves it.

The branch name is:
HKEY_CURRENT_USER\SOFTWARE\Component Control USA, LLC.

Screenshot-2022-04-29-155958.png 36 KB Image File - Click to view

Options

• Copy Download Link

[Tim Hernandez]

This is a bug. Please submit a case to Component Control to provide the corrective action.

https://www.componentcontrol.com/customers/support/technical-support
👥

[Tim Hernandez]

Hi Rochelle:

What version of Quantum are you on?

Best,

Tim😀

[Tim Hernandez]

On our last call we were speaking with CC about a possible August Event. We were hoping to get back to Coronado but we will be releasing more info in the next few weeks.

🍻

[Tim Hernandez]

Hi Tony:

Took a look at this. Give me another day. I think I got something for you. 😃
What version of Quantum are you on?

[Tim Hernandez]

Thanks, everyone!

Event Manager does pick it up after each minute to start the job. However, it still requires two more cycles at 5 minutes each. I am assuming EV’ s timer is 5 minutes to do what ever it wants to do.

Pietro, with the crystal report would the sequence be the same as far as passing the parameter to crystal from EV? Would the CR look at the XML file to pass to the CR as well?

Can you walk me through the process?

[Tim Hernandez]

Does this data warehouse host an on premise gateway for powerBi?

Might be a good idea to just open up SQL monitor and look at some baselines.

[Tim Hernandez]

What I think you are saying:

SELECT tim.*, rocks.* FROM

(SELECT

qctl.wo_operation.woo_auto_key,

qctl.wo_skills.description,

qctl.wo_operation.si_number,

SUM(qctl.wo_task_skills.est_hours) AS “Sum_EST_HOURS”

FROM

qctl.wo_task_skills

INNER JOIN qctl.wo_skills ON qctl.wo_task_skills.wok_auto_key = qctl.wo_skills.wok_auto_key

LEFT JOIN qctl.wo_task ON qctl.wo_task_skills.wot_auto_key = qctl.wo_task.wot_auto_key

LEFT JOIN qctl.wo_operation ON qctl.wo_task.woo_auto_key = qctl.wo_operation.woo_auto_key

WHERE

qctl.wo_operation.wos_auto_key = xxxxx

GROUP BY

qctl.wo_operation.woo_auto_key,

qctl.wo_skills.description,

qctl.wo_operation.si_number

) Tim

(SELECT

qctl.wo_operation.woo_auto_key,

qctl.wo_skills.description,

qctl.wo_operation.si_number,

SUM(qctl.wo_task_labor.hours) AS “Sum_HOURS”

FROM

qctl.wo_skills

INNER JOIN qctl.wo_task_labor ON qctl.wo_task_labor.wok_auto_key = qctl.wo_skills.wok_auto_key

INNER JOIN qctl.wo_task ON qctl.wo_task_labor.wot_auto_key = qctl.wo_task.wot_auto_key

LEFT JOIN qctl.wo_operation ON qctl.wo_task.woo_auto_key = qctl.wo_operation.woo_auto_key

WHERE

qctl.wo_operation.wos_auto_key = xxxxx

GROUP BY

qctl.wo_operation.woo_auto_key,

qctl.wo_skills.description,

qctl.wo_operation.si_number

) Rocks

Where

tim.woo_auto_key = rocks.woo_auto_key;

[Tim Hernandez]

What John is saying:

SELECT

qctl.wo_skills.description,

qctl.wo_operation.si_number,

SUM(qctl.wo_task_skills.est_hours) AS “Sum_EST_HOURS”

FROM

qctl.wo_task_skills

INNER JOIN qctl.wo_skills ON qctl.wo_task_skills.wok_auto_key = qctl.wo_skills.wok_auto_key

LEFT JOIN qctl.wo_task ON qctl.wo_task_skills.wot_auto_key = qctl.wo_task.wot_auto_key

LEFT JOIN qctl.wo_operation ON qctl.wo_task.woo_auto_key = qctl.wo_operation.woo_auto_key

WHERE

qctl.wo_operation.wos_auto_key = xxxxx

GROUP BY

qctl.wo_skills.description,

qctl.wo_operation.si_number

UNION ALL

SELECT

qctl.wo_skills.description,

qctl.wo_operation.si_number,

SUM(qctl.wo_task_labor.hours) AS “Sum_HOURS”

FROM

qctl.wo_skills

INNER JOIN qctl.wo_task_labor ON qctl.wo_task_labor.wok_auto_key = qctl.wo_skills.wok_auto_key

INNER JOIN qctl.wo_task ON qctl.wo_task_labor.wot_auto_key = qctl.wo_task.wot_auto_key

LEFT JOIN qctl.wo_operation ON qctl.wo_task.woo_auto_key = qctl.wo_operation.woo_auto_key

WHERE

qctl.wo_operation.wos_auto_key = xxxxx

GROUP BY

qctl.wo_skills.description,

qctl.wo_operation.si_number

[Tim Hernandez]

Is this something I would be interested in? Is this in milliseconds, seconds, minutes??

[Tim Hernandez]

Same here. This is a way bigger issue for us than originally thought.

[Tim Hernandez]

SELECT RPT_GL_PKG.GET_BALANCE_SHEET_BY_GROUPS (1, ’01-APR-2021′, ’30-APR-2021′, 228, ’01-MAY-2021′, ’31-MAY-2021′, 229) from dual;

[Tim Hernandez]

FUNCTION GET_BALANCE_SHEET (P_GLP NUMBER,

P_ACCOUNT_TYPE NUMBER,

P_SORT_BY_SEG VARCHAR2,

P_SEGMENT_NO NUMBER,

P_SEGMENT_ACC VARCHAR2) RETURN QC_UTL_PKG.CURSOR_TYPE;

and

FUNCTION GET_BALANCE_SHEET_BY_GROUPS (P_SYSCM NUMBER,

P_DATE_FROM1 DATE,

P_DATE_TO1 DATE,

P_GLP1 NUMBER,

P_DATE_FROM2 DATE,

P_DATE_TO2 DATE,

P_GLP2 NUMBER) RETURN QC_UTL_PKG.CURSOR_TYPE;

[Tim Hernandez]

Sorry for the late reply bud. If I recall in version 10 for DC you need to turn off Enhanced Security in preferences.

[Tim Hernandez]

Hi, June!

We escalated this on your behalf this morning. Looks like development is on it. Thanks for the alert.

Take care,

Tim

[Tim Hernandez]

Can you try it with a batch file? Have the batch file execute with parameters?

[Tim Hernandez]

Great, thanks for the feedback Mike. Glad it works. Take care bud.

Best,

TiMMaY!

[Tim Hernandez]

Attached is a new version.

I merged the two commands just for fun. Um make sure the joins are ok. I did a left outer and now I think you had an inner so just double check it.

Hope this helps or gives you or someone else some ideas.

Best regards,

TiMMaY!

[Tim Hernandez]

Good Evening Mike:

Hope all is well. Could you attach the report?

[Tim Hernandez]

Andre, miss you bro!

Everyone, this guy is a Jedi.

[Tim Hernandez]

Try a formula field with your condition requirements. If true then 1 else 0. Use that as your test. Group it by your test field first then group as you desire. See if you can get the zeros and ones to align with your thoughts. For example there would be zeros in your crossed out section of your document and ones in the part you want. Then just suppress the test section you don’t want with a simple selection expert.

[Tim Hernandez]

Kryste:

I am assuming you don’t have permissions assigned to all users to utilize crystal reports.

The attached images will give you a good idea on what security settings to enable for users to use crystal reports in Quantum and how to assign read permissions to the reports if necessary.

If you want an open report like you ask just simply verify the users in question have permissions to use crystal reports and verify no users have been added to the security portion of the report in question. Once you add a user or users to the security portion of any report. Only that user or users may read the report.

Hope this helps.

Best regards,

Tim

[Tim Hernandez]

VERY COOL PAUL! Great link!

[Tim Hernandez]

Nadim thank you.

I have already declared my header prefix in the event and I am targeting the respective header value in my SQL.

I can pass this particular value to the To:, CC:, and Subject: but not the replyto:

🙁

I know some of the standard templates like Jason suggested you could use fields like MANAGER and EMPLOYEE but I do not think the replyto: has the capability to pass a H_VALUE in a custom SQL event.

[Tim Hernandez]

Thank you Jason for the reply.

I suspected it would be some alias to the header but it just isn’t the case. I have used EMPLOYEE and MANAGER with no success. All it does is spit back exactly what I type. So in your case when use EMPLOYEE the reply to address will simply say EMPLOYEE.

Now if it was in the “To:” field it would work just dandy. In the “Replyto:” field, it doesn’t seem to be dynamic like its colleagues.

This is a Custom SQL Event. Not a CC template.

–Result attached.

[Tim Hernandez]

The value I intend on passing is an email address.

[Tim Hernandez]

I think we are just generally speaking at the moment. Would love to jump on a teams meeting and get some ideas out there. This task, in a very general sense, has been on my plate for a minute so I would like to clear it.

[Tim Hernandez]

This is right but should incorporate the date updated as well which was mentioned by Warren. The foreign price will not be triggered on the update so you will have to update that field as Pietro mentioned.

[Tim Hernandez]

Yes, I do this. Good catch Warren!🤓

[Tim Hernandez]

Just send the job posting to board@quegroup.org. We will get it up. Sorry for the delay in response.

[Tim Hernandez]

Thanks Mahmoud:
Can you refer to Mike Carey’s comment? Do your tasks have a particular sequence?

[Tim Hernandez]

I wouldn’t use notepad to start out with XSL. With XML, sure. Visual Studio Code is free just like notepad is. Save some sanity and use a code editor much more helpful with organization and you will pick it up quicker.

As for where to find the templates, please see below:

save_xsl.png 73 KB Image File - Click to view

Options

• Copy Download Link

[Tim Hernandez]

Ahh yes, the mischievous toolbar strikes again! Glad you resolved it. 😅 👥

[Tim Hernandez]

🤩 Thanks Kristen (@korlando) 👥

[Tim Hernandez]

Definitely not lost just trying manage around GDPR hard coding in the app. New mass mailer application requires a key generated per click for each subscription. Something we did not foresee pre-launch as we used the native function to add folks to the rolodex.

It will get corrected, if possible, and we will do better.

🤓

[Tim Hernandez]

Hey Tony:

Over the weekend I was able to see the permissions in the 20310 series are fixed in 12.5.3. You would not be able to delete the Sales Order or Invoice Reservation if you had 20316 disabled for general staff.

[Tim Hernandez]

Hey Tony:
Just got behind on the week and I feel bad for not getting back. Have you tried scaling back permissions temporarily? Maybe go to a policy where only a supervisor can only remove details from sales orders. I have not gotten to any SQL on this but you can really target the audit_trail for much more visibility. You should be able to see which user deleted the item in question on what SO. You will have to give me a little more time my friend to test a full on statement to trigger an event but I am happy to do it. I got a lot on my plate right now and I love it. Heck, back in November I became a tech to help keep up with certain product lines. So now for a couple hours a day I get down to the lab with a pen and a pad trying to get them darn units out (that was Dr. Dre play on words…yeah). This was my way of trying to help the team out. We have been busy and that is always a blessing.

Starter SQL (General for Deleted Items):

    select * from audit_trail where stamptime > sysdate-1 and source_table <> 'SYSUR' and DESCR like 'Deleted Detail Line-Item%' order by adt_auto_key;

Obviously you would configure your stamptime to be what is appropriate to you. Another thing with the audit trail is you do not want to leave your query too broad. Definitely don’t start from the biggening of time. Also, use the audit_trail to figure out if it is one user or many.

Hope this helps for now.

Best Regards,

TiMMaY