Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to show Custom tex...
Microsoft Dynamics NAV (Archived)

How to show Custom text like 'NAV' in one column and combination of static text and table column value in one column in Query

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All,

I have a requirement like need to get data from 2 tables TableA and TableB from navision to other application and need to get some custom columns  other than Table columns don't have in TableA and Table B in Navision 2016. 

EX: 

Query Designer
Type Data Source Name Method Type  Method Group By
DataItem TableA <TableA>
Column  TableA.Column1 <TableA.Column1> None
Column TableA.Column3 <TableA.Column3> None
Column 'Nav' Source None
DataItem TableB <TableB>
Column TableB.Column1 <TableB.Column1> None

And the output should be like

TableA.Column1 TableA.Column3 Source TableB.Column1
123 xyz Nav 90.90
234 abc Nav 87.78

Thanks in Advance for you help.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to show Custom text like 'NAV' in one column and combination of static text and table column value in one column in Query

    Thanks Hannes,

    Yes, I have created a page and exposed the data using a WebService. In Page i can create a custom field and assign the static text to it.

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: How to show Custom text like 'NAV' in one column and combination of static text and table column value in one column in Query

    Yes Suresh is right.

    You would have to create a custom field in the Source-Table to achieve that result.

    Queries in NAV just do exists to retrieve data with good performance.

    When you want to expose your data using a WebService, a Page might fulfil your requirements.

    Otherwise I would recommend to query the data using a SQL-Query. That will provide you more options in manipulating the result.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to show Custom text like 'NAV' in one column and combination of static text and table column value in one column in Query

    Yes, We can create a local variable and assign the value to that. But we can not use that variable as a field in Query

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: How to show Custom text like 'NAV' in one column and combination of static text and table column value in one column in Query

    I don't think you can do that using the query. It should be a column

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: How to show Custom text like 'NAV' in one column and combination of static text and table column value in one column in Query

    You can create a variable in your query object, assign a value to this variable and return that variable as a query field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans