cancel
Showing results for 
Search instead for 
Did you mean: 
dietzd
Nintex Newbie

Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

New to Nintex 2010. 

Hello.

I would like to create a workflow that queries a library for documents where Title does not equal Name, log in history and show the document item's info (and link) in a view for the document owners to track.

In my brain:

Query Library for Docs where Title does not equal Name and add Doc ID into collection variable.

Then for each document get ID, Title, Name, Owner, Last Modified Date and dynamically display into a view (is this from logging into History list). I do not need to keep track of any items that have been corrected. Not sure how to go about this.

Please know I appreciate any assistance.

Thanks,

Denise

Labels: (1)
Reply
13 Replies
fhunth
Nintex Newbie

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

You are right. This is a good way to do it, although if you have many items to be saved the log history has a limited capacity.

Another option should be (without Nintex):

-Create a Sharepoint List View with a filter (Title!=Name)

Reply
dietzd
Nintex Newbie

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Hi Fernando,

Thanks for your help. My problem is that when I create the filter where Title does not equal the Name all show true. Looks like the Name field has the .docx extension within it so everyone of the documents shows true to the statement. Not sure how to get around this.

Thanks,

D

Reply
Automation Master
Automation Master

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Hi Denise,

if you have only files inside with a 4-letter ending like docx and xlsx, you could use a calculated column to strip the file extension of the filename. There is an msdn article about calculated field formulas. See the "Remove Characters from Text" paragraph. But be careful if you don't use an english SharePoint. English formulas and syntax won't work for other languages most of the time.

Regards

Philipp

Reply
dietzd
Nintex Newbie

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Hi Phillip,

Thanks for your help. However, I am still unable to create a view for what I need. Name field is not available when you try to create a calculated column and creating a calculated column adding extension to a new title field does not work as well. Not sure what I am missing or if a view is able to be used. Which puts me back with creating something within Nintex 2010.

Thanks,

Denise

0 Kudos
Reply
Automation Master
Automation Master

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Hi Denise Dietz,

You can still go with list view. For this, you create a new column of Single line of text type called OnlyName. Create a workflow to execute when item is created. Add action in the workflow to set a field's value, Set OnlyName = Context item display name. Publish the workflow with this one step.

Run the workflow on few items manually if they already exist in the library. Then create the SharePoint list view filter based on this field i.e. Title!=OnlyName.

You don't have to worry about the field being populated as it would take few sec's for workflow to run and populate this field. See if it works else we can try the query also.

View solution in original post

Reply
dietzd
Nintex Newbie

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Thanks so much!!!!! Testing it now and so far it looks great.

I appreciate the help from everyone!! 

Denise

0 Kudos
Reply
dietzd
Nintex Newbie

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Hi Kapil,

Quick follow-up. This runs perfect on new items created. Is there a way to push this to the documents already in the library?

Please know I appreciate your time!!

Denise

0 Kudos
Reply
Automation Master
Automation Master

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

Hi Denise,

For the existing documents, populate the new column without the extension.

So easy way would be to go to datasheet view/quick edit, copy all the names to notepad (don't close the view), replace .docx/.xlsx/.pdf with nothing. Then paste them back in the new column in the same order. It will automatically filter them.

0 Kudos
Reply
dietzd
Nintex Newbie

Re: Newbie Nintex 2010: Workflow to query Library where Title != Name

Jump to solution

So close. did as stated above but when I create the filter where the NameOnly field is not equal to the Title I get all rows included in view. Copy and paste something wrong?

0 Kudos
Reply