Craig Heintz GSME

Spoke too soon.  I had my database field set for a numberic field and not a decimal.
So back to maybe a bug!

If your database field is a decimal field and you set your select list as a CSV and use a file connect to access it, you will need to assign the column to an integer in the file connect configuration and then click on the number format and set the decimal to 2 digits.  This made the select list available to me.

Have you tries to use decimal instead of comma for in your price column?

like 0.30 and 15.00

To get File connection to work in the cloud you need to install the desktop apps for LOCAL DATA CONNECTOR on a computer that will not be turned off since it will always be needed.  Once you do this and set up the connection, you will be able to select it in the cloud config.

 

Has anyone else experienced that when 2 filter profiles are assigned to a Role like this:
1. DocumentType=Invoice (search, view, export)
2. Document Type=Invoice and Security=Locked (search, View)

When a user does a search and the result list includes documents that have a mix of both match scenarios above, when a user opens either document match, the viewer tools will change based on which match exists. For instance the download tool will gray out when match#2 matches.
However, in the result list, if I right click the same document, the Download link is still there. If I click it it begins the action but then opens a new window and errors out with a permissions reason.

So here is my question...Is there any way to make the viewer tools and the right click menu work the same?

Here are screen shots

Has anyone else experienced that when 2 filter profiles are assigned to a Role like this:
1.  DocumentType=Invoice (search, view, export)
2.  Document Type=Invoice and Security=Locked (search, View)

When a user does a search and the result list includes documents that have a mix of both match scenarios above, when a user opens either document match, the viewer tools will change based on which match exists.  For instance the download tool will gray out when match#2 matches.
However, in the result list, if I right click the same document, the Download link is still there.  If I click it it begins the action but then opens a new window and errors out with a permissions reason.

So here is my question...Is there any way to make the viewer tools and the right click menu work the same?

If you can get to the database tables there is a table in DWSYSTEM db DWUSERS then you can do it.

Not sure what version you are on.  I have been able to accomplish something like that with this with a custom profile set like this in v7.1
This user can store only and not search or view docs.  It might give you a clue if you are on an older version.

In v6.12 Workflow, I had a Variable (GV_data) that was filled with a result of a DB lookup that looked for duplicates and returned one of the duplicate dwdocid numbers (as text) and filled the variable.  So for each invoice triggered this variable would end up as either a dwdocid or no data at all (empty).

Then in the following conditional step I would evaluate for GV_data = "" 
if it matched then it would not be a duplicate and if it did not match (because a dwdocid was returned in the variable) it would mark it as a duplicate.

Now that being said, I upgraded the customer to v7.2 and all of their workflows operated correctly except for this one.  It would just hang and never give an error output or anything.

So my question:  Is there a new syntax in v7.2 to do a conditional task for an empty vairable data?