I'm trying to add multiple values to a single field in a range

(0) Share

Report

Posted on by JGjinx321

Currently, I have a list of strings that represent SiteId's

I'm trying to think of a way to insert the values into the QueryBuildRange.value() property.

QueryBuildRange.value(listObject) does not work as it only expects one string.

I was thinking I could iterate through the list but I figured I might have to create a new QueryBuildRange object each time as I don't think there's an addEnd() method like there are for lists.

Then I'd have to bring the values from each together.

If I'm wrong please explain

Thanks!

P.S. here is my code

        while select SiteId from siteToUser where curUserId() == siteToUser.user
        {
            siteList.addEnd(siteToUser.SiteId);
        }
        sysTableLookup = SysTableLookup::newParameters(tableNum(InventSite),_lookup);

        qbds = query.addDataSource(tableNum(InventSite));
        qbr = qbds.addRange(fieldNum(InventSite, SiteId));
        qbr.value();

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report
Hi,

You can add that SiteToUser table with InventSite table using join in the lookup query itself.

Try to avoid while select.

sysTableLookup = SysTableLookup::newParameters(tableNum(InventSite),_lookup); qbds = query.addDataSource(tableNum(InventSite)); qbds1 = qbds.addDatasource(tablenum(SiteToUser)); qbds1.relations(true); qbds1.addrange(fieldnum(SiteToUser, User)).value(queryvalue(curUserId()));

Thanks,

Girish S.

Was this reply helpful? Yes No
JGjinx321 65 on at

Like (0)

Report

Thank you Girish.

What is the problem with while selects though? Or was it just the way I was using it?

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

You were using it incorrectly, while select or select statement is not required in queries.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report
You can use while select also but it not needed for your case. You are using wrongly. Check below code.

sysTableLookup = SysTableLookup::newParameters(tableNum(InventSite),_lookup); qbds = query.addDataSource(tableNum(InventSite)); qbr = qbds.addRange(fieldNum(InventSite, SiteId)); while select SiteId from siteToUser where curUserId() == siteToUser.user { qbr.value(queryvalue(queryrangeconcat(siteToUser.SiteId))); }

If you are using list, you need to loop through the list using ListEnumerator and use queryRangeConcat function to merge SiteId values to query range.

ListEnumerator listEnumerator; while select SiteId from siteToUser where curUserId() == siteToUser.user { siteList.addEnd(siteToUser.SiteId); } sysTableLookup = SysTableLookup::newParameters(tableNum(InventSite),_lookup); qbds = query.addDataSource(tableNum(InventSite)); qbr = qbds.addRange(fieldNum(InventSite, SiteId)); listEnumerator = siteList.getEnumerator(); while(listEnumerator.moveNext()) { qbr.value(queryValue(queryrangeConcat(listEnumerator.current()))); }

Thanks,

Girish S.

Was this reply helpful? Yes No

Join the conversation

Community site session details

I'm trying to add multiple values to a single field in a range

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

I'm trying to add multiple values to a single field in a range

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates