Daryl Foxhoven

So I'm trying to lookup a PO# from an external MSSQL data source.  The issue is, the PO# in the data source is in the following format PO1-08888, however, the PO that we're capturing from the image is just 0888.  So I'm trying to use a like or contains operator to find the PO in the external source to fill in additional information.  I've tried so many different queries and have found none to work.

Here's what I'm currently using, and it does not work:

SELECT PO Number FROM [DatabaseName] WHERE [PO Number]  like "GV_PO_Number"

My GV_PO_Number is the number captured from the image 08888 and the [PO Number] is the column name in the databse.

Any thoughts??

We have a large client that is using a general search user account due to integration with SAP, however, the User Settings are available, and often users are changing the settings which creates issues for other users...we'd like the settings to be hidden or disabled so users cannot change...is this possible...if so...where?  This is an On-Prem system.

That's the exact behavior...I'm not getting an error....but I didn't look in the log files either.  My co-worker has the same issue with a 6.12 on Prem system.

Not sure if anyone else is encounting this...but been coming across it fairly often primarily in version 6.12 and 7.  When trying to Edit Multiple Index Entries....DocuWare only changes half of them.  For example...if there's 28 total documents we're editing....it will first do 14, then you have to select all the remaining ones....then it will only do 7, select the remaining, then it will do the rest.  Is this normal behavior and is anyone else experienceing this?

Thanks!

I'm trying to use a SQL Statement to return values in a Workflow.  The issue, is there may be more than 1 entry, although all the values will be the same...it's appending the values to the field...when all I want is the first entry it finds.  Since I cannot modify the select statement to "limit 1"...is there anothe way so that it only returns the first value found and not all of them.  Using MS SQL.

Thanks!

Daryl

We have a user  referencing a list that they use called MY OVERVIEW DOCUMENTS and there is the number that is displayed that  reflects the number of items that need the user's attention. Inexplicably, and with no warning, the interface appears to decide to update itself with a MY OVERVIEW DOCUMENTS list that has some large number and content that is not relegated to the user Then, again with no warning and on its own the interface changes again.  Anyone know why this is happening and it is random.

https://www.docuware.com/sites/default/files/forums-images/Leslie%201.png

https://www.docuware.com/sites/default/files/forums-images/Leslie%202.png

Is it possible to Disable Edit Multiple Index Entries either via a Profile OR some sort of global setting?  Customer doesn't want users to be able to do a mass index entry update for all documents.....but they do need the ability to do it on a document by document basis....is there a way to accomplish this via a global setting or profile?

Is it possible to parse out the subject line of an email using Connect to Outlook?  In other words, I have a monitored folder where Sales Orders are coming in and the Sales Order number is ALWAYS in the subject line, however, there is other information also, so I would like to parse out the subject line using RegEx to JUST capture the SO#...which is SO123456

If it is possible...where is it done?

Thanks!!