Hi,
I couldn't make this query run select * from <domain> order by <attribute> asc. Throwing exception The sort attribute must be present in at least one of the predicates, and the predicate cannot contain the is null operator.

Any help will be appropriated.
Thanks

The format of Select API is

Code: Select all

select output_list 
from domain_name 
[where expression] 
[sort_instructions] 
[limit limit]

In your case the exception is Invalid Sort Expression. Your query statement require attest one predicate for where clause.

Thanks

You can run query :-

select * from <domain> where <Attribute> is not null order by <Attribute> asc/desc

Thanks

Thanks for help but I am not getting results sorted for the given Attribute in above SELECT Query?

In this version of SDB Explorer, by default we are showing the sorted data by the first attribute name in ascending order.

You can select the desired attribute by which you would like to sort in combo box near sort by button. Check either ascending or descending as per your choice. Click on Sort By button and you will get your data in sorted order as per your selected attribute.

You can also get your sorted results by SELECT API in our next release.

Thanks

Hi,

I am using SDB Explorer, I am trying a query to search a record from a domain but it did not work . my query is -
select * from <domain-name> where Sdb-Item-Name='101010'

Though,I can do this with the "Search Item Name" option available on the domain as it works perfect but i just wanna know , why the above query went wrong?

Thanks,
Remon hill

Hi,

You must try the query like :

Select * from <domain-name> where itemname()='101010' since SdbItemName is not the Attribute, it just a display name for the first column in each domain in the SDB Explorer.


Thanks,
Dushyant Kumar Masta

I couldn't make it run : -
select * from mydomain where Age < '25' and Year < '2010'.

Plse help.

Thanks

Both predicates must be same in your query.

Thanks