cancel
Showing results for 
Search instead for 
Did you mean: 

Issue after adding an SADL Query in OWL ( Thing type genrated )

dhruv_mehta
Active Contributor
0 Kudos

Dear All,

I have created a custom BO and its screen using thing type navigation. In OWL genrated we alreade have a query ( Querybyelements) now which is defaultset, now as we needed to use SADL as we required a search text , we created an SADL query with its FindForm and all,

Now issue is when i query the data using SADL Query ( Default set 1) no data is coming and when I use Querybyelemnt query system throws exception.

If i delete the SADL Query and keep only normal one system displays all data.

I am confused now , frankly I only want to use SADL query but data is not coming ( its not able to fetch the data) , is there something i m missing?

This is very frustrating when a simple SADL query doesnt return the values and you have to raise the issue on scn

Help is appriciated

Thanks in advanced

Dhruvin

Accepted Solutions (1)

Accepted Solutions (1)

dhruv_mehta
Active Contributor
0 Kudos

Hi Alessandro,

Below are all the screens.

1. Query 1 : SADL ( which is showing no results)

Below is the binding for search parameters/

Result Parameter binding for SADL

Find Forms:

Default Set Mapping is also done.

This is the config for SADL , Bydefault we have had Querybyelements which is giving dump now

one query doesent give result and one query gives exception

Former Member
0 Kudos

In the SADL did you flag as "selection" the fields tradeid/tradename? I think in the SADL you should also bind the fields in the data model with the selection parameters.

former_member200567
Active Contributor

Hi,

   You don't need to explicitly bind your search parameters.

     It is implicitly done by the system.

    In the SADL query, you see  "Selection", "Basic Find", "Result".

1. When you create a SADL query, you get a new Search Parameter in the data model.

2. When you check "Selection" for a particular field , you will see a new field under the search parameter STRUCTURE.(that will search your requirement)

3. When you check "Basic Find" for that particular field, you will get a new search text field under the same search parameter STRUCTURE.(that search text will search for every field for which you have "Basic Find" checked).

  4.When you check "Result" for that field, you can use that field for showing on the data list.

This is just my knowledge.

So, please point out if there is some misunderstanding.

Regards,

Fred.

Former Member
0 Kudos

Uhmmm ok, I am not so expert in SADL queries, my question was just to ensure that all was fine. So... maybe there is a conflict between the standard query and the custom one? In the other post the same issue was solved creating a query BO-based instead of a SADL.

former_member200567
Active Contributor
0 Kudos

Hi,

     I must confess that BO-based is more easy to use and kind of robust .

     I am not also an expert in SADL queries.

     It would be great someone could explain more about using SADL queries.

Regards,

Fred.

former_member200567
Active Contributor
0 Kudos

Hi,

     There are still some requirements to get that SADL query work.

     I am sorry that I don't have much time today.

     I will share some more info tmw.

Regards,

Fred.

dhruv_mehta
Active Contributor

Dear All ,I have deleted the SADL Query and created that again.

it is miracally some how working now i dont know what went wrong!

Former Member
0 Kudos

Wow!! Great! ahaha

former_member200567
Active Contributor
0 Kudos

Yeah, that's great.

Answers (1)

Answers (1)

Former Member
0 Kudos

Try with a normal custom query on your BO and let me know. I am not so experienced in the OWL "field"

dhruv_mehta
Active Contributor
0 Kudos

i tried with righjt clicking and execute query data is coming

Former Member
0 Kudos

Can you send me the screenshot of the bind between the query parameter and the field you are using on the screen?