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

Help with a Query List: not resolving the text field

Jump to solution

Hello

I am using a Query action to lookup at the Project List :

- ProjectManager  (is set to People or Group)

- FreightChargeValue (is set to Single Line text because numbers or names are stored in it)

Based on the above, it should pull up some info and store them in variables.
However, the Query fails at that point where it tries to compare ...

Furthermore, when running in the CALM query as a test and manually type in my Surname, Name then the query is able to lookup at the Project List and pull up the relevant information associated to the column name ProjectManager.

Now, question is; why does it not work with the FreightChargeValue ?

Is it because its attribute is set to SingleLine as Text and not as a People or Group ?

How would I fix this in the workflow then?

I also tried using SET VARIABLE action to say set ProjectManager as FreightChargeValue but no help

Labels: (2)
Tags (2)
0 Kudos
Reply
16 Replies
graham
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Put the persons name/id into a string and filter using that?

0 Kudos
Reply
reiva13
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Hi Bim,

You can try to convert field "project manager" to  String use  "Query user Profile) and then you can try to filter ( use equal or contains).

Hope this can help you

Regards,
Reva Eka Patria

0 Kudos
Reply
bimi82
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Not sure if I understand this right..
how to convert to a string?

0 Kudos
Reply
bimi82
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Hi Reva

Do you mean this?
But the User field which looks at the FreightChargeValue is not a People of Group but a Single Line Field.

The pog_ProjectManager is a variable: People or Group.
However the source to pull the Manager's name from is a different customList.

In other words, there are 2 different custom lists: one for the Project List and one Form List.
The Form list is where users submit the request and the Query is supposed to pull info from Project List.

0 Kudos
Reply
reiva13
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Hi Bim,

Convert People to String .  to get name From Poople. Control 

Regards, 

Reva Eka Patria

0 Kudos
Reply
bimi82
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Not sure how to convert it but the only way I do is by setting a variable.
Do you mean this ?

What next... ??

Now you want the Query to compare the ProjectManager field with pog_ProjectManager?

  <FieldRef Name="ProjectManager" LookupId="FALSE" />
  <Value Type="User">{WorkflowVariableSmiley Tongueog_ProjectManager}</Value>

0 Kudos
Reply
bimi82
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Update:

I have converted the field to String and this is the error message:

Failed to query list data. Data type returned from the list is incompatible with the variable to store the result in.

0 Kudos
Reply
bimi82
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

To visualise what I want to do, so maybe you understand:

PROBLEM??

I am not able to get the relevant information from the QUERY.
Please help ... possibly with pictures to visualise the solution.

How do I convert a Text SingleField which contains a name Surname, Firstname into a People or Group field??
I have used SET VARIABLE and UPDATE FIELD actions but not having much luck...

0 Kudos
Reply
reiva13
Nintex Newbie

Re: Help with a Query List: not resolving the text field

Jump to solution

Could You share full Workflow screen,

I still don't understand your problem, do you want to  get all data project list (manager, Reference, Exces, etc) based on FreightChargeValue?

(Get project list data and insert to work list )

Regards

Reva Eka Patria

0 Kudos
Reply