Multiple Query Values In Range On Lookups

(0) Share

Report

Posted on by Community Member

Hello,

We have a requirement in which we have a table which has the following columns

1) Department Code (0,1,2,3,4...99)

2) Employee Position (A,B,C,D....Z)

3) Employee Name

We want to have a lookup on a string field in a form which would have employees showing up from 10 of the 100 department codes and 5 of the 26 employee positions

queryBuildRange = queryBuildDataSource.addRange(fieldNum(DEPARTMENTRESOURCES, Code));

queryBuildRange.value("LOOKING FOR THE VALUE TO BE INSERTED HERE");

queryBuildRange = queryBuildDataSource.addRange(fieldNum(DEPARTMENTRESOURCES, position));

queryBuildRange.value("LOOKING FOR THE VALUE TO BE INSERTED HERE");

Thanks & Regards,

Hitesh

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Use queryValue("MyCode1") as the argument of value(). To add more ranges for the same field, simply add another QueryBuildRange and set its value. For example:

ds.addRange(fieldNum(DepartmentResources, Code)).value(queryValue("MyCode1")); ds.addRange(fieldNum(DepartmentResources, Code)).value(queryValue("MyCode2"));

Obviously you can use a loop if you have filter values in a collection.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin

So basically it'd be better if I just create another column which would act as a flag and use that as a query value instead

Regards,

Hitesh.

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I can't comment on that, because I don't know your scenario.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

There are 2 conditions

condition 1

Check if the employees of a particular department should show up in the grid

condition 2

if they belong to one of those 18 departments out of 30 departments

check if their position in the firm has a grade which contains the alphabet 'A'

The grades are like the below sample

A1

A2

A3

AB21

AB23

and so on

after both these conditions are met

the employees names should show up in the lookup.

So, I have used a flag the departments and that filtering is easy

however for positions we need to use something which would meet a condition which says does this persons grade contain the alphabet A

so instead of using a string in the query

can we use something which would be similar to using something like "(GradeId LIKE 'Aa%') in SQL"

Regards,

Hitesh.

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi Hitest,

For "Like" statements check methods SysQuery::valueLike and SysQuery::valueLikeAfter.

Was this reply helpful? Yes No