[development-axapta] Query extended range failure, linking InventTrans and InventDim

Creating a custom lookup Form and when I execute the lookup I receive the following message: Query extended range failure: InventDim.InventSerialId is not a valid datasource.field pair near pos 29. What I want selected from InventTrans is: 1. Records associated with a particluar Production

[development-axapta] query re4agrding DateTIme field in AX 2009

Hi All, I want some help regarding DateTime field in Ax 2009, I am printing one attendance report which I have developed on both EP and Ax Client her the issue I m facing with Date Time field is when I print Date Time field in EP with simple display method itprints correctl but the same I use in

[development-axapta] Query about inventsumlogtts in AX 4.0 SP1

Hi Can we delete the record from inventsumlogtts? we are not using any functionality of master planning and we have the license of master planning. can we stop new entry creation in this table or we can delete all the record time to time basis, without effecting the any another functionality

Re: [development-axapta] Query QueryBuildDataSource - Distinct records

/ Rome / Stockholm / Vienne Objet: [development-axapta] Query QueryBuildDataSource - Distinct records How can I have distinct record using the querybuilddatasource from AX 4.0 If I was using AX 2009 i think i could use the addGroupBy method but what can I do with AX4.0 ? public void

[development-axapta] Query QueryBuildDataSource - Distinct records

How can I have distinct record using the querybuilddatasource from AX 4.0 If I was using AX 2009 i think i could use the addGroupBy method but what can I do with AX4.0 ? public void executeQuery() { Query query = new Query(); QueryBuildDataSourceqbsAppFamily;

[development-axapta] query - date criteria

AX 2009 Hello Does anyone know where one can get a list of the various date criteria options which are available for running a query. For example to run a query for today plus two days is: 04/01/2009..04/03/2009 But I need to run a query for a date range which does not specify the actual

[development-axapta] Query on Dimension group.

Dear All,  I renamed the Item dimensions color and size in the Dimension group as per the requirements of the client and attached the group to group of Items (an Item group). But I do want to rename these dimensions again for some specific purpose and attach to some other group of Items(Item

RE: [development-axapta] Query Question

: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: Thursday, August 21, 2008 9:54 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Query Question How do I write this SQL query in X++? select a.ItemId,a.ItemName, b.blocked from

RE: [development-axapta] Query sentence or and Like

AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Query sentence or and Like Hello, I have a problem, I need to create a query with a condition OR, in this condition have a comparison with Like. My query in SQL is: select * from TABLA1 where TABLA1.campo1 like '%

Re: [development-axapta] Query sentence or and Like

Try this: Void trythis() { TABLA1 cursorTABLA1; ; select cursorTABLA1 where cursorTABLA1.comp1 like '**' || cursorTABLA1.compo2 like '**' } --- On Thu, 7/3/08, jasuarezh [EMAIL PROTECTED] wrote: From: jasuarezh [EMAIL PROTECTED] Subject: [development-axapta] Query sentence

Re: [development-axapta] Query sentence or and Like

Hi, I think a lot of people have already asked this question, you should browse this forum. I give you the example code: qbr = this.query().datasourcetable(tablenum(custTable)).addrange(fieldnum(custtable, recid)); range = strfmt('((%1 == \%2\) || (%3 == \%4\))',

[development-axapta] Query Related Alerts

Hi.. I need some help regarding the alerts. I create alerts in the system but there is a problem that the alerts are not generated until I go to the AOT Formstutorial_EventProcessor and click the start button then the system shows me the generated alerts. Can anyone tell me that what

SV: [development-axapta] Query on temporary table

: [development-axapta] Query on temporary table Hi, Use the method setRecord on the QueryRun to pass the temporary table to the Query. Br. Carsten F. Frandsen a-solutions From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com

Re: [development-axapta] Query on temporary table

Try THIS qr.setrecord(tmpLedgerTable); Hope this helps, Regards, Dahlsgaard Jan [EMAIL PROTECTED] wrote: Hi For some time I have used TmpLedgerTable to hold some records, and scrolled thru these using a simple while-select:

RE: [development-axapta] Query on temporary table

@yahoogroups.com Subject: [development-axapta] Query on temporary table Hi For some time I have used TmpLedgerTable to hold some records, and scrolled thru these using a simple while-select: tmpLedgerTable.setTmpData(this.tmpdata()); while select tmpLedgerTable { do something } Now, for different reasons

[development-axapta] Query on temporary table

Hi For some time I have used TmpLedgerTable to hold some records, and scrolled thru these using a simple while-select: tmpLedgerTable.setTmpData(this.tmpdata()); while select tmpLedgerTable { do something } Now, for different reasons, I have to change this to a query

[development-axapta] Query in reports

Hi All, I have a report where I need to display the records based on the grouping of WorkcenterID or startdate. I have added a footer with sum for timeleft field. whenever I select a particular workcenter from the dialog query..its working fine displaying the sum for that workcenter. But when

[development-axapta] Query Addrange For Array Fields...!

Hi All, i wanna create querybuild datasource using OR for array fields for ex : show salestable with dimension[1] = 'P-001' or dimension[2] = 'Q-001' i've try with this code, but it didn't work. Query q; QueryBuildDataSourceqbds; QueryRun

[development-axapta] Query Unpack

Hi all, I have a query on my form. When a user runs the query, ranges packed automatically and I can get these values. But I have a problem about unpacking ranges before user run this query. I set interactive(false) and run the query, when the form start, but ranges can't be unpacked

[development-axapta] Query For Back to back report Printing through codes

Hi all, I have one Query. While printing a report in the printer option, if we give the option Back-to-back the printer will print back-to-back page. Is there any we can control that by writing codes. My problem is I want to print one programmable section in the back page of the Last page of

Re: [development-axapta] query form

Hi, Thank you very much. regs, Hema. S Paulius [EMAIL PROTECTED] To: development-axapta@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: Re: [development-axapta] query form groups.com 04/07/2006 05:18 PM Please respond to development-axapta Query q

Re: [development-axapta] query form

Query q = new QUery(queryStr(YourQueryInAOT)); QueryRun qr = new QueryRun( q); ; if( qr.Prompt()) { .. // all further necessary actions } --- [EMAIL PROTECTED] wrote: Hi, how do i call a query form created in Queries node under AOT in forms? And when Ok button is clicked, how do i

[development-axapta] query form

Hi, how do i call a query form created in Queries node under AOT in forms? And when Ok button is clicked, how do i filter populate records based on the query selected? Pls. provide the solution. Thank you. regs, Hema. S YAHOO! GROUPS LINKS Visit your group

Re: [development-axapta] Query

Use the Common type Common tableBuffer; ... tableBuffer=queryRun.get(_tableID) http://axcoder.blogspot.com -Original Message- From: V G [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Date: Wed, 22 Mar 2006 15:45:40 -0500 Subject: [development-axapta] Query I have

[development-axapta] Query

I have a function which takes parameter tableid.In the function I want to write some query on the table that is supplied as the parameter.For writting a query I need to define that table but I dont know which table is going to be passed as parameter. How do I accomplish this. Any help is

[development-axapta] query with or array field

Dear All, There have been a lot of discussion about query with or, but I don't find one that address to array field. I have a query like this, which I need to change it to a query object : select prodtable where prodtable.dimension[1] == 'admin' || prodtable.dimension[2] == 'fina'; I

[development-axapta] Query For modified event of combo

Hi All, can anyone explain me why in case of combobox modified event is called twice firstly on modifying the control and secondly on closing that form which consist that control. I have a requirement in which I have to print a message on modification of the combo control but the message

RE: [development-axapta] Query For modified event of combo

: [development-axapta] Query For modified event of combo Hi All, can anyone explain me why in case of combobox modified event is called twice firstly on modifying the control and secondly on closing that form which consist that control. I have a requirement in which I have to print a message

SV: SV: [development-axapta] Query to 'OR' two ranges

hope they will fix that soon. Thomas. Från: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] För ozzage Skickat: den 6 december 2005 18:39 Till: development-axapta@yahoogroups.com Ämne: Re: SV: [development-axapta] Query to 'OR' two ranges Hi

RE: SV: [development-axapta] Query to 'OR' two ranges

To: development-axapta@yahoogroups.com Subject: SV: SV: [development-axapta] Query to 'OR' two ranges There ought to be a way around though. If no other way is possible you could always send the SQL-query directly to the database through a connection. I have not done it myself but seen others which have

Re: SV: [development-axapta] Query to 'OR' two ranges

: development-axapta@yahoogroups.com [mailto:development- [EMAIL PROTECTED] On Behalf Of Andrew Zekveld Sent: Tuesday, 6 December 2005 12:15 AM To: development-axapta@yahoogroups.com Subject: Re: SV: [development-axapta] Query to 'OR' two ranges Thanks! I got it to work. for those who will be trying

SV: [development-axapta] Query Range and ||

-axapta] Query Range and || Hi, I have table1 with 3 fields. Field1 = id Field2 = Boolean Field3 = Boolean Now I want to build a QueryBuildRange where I get all the id's where either field2 or field3 is true. How would I do this? Thanks Andre YAHOO

SV: [development-axapta] Query to 'OR' two ranges

. Från: development-axapta@yahoogroups.com genom zekvelda Skickat: fr 2005-12-02 09:05 Till: development-axapta@yahoogroups.com Ämne: [development-axapta] Query to 'OR' two ranges Hi I have a request very similiar to post number 12021 concerning 'OR'ing two different fields

Re: SV: [development-axapta] Query to 'OR' two ranges

@yahoogroups.com Ämne: [development-axapta] Query to 'OR' two ranges Hi I have a request very similiar to post number 12021 concerning 'OR'ing two different fields on a table in a query. I've tried the solution proposed in post 12021 with no success. My scenariois as follows: I have

RE: SV: [development-axapta] Query to 'OR' two ranges

:[EMAIL PROTECTED] On Behalf Of Andrew Zekveld Sent: Tuesday, 6 December 2005 12:15 AM To: development-axapta@yahoogroups.com Subject: Re: SV: [development-axapta] Query to 'OR' two ranges Thanks! I got it to work. for those who will be trying the solution below: I couldn't get it to work

[development-axapta] Query range - for date

Hi all, I have a range on a query: qry.addDataSource(tablenum(CustInvoiceJour)).addRange(fieldnum(CustInvoiceJo ur, InvoiceDate)); I use this value: dateRange = qryRun.query().dataSourceTable(tablenum(CustInvoiceJour)).rangeField(fieldnu m(CustInvoiceJour, InvoiceDate)).value(); This value

RE: [development-axapta] Query Range

: [development-axapta] Query Range I am overriding the prodtable_ds query on the prodtable form. I would like to filter out the results for only the person logged in user curusrid(). To do this I am trying to select all records where prodtable.createdby == curusrid() || prodtable.modifiedby

RE: [development-axapta] Query Range

@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of yacovett_lee Sent: 6. juni 2005 21:12 To: development-axapta@yahoogroups.com Subject: [development-axapta] Query Range I am overriding the prodtable_ds query on the prodtable form. I would like to filter out the results for only the person logged

RE : [development-axapta] Query Range

@yahoogroups.com Objet : RE: [development-axapta] Query Range I trid to use this, but I get an Unable to parse the value error. I figured this was hw to fix this problem, but I can't figure out the syntax. I also tried adding prodtable. before the ranges, but I got the same error. Erik Hansen

Re: RE : [development-axapta] Query Range

- De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Lee Yacovett Envoyé : 7 juin 2005 08:50 À : development-axapta@yahoogroups.com Objet : RE: [development-axapta] Query Range I trid to use this, but I get an Unable to parse the value error. I figured this was hw

[development-axapta] query range - like

I want to create query range with like and or criteria, something like this : (SQL Statement) select accountnum, voucher, * from ledgerjournaltrans where voucher like '%CPP%' or voucher like '%RV%' My statement rises an error if I wrote it like this one in X++ : sCrit = strFmt('((Voucher

[development-axapta] Query Validation

Dear All, I am a new developer in Axapta 2.5.3. I have a question. Now I have a query box that there are inventrans.itemid, inventtrans.DatePhysical. How can I validate that user must input the itemid and datephysical? Thanks. Ivan Yahoo! Groups Links To visit your group

RE: [development-axapta] Query Dimension

Hi, try this: this.query().dataSourceNo(2).addRange(fieldId2Ext(fieldnum(ProdBOM,Dimension),1)).value(QueryValue('SubCon')); Michael From: kamchung322 [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [development-axapta] Query Dimension Date: Mon, 06 Dec 2004

[development-axapta] Query Dimension

Hi All, How can I only query Dimension[1] value = 'SubCon'. I try to use the following code but it will filter Dimension[1] = 'SubCon', Dimension [2] = 'SubCon' and Dimension[3] = 'SubCon' this.query().dataSourceNo(2).addRange(FieldNum(ProdBOM, Dimension)).value(QueryValue('SubCon'));

[development-axapta] Query in Report

Hi all, Can i use the existing Query in a Report has filtering criteria. For Example PurchInvent is a query i wan't to use it in a Report to generate a Report, can i do it ? if so how ? Thax in advance. Regards, jay Yahoo! Groups Sponsor ADVERTISEMENT

[development-axapta] Query with join in X++ code

Hi, I have headdata (Table head) and linedata (table line). Instead of showing all headdata and selecting linedata, I want to show all linedata and select the corresponding headdata. This works fine, I have joined headdatasource to linedata. My problem concerns the filter on my headdata. To

[development-axapta] Query (Move back)

Hi all; When i move on a Query, i can't move back on Query's data source. Is there a way to do it. What i need is to move on LedgerTrans and if total Credit and Debit for these lines are equal, i don't want to show these lines. I'm looking for clonning of Query and moving on cloned one, so

[development-axapta] Query

Hi Experts, I need to display rows from the header tableVendPackingSlipJour, where by the warehouse fieldin the related chilid table, VendPackingSlipTrans, equals to "ABC". This is the codes that I had came up with:

RE: [development-axapta] Query with ORDER BY and GROUP BY

My guess is that order by sum... is the culprit try using the alias instead HTH Pieter -Original Message-From: Don Price [mailto:[EMAIL PROTECTED]Sent: 22. april 2004 17:50To: [EMAIL PROTECTED]Subject: RE: [development-axapta] Query with ORDER BY and GROUP BY One

RE: [development-axapta] Query with ORDER BY and GROUP BY

: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement? In SQL92 it would look like this: SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount, ITEMID FROM CUSTINVOICETRANS WHERE (INVOICEDATE

[development-axapta] Query with ORDER BY and GROUP BY

Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement? In SQL92 it would look like this: SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount, ITEMID FROM CUSTINVOICETRANS WHERE (INVOICEDATE = CONVERT(DATETIME, '2004-01-07 00:00:00', 102)) GROUP BY ITEMID

Re: [development-axapta] Query with ORDER BY and GROUP BY

, ', ', custInvoiceTrans.Qty, ', ', custInvoiceTrans.LineAmount;}} - Original Message - From: Werner Briedl To: [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 3:01 AM Subject: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can

AW: [development-axapta] Query with ORDER BY and GROUP BY

by sum(LineAmount) desc{} regards, Werner. Von: Ing. Gonzalo Bastos S. [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 22. April 2004 15:41An: [EMAIL PROTECTED]Betreff: Re: [development-axapta] Query with ORDER BY and GROUP BY Hi Werner: The sintax of the first SQL Statement is good, a SQL

RE: [development-axapta] Query with ORDER BY and GROUP BY

(sqlTable.getInt(1)); //or whatever you need } Don -Original Message- From: Werner Briedl [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 22, 2004 4:02 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can i use the ORDER

RE: [development-axapta] Query with ORDER BY and GROUP BY

-Original Message- From: Werner Briedl [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 22, 2004 4:02 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement

RE: [development-axapta] Query logic OR

that is to be displayed? RegardsBjørn -Original Message-From: Michael Niemeyer [mailto:[EMAIL PROTECTED] Sent: 19. april 2004 09:14To: [EMAIL PROTECTED]Subject: RE: [development-axapta] Query logic ORHi!An example from CustTable:((Name == "Velofix AG") || (InvoiceAccount == "

[development-axapta] Query Configuration

Dear all, I am trying to generate an overview of the configuration keys and their parents in the system. I am targetting at displaying which of the keys are enable and which are not. I want to have the output exported to a fle or else printed. I have 4 main questions: 1.Can someoneexplain

[development-axapta] Query problem

Hello !! Could someone help me with one problem ? I make a report, in this report I use my own Querry and when user run report Axapta dont remeber last user setting. User must manualy choose option "Previously user settings" from "Load and Save" tab. How can I set this option