How to query all in the ENUM type NoYes?

(0) Share

Report

Posted on by Sathish Sivakumar

3,732

Hi,

I'm working on the querying values from the table. My task is to query all the values from the NoYes "ENUM" type field. I'm able to query the field which contains only "Yes" and which contains "No".

My requirement is to take all the data in the field, either is it Yes or No.

Yet now I'm trying this code:

qbrProjStatus = this.query().dataSourceName("AR_VC_SOPMaster").addRange(fieldnum(AR_VC_SOPMaster, Active));
qbrProjStatus.value(Global::queryValue(NoYes::Yes));

My requirement is to retrieve all the information from the field either is it Yes or No. I'm doing this task on the FORM level, these details will display on the GRID. I'm using Ax 2009.

Please suggest me some code too.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Sathish Sivakumar 3,732 on at

Like (0)

Report

RE: How to query all in the ENUM type NoYes?

Hi Guys,

I hardly tried for 2 days nothing didn't work. At last I found this "SysQuery::valueUnlimited()". This takes all the values either checked or no checked.

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

RE: How to query all in the ENUM type NoYes?

Hi Sathish,

If you want to retrieve all the values from your table based on the active field is set to Yes or No, then you have to used expression in query ranges. Take a look at below links on how to use expression in query ranges:

www.axaptapedia.com/Expressions_in_query_ranges

msdn.microsoft.com/.../aa893981.aspx

Based on your requirements, your code should look like this:

Query q = new Query(); // Create a new query.

QueryRun qr;

QueryBuildDataSource qbr1;

// Add a single datasource.

qbr1 = q.addDataSource(tablenum(AR_VC_SOPMaster));

// Name the datasource .

qbr1.name("AR_VC_SOPMaster");

// Add the range to the query data source.

qbr1.addRange(fieldNum(AR_VC_SOPMaster, Active)).value(

strFmt('((%1.%2 == NoYes::Yes) || (%1.%2 == NoYes::No))',

qbr1.name(),

fieldStr(AR_VC_SOPMaster, Active)));

Please let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

RE: How to query all in the ENUM type NoYes?

Hi Sathish,

From your requirement you don't actually need to use this field "Active" into your query range as you need all records irrespective of YES or NO. Just remove your addRange from your datasource it should give you required result.

However, If any case you still want to use OR condition in your query ranges. You can have a look on this blog article, I am pasting code here for your reference. daxture.blogspot.com.au/.../aot-and-x-queries-and-ranges-in-ax-2012.html

Adding OR and AND in query

QueryBuildRange qbr;

qbr = query.dataSourceTable(tableNum(Table)).addRange(fieldNum(Table, Active));

qbr.value(strFmt('((%1 == %2) || (%1 == %3))',

fieldStr(Table, Active),

queryvalue(NoYes::YES),

queryvalue(NoYes::NO)

));

Was this reply helpful? Yes No
Suggested answer

Thomas Vogt Poulsen 345 on at

Like (0)

Report

RE: How to query all in the ENUM type NoYes?

As Abhishek_mishra wrote when you could just remove the query range, or if that is not possible do this:

qbrProjStatus = this.query().dataSourceName("AR_VC_SOPMaster").addRange(fieldnum(AR_VC_SOPMaster, Active));

qbrProjStatus.value(SysQuery::valueEmptyString());

That should set the range to accept all values of the Active field.

Was this reply helpful? Yes No
Suggested answer

Abhishek_mishra 405 on at

Like (0)

Report

RE: How to query all in the ENUM type NoYes?

Why are you adding range on Active field when you don,t want to filter them based on no/yes.

Remove the code you have provided in your question.:)

Was this reply helpful? Yes No