Hallo,

I have a question about datasource definitnions in Formspider Mobile. What I want to do:

I want show a repeatPanel and display data which I receive by the query of the datasource definition which I use in the repeatPanel. This query joins two tables. Here is the query:

select * from shinken.objects so, shinken.servicestatus ss where so.Name1 like 'DB' and ss.current_state <> 0 and ss.problem_has_been_acknowledged = 0 and so.ID = ss.service_object_id

When I try to apply this query in the datasource definition I get the error message: ORA-00918: column ambiguously defined

Can you help me what I'm doing wrong?

Kind regards, Lisa

asked 30 Jan '14, 07:54

Lisa's gravatar image

Lisa
1716
accept rate: 0%


Hi Lisa,

These tables have several column names in common. So Formspider cannot distinguish between them. Specify each column you want to use with its name and prefix in the SELECT section. If you end up referencing two columns with the same name (but different prefix) use an alias for one of the columns.

Kind Regards,
Yalim

link

answered 30 Jan '14, 07:59

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Thank you for your fast answer.

Now I get another alert which I don't really understand:

Deleted Column ID is already in use. Please remove references to this Column before updating Datasource Definition.

link

answered 30 Jan '14, 08:06

Lisa's gravatar image

Lisa
1716
accept rate: 0%

Solved the problem.

Kind Regards, Lisa

link

answered 30 Jan '14, 08:19

Lisa's gravatar image

Lisa
1716
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×61
×19

Asked: 30 Jan '14, 07:54

Seen: 1,325 times

Last updated: 30 Jan '14, 08:19


© Copyright Gerger 2017